Thursday, August 09, 2012 12:47 PM
We are using the copy_only t-sql method to back up a specific databases, however when we try to restore the databases from same backup files (copy_only), ther is no restore set to choose.
SQL version - MSSQL 2005 SP4
Please let me know any other method to overcome the issue.
Thursday, August 09, 2012 1:12 PM
Could you explain the method and commands used?
I've just tried the following and this works OK.
create database myDB
backup database myDB to disk = 'M:\myDB.bak' with copy_only
drop database myDB
restore database myDB from disk = 'M:\myDB.bak'
Jack Vamvas sqlserver-dba.com
Thursday, August 09, 2012 1:13 PM
backup set might be corrupted, are any version diffrences, use this query to verify the database
restore database verifyonly from disk='path of the backup set'
i suggest you to a fresh backup and try to restore
Ramesh Babu Vavilla MCTS,MSBI
Thursday, August 09, 2012 6:54 PMThe GUI (SSMS) doesn't suggest restoring COPY_ONLY fines when you use the backup history (whcih is the default in the GUI). Use from device or just type the RESTORE command in a query windows. I reported this at connect a long time ago, and apparently, this is by design.