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)
No comments:
Post a Comment