This error message will produce when we restore our database from the database backup file:
There are following easy steps to resolve this issue:
Step 1:
First right click the existing database which you want to restore than go to:
task => restore => database
as you can see in the below image:
Step 2:
A new wizard will open.Now click on the options then check the checkbox
"Overwrite the existing database (with replace)"
as you can see in the below image.
Now perform the rest of the steps for restoring the database.The error message will not be produce again.
Thanks
Muhammad Zahid.
I did the the same, but still get the same issue. iam on SQL server 2008 R2 with service pack2 and trying to load AX 2012 R2 DB on it.
ReplyDeleteHi Pradeep and welcome to my blog.I think in your case its not possible bacause you are loading SQL server version 2012 R2 db on Sql Server version 2008 R2.So its not possible to load earlier version db on to the older version db.In my case the SQL server version of the backup db is same as the SQL server on which I am loading the backup.
DeleteWell, I came across this blog which is described properly, if u still facing the same issue then visit this blog http://www.sqlrecoverysoftware.net/blog/sql-server-error-3154.html which will help to get rid of this error issue.
ReplyDelete