Sign in
 
HomeLibraryLearnDownloadsTroubleshootingCommunityForums
SQL Server Developer Center >
> 
> 
Database Restore with Copy_only files

Answered Database Restore with Copy_only files

  • Thursday, August 09, 2012 12:47 PM
     
     
    Sign In to Vote
    0

    Hi All,

    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.

    Thanks

    Raghu

     

All Replies

  • Thursday, August 09, 2012 1:12 PM
     
     
    Sign In to Vote
    0

    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
     
     
    Sign In to Vote
    0

    Option 1

    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 PM
     
     Answered
    Sign In to Vote
    0
    The 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.

    Tibor Karaszi, SQL Server MVP | web | blog