locked
Database restore-sql 2008 error RRS feed

  • Question

  • Hi,

    I have took sql  2008  database backup successfully .But , when I tried to restore it gives an error message as follows:

    Restore  failed for Server ‘CRM-Server’ (Microsoft.sqlserver.smoextended)

    System.Data.SqlClient.SqlError: The backup set holds a backup of a database other than the existing  ‘CRMServer_MSCRM’ database. (Micorosoft.SqlServer.Smo)

    Thanks in advance!

    Cheers

    Jeriesh


    Cheers : Jeriesh
    Tuesday, May 31, 2011 11:01 AM

Answers

  • You should select over write and norecovery options

    for over right Please check here http://www.mssqltips.com/tutorial.asp?tutorial=121

     

    Syntax sample

    RESTORE DATABASE AdventureWorks FROM DISK = 'C:\AdventureWorks.BAK'
    WITH REPLACE, norecovery
    GO

    http://uk.linkedin.com/in/ramjaddu
    • Marked as answer by WeiLin Qiao Thursday, June 2, 2011 3:00 AM
    Tuesday, May 31, 2011 11:10 AM
  • Hi,

      Thanks a lot....

    Finally i got solution

    Go to -->Restore -->select the backup file (it should have the extension .bak)-->check the backup file to restore-->go to option-->check over WRITE THE EXISTING DATATBASE(WITH REPLACE)-->Click ok

     

    Cheers

    Jeriesh


    Cheers : Jeriesh
    • Marked as answer by WeiLin Qiao Thursday, June 2, 2011 3:00 AM
    Tuesday, May 31, 2011 11:56 AM

All replies

  • You should select over write and norecovery options

    for over right Please check here http://www.mssqltips.com/tutorial.asp?tutorial=121

     

    Syntax sample

    RESTORE DATABASE AdventureWorks FROM DISK = 'C:\AdventureWorks.BAK'
    WITH REPLACE, norecovery
    GO

    http://uk.linkedin.com/in/ramjaddu
    • Marked as answer by WeiLin Qiao Thursday, June 2, 2011 3:00 AM
    Tuesday, May 31, 2011 11:10 AM
  • Hi,

      Thanks a lot....

    Finally i got solution

    Go to -->Restore -->select the backup file (it should have the extension .bak)-->check the backup file to restore-->go to option-->check over WRITE THE EXISTING DATATBASE(WITH REPLACE)-->Click ok

     

    Cheers

    Jeriesh


    Cheers : Jeriesh
    • Marked as answer by WeiLin Qiao Thursday, June 2, 2011 3:00 AM
    Tuesday, May 31, 2011 11:56 AM
  • Great stuff Jeriesh - Can you please mark it as answer?



    http://uk.linkedin.com/in/ramjaddu
    Tuesday, May 31, 2011 1:01 PM