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

  • If your database is in full recovery mode, you can backup the Transaction log and then shrink the file.

    If your database is in simple recovery mode, you can just shrink the log file.

    However, also keep track of the size of the transaction log file initial size value. if this is set to too high, you will not be able to shrink your file below this size. you should reduce this limit first.