http://www.sqlservercentral.com/blogs/steve_jones/2012/05/24/always-restore-with-norecovery/

Printed 2014/09/23 02:30AM

Always restore with NORECOVERY

2012/05/24

Always, always, ALWAYS restore a SQL Server database with the NORECOVERY option.

It’s trivial to switch the database online.

Not trivial to recover from an accidental restore with RECOVERY (the default)

‘nuff said.


Filed under: Blog Tagged: Backup/Recovery, disaster recovery, sql server, syndicated
Copyright © 2002-2014 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.