Home Forums SQL Server 2005 Backups SQL server 2005 Backup & restoration size RE: SQL server 2005 Backup & restoration size

  • I like Grant's suggestion. Don't shrink unless you have to, and then only shrink to the size it should be based on transactions. Make sure you have log backups going.

    If development or test systems are an issue, Idera makes Virtual Database and Red Gate makes Virtual Restore, which can let you mount a backup file as a database.