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: Yesterday @ 6:06 PM
Points: 228, Visits: 412
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: Yesterday @ 6:06 PM
Points: 228, Visits: 412
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 @ 4:31 PM
Points: 1,625, Visits: 1,580
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 MVP
Principal Database Architect (consultant) at DB Best Technologies
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: Yesterday @ 6:06 PM
Points: 228, Visits: 412
Thanks Robert. It did work.
Post #1487506
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse