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: 2 days ago @ 10:52 AM
Points: 202, Visits: 354
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: 2 days ago @ 10:52 AM
Points: 202, Visits: 354
can someone help me with this?
Post #1487500
Posted Thursday, August 22, 2013 1:50 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Friday, August 15, 2014 5:01 PM
Points: 1,613, Visits: 1,539
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: 2 days ago @ 10:52 AM
Points: 202, Visits: 354
Thanks Robert. It did work.
Post #1487506
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse