Restore Database

Horse06Horse06 Member Posts: 496
edited 2013-09-20 in SQL General
I am trying to restore the database in SQL Server 2012. I logged in under SQL Server Authentication, not Windows Authentication in the management studio, backed up the database and then created new database . After the data were restored to the new database, it had an error as below. Please advise! Thank you!

Restore of database 'demo2013-test' failed. However, the tail-log backup operation completed successflly. (Micrsofot. SqlServer.Management.RelationalEngineTasks)

Additional information:
system.data.sqlClient.SqlError: The backup set holds a backup of a database other than the exising 'DEMO2013-Test' database. (Microsofot.SqlServer.SmoExtended)


  • Options
    bbrownbbrown Member Posts: 3,268
    Don't create the database before doing the restore. The restore wil create the database.
    There are no bugs - only undocumented features.
Sign In or Register to comment.