Sunday, December 23, 2012

A SQL Backup Option Just for Transferring a Database

Here’s an interesting option when copying a database just to transfer it.  Say to bring down a copy of production to troubleshoot or test.  This allows you to backup a database without affecting the regular backup history or restore ability.

Copy-Only Backups (http://msdn.microsoft.com/en-us/library/ms191495(v=sql.105).aspx)