Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Sharepoint DB Mirror failure Expand / Collapse
Author
Message
Posted Thursday, August 22, 2013 3:20 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Saturday, October 18, 2014 9:03 PM
Points: 202, Visits: 358
Our principal server is down.
The sharepoint database is being configured for mirroring.
The name of the database is
SharePoint_AdminContent_e96sd86f-ec29-46655f-b9562a-d0cgch77d3c46
Currently the DB is not accessible and the status of DB is showing up as Mirror Disconnected/In recovery.

ALTER DATABASE dbname SET PARTNER FORCE_SERVICE_ALLOW_DATA_LOSS is not working.
Its throwing a syntax error for using "-" in the database name.
Is there a way I can fix the issue
Post #1487126
Posted Thursday, August 22, 2013 1:48 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Saturday, October 18, 2014 9:03 PM
Points: 202, Visits: 358
can someone help me with this?
Post #1487500
Posted Thursday, August 22, 2013 1:50 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 7:32 PM
Points: 1,618, Visits: 1,550
first of all, use square brackets around the database name:

ALTER DATABASE [SharePoint_AdminContent_e96sd86f-ec29-46655f-b9562a-d0cgch77d3c46] SET ........




My blog: SQL Soldier
Twitter: @SQLSoldier
My book: Pro SQL Server 2008 Mirroring
Microsoft Certified Master: SQL Server 2008
Principal DBA: Outerwall, Inc.
Also available for consulting: SQL DBA Master
Post #1487503
Posted Thursday, August 22, 2013 1:52 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Saturday, October 18, 2014 9:03 PM
Points: 202, Visits: 358
Thanks Robert. It did work.
Post #1487506
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse