August 31, 2009 at 1:40 am
I have received a backup of a databse from a client who uses databse mirroring. When I tried to restore the database on my server I received the folowing error:
TITLE: Microsoft SQL Server Management Studio
------------------------------
Restore failed for Server 'X'. (Microsoft.SqlServer.Smo)
------------------------------
ADDITIONAL INFORMATION:
System.Data.SqlClient.SqlError: RESTORE cannot operate on database 'X' because it is configured for database mirroring. Use ALTER DATABASE to remove mirroring if you intend to restore the database. (Microsoft.SqlServer.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
Is there a way I can remove mirroring during the restore process so that I can restore this database?
Any help is greatly appreciated.
August 31, 2009 at 5:42 am
August 31, 2009 at 6:33 am
the above gandlf sended link will use full for it .
August 31, 2009 at 5:31 pm
Thanks for the link. Unfortunately it didn't help. It suggests that the mirror needs to be disabled before the backup but I have already been given the backup file by the client where mirroring was not disabled.
There is a lot of red tape involved with getting a copy of their database so I would prefer if I didn't have to get them to back it up again without mirroring turned on.
August 31, 2009 at 7:11 pm
There must be something else going on here - as I can take a backup from prod (mirrored) and restore it to QA (non-mirrored) with no problems.
Is it possible that you are trying to restore over an existing database (on your system) that has mirroring enabled? That would make more sense to me - but I am just guessing here.
The other guess I had was that you are not trying to restore - but attach. If trying to attach, that might also cause the same kind of message. Not sure if that is the case - again, just guessing.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
September 1, 2009 at 5:40 pm
Thanks Jeffrey. Your first comment led me to retry the restore but with new data and log file names instead of trying to restore over the top of the existing data and log files and the restored worked correctly.
September 1, 2009 at 7:32 pm
That's great - glad you were able to get past that problem.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply