Home Forums SQL Server 2005 Backups Restoring database from production to Dev RE: Restoring database from production to Dev

  • Actually, it can be faster and more reliable than a backup and whats more it will always be consistent. The reason for that is in what happens when the database starts up and performs a recovery. All uncommited transactions are rolled back and makes the file consistent together with all the settings and transaction logs of the original.

    As you quite rightly mentioned though, if downtime (not outage) is not an option then it isn't a viable option anyway.....