question

ylli.d avatar image
ylli.d asked

Single User Mode on Mirrorring DB

Hello, i need to repair a database after dbcc checkdb resulted with consistency errors. My problem is that i cannot take the database to single_user mode because it is in a AlwaysOn Group. Any suggestions on how to perform this task? Thanks..
mirroring
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
sqlaj 1 avatar image
sqlaj 1 answered
If you have not already I would confirm the issues are not auto repairable as mentioned on this page. http://technet.microsoft.com/en-us/library/bb677167.aspx You can you optionally move a copy (backup) to a different server to perform the CHECKDB against. As for removing a primary database from an Availability Group look at this page. http://technet.microsoft.com/en-us/library/hh213326.aspx
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.