Michael, When you execute the TRUNCATE, is it normal to see an "error" in the event log pertaining to the logs having been truncated? Is that actually considered an error, and not an information note?
Thanks jlc From: Michael Ross [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 26, 2008 4:54 PM To: NT System Admin Issues Subject: RE: Scripted SQL Backups i use 2 scripts. one backups all databases and logs to 2 files respectively and appends to that file each night. it then shrinks and truncates those files each night. then one night a week, sunday niight, i run one more that does the same thing, but it overwrites those files so i dont fill up the disk. each night, i back up those backup files to tape. if you want my .sql files and an explaination , contact me off list. ________________________________ From: Joseph L. Casale [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 26, 2008 5:18 PM To: NT System Admin Issues Subject: Scripted SQL Backups I'll admit I have _never_ used sql am not sure what to do here. I have a slew of small DB's I need to script a nightly full of to a directory which gets backed up to tape. Can someone push me in the right direction, being that I don't really know anything about SQL, I don't know if the various points I am reading are correct/optimal :) Thanks! jlc ~ Upgrade to Next Generation Antispam/Antivirus with Ninja! ~ ~ <http://www.sunbelt-software.com/SunbeltMessagingNinja.cfm> ~
