[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 275
  • Last Modified:

Not able to restore SQL Server Database

Hello Experts,
I have taken a backup from my production MS SQL Server 2000  database and the file name is salesOrders.bak.

In SQL Server 2008 Management Studio, I created a database, SalesOrders using the wizard. On database right clicked and Tasks and Restore from File group and selected the above mentioned .dat file.

After selecting the SalesOrders.back file, I did select the option to replace the database.
It is not allowing me to restore and I am getting the error that the backup contains more than one database error 3154.

I would really appreciate if you can help in this regard.

Thanks



I did search in the internet and I am not able to find a good solution for this.

I would really appreciate your help..

0
rowmark
Asked:
rowmark
  • 4
  • 2
1 Solution
 
tbsgadiCommented:
Hi,

"If you encountered Error 3154 during a restore operation, overwrite the existing database by reissuing the RESTORE DATABASE command using the WITH REPLACE clause, or restore the backup set to a different database name.

The error 3154 indicates that you tried to restore database over an existing database, but the existing database was created by a different CREATE DATABASE statement than the database in the backup set. "


http://www.databasejournal.com/features/mssql/article.php/1547551/Troubleshooting-SQL-Server-BackupRestore-Problems.htm

Gary
0
 
rowmarkAuthor Commented:
Gary,
Thanks for your response. As I mentioned in my post I did check the box to Replace the existing DB and am still getting this error. I am trying this for the past 2 days and searched the internet and nothing is working.

Thanks
0
 
tbsgadiCommented:
Did you try restoring to a different name?
0
Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

 
rowmarkAuthor Commented:
Yes I did. I deleted the database I created and used a different name and tried to restore it.
0
 
rowmarkAuthor Commented:
Guys Please help me I am still having this issue for the past 2 days.

Thanks
restore-db.jpg
0
 
rowmarkAuthor Commented:
Found the issue with this one. Instead of creating a new database manually and then restoring. Right click on the databases select Tasks-->Restore and then enter a new database name and then try to restore and it will work
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now