Interesting. On ours, I generally don't ever bother with the shrink. I've never found it to actually save disk space, since the database contents and log usages trends in exactly one direction (and it's not down). If the space is already allocated, I at least save a few I/Os during operation.
________________________________ From: Michael Ross [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 26, 2008 3: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> ~
