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 J Thanks! jlc ~ Upgrade to Next Generation Antispam/Antivirus with Ninja! ~ ~ <http://www.sunbelt-software.com/SunbeltMessagingNinja.cfm> ~
