Copy-only backup are new feature in SQL 2005. It allows a backup of any type to be taken without affecting any other backups. Copy-only backup doesn’t affect the restore chain. It cannot be used as a restored base in the event of failure. They are useful in a situation where you want to get a copy of the database for testing purposes or when you want to refresh the staging, development and testing databases.
Copy-only backups are not supported via SQL Server Management Studio(SSMS). It must be performed using T-SQL Backup command.
Backup Database MYDATABASE
TO DISK = 'Drive\Folder\filename.bak'
WITH COPY-ONLY
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment