mirroring setup for sharepoint database RRS feed

  • Question


    when i try to establish mirroring with the below command i am getting an error..


    alter database SharePoint_AdminContent_c32bc-190-4-b1-1cab

    set partner = 'tcp://mirror-server.3000';



    the error :


    Msg 102, Level 15, State 1, Line 1

    Incorrect syntax near '-'.


    i am not sure why it's throwing an error..any help would be appreciated...






    Tuesday, April 15, 2008 4:33 PM


  • To use a database name with a - in it you have to bracket the name [dbname]



    Code Snippet

    alter database [SharePoint_AdminContent_c32bc-190-4-b1-1cab]

    set partner = 'tcp://mirror-server.3000';



    Wednesday, April 16, 2008 1:27 PM