rowmark
asked on
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..
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..
ASKER
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Yes I did. I deleted the database I created and used a different name and tried to restore it.
ASKER
ASKER
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
"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