We are using sql 2008r2 (sp2) Enterprise edition, mirroring has to be configured as per the requirement but after checking the database properties & tasks- mirror it is known that this feature is not available in this instance. first why this option is not in this instance, second can we have any option to bring this feature back.
Please share your view on this.
- Edited by Shiva Shakthi Thursday, August 29, 2013 11:25 AM
Do you see any error when you are trying to click on Mirroring on database properties page.Please paste if any error or message you are getting
You could also use TSQL method to configure mirroirng.
Hello please refer to this link and se if issue mentioned in Below link is your problem
Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers
- Proposed as answer by vr.babu Thursday, August 29, 2013 1:02 PM
When you install SQL Server, did you select Management Tools - Complete in the Feature select page? The following thread is about same issue caused by the Management Tools, you can also try to connect to SQL Server instance with other SSMS to check whether the issue presits.
What's more, We cannot mirror the master, msdb, temp, or model databases. Database mirroring cannot be configured for a database that contains FILESTREAM filegroups.
Reference:Prerequisites, Restrictions, and Recommendations for Database Mirroring
TechNet Community Support
- Proposed as answer by Fanny LiuMicrosoft contingent staff, Moderator Friday, September 06, 2013 12:42 PM