Viewing 2 posts - 1 through 2 (of 2 total)
Thanks for the tip. I will put these into the script.
BTW, the reason for the concern is that the databases are in the range of about 10 GB total, on...
March 9, 2006 at 2:04 am
#625602
I use the following script, and in combination with transaction log backups and full backups, and repeat executions of this, the database files do shrink:
Use myDB
Checkpoint
DBCC ShrinkDatabase (myDB, 10)
Backup Log...
March 8, 2006 at 8:18 pm
#625577