Forum Replies Created

Viewing 2 posts - 1 through 2 (of 2 total)

  • RE: shrinking databases

    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...

  • RE: How to get the log file to shrink in SQL 2005?

    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...

Viewing 2 posts - 1 through 2 (of 2 total)