Post reply

Sharepoint DB Mirror failure

  • August 22, 2013 at 3:20 am

    #298062

    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

  • August 22, 2013 at 1:48 pm

    #1644123

    can someone help me with this?

  • August 22, 2013 at 1:50 pm

    #1644125

    first of all, use square brackets around the database name:

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

    My blog: SQL Soldier[/url]
    SQL Server Best Practices:     SQL Server Best Practices
    Twitter: @SQLSoldier
    My book: Pro SQL Server 2008 Mirroring[/url]
    Microsoft Certified Master: SQL Server, Data Platform MVP
    Database Engineer at BlueMountain Capital Management[/url]

  • August 22, 2013 at 1:52 pm

    #1644128

    Thanks Robert. It did work.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply