RESTORE cannot operate on database because it is configured for database mirroring Use ALTER DATABASE to remove mirroring if you intend to restore the database

RESTORE cannot operate on database because it is configured for database mirroring Use ALTER DATABASE to remove mirroring if you intend to restore the database
 ALTER DATABASE YOur_Database_Name SET PARTNER OFF

Now, to remove mirroring you can execute

RESTORE DATABASE  YOur_Database_Name  WITH RECOVERY

Tags:

Database mirroring is currently provided for evaluation purposes only and is not to be used in production environments To enable database mirroring for evaluation purposes use trace flag 1400 during startupThe shrink operation is not duplicated on the mirror database when you use database mirroring in SQL Server 2005Sql Server MirroringRemove internet explorerMS SQL server mirroring remove end points master keyHTML5 With DataBase[C#] Remove Last Character From Stringhow to remove Google ChromeHow to remove Security TagsRemove net framework 40JQuery add/remove Class Dynamically

Author

My name is Satalaj, but people call me Sat. Here is my homepage: . I live in Pune, PN and work as a Software Engineer. I'm former MVP in ASP.net year 2010.
Disclaimer: Views or opinion expressed here are my personal research and it has nothing to do with my employer. You are free to use the code, ideas/hints in your projects. However, you should not copy and paste my original content to other web sites. Feel free to copy or extend the code.
If you want to fight with me, this website is not for you.
 

I'm Satalaj.