locked
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';

    go

     

    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...

     

     

    thanks

     

     

    Tuesday, April 15, 2008 4:33 PM

Answers

  • 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