SQL Server Performance

database mirroring for sharepoint database is giving an error

Discussion in 'SQL Server 2005 Database Mirroring' started by priyaram, Apr 16, 2008.

  1. priyaram New Member

    when i try to establish mirroring with the below command i am getting an error..alter
    database SharePoint_AdminContent_c32bc-190-4-b1-1cabset
    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...
  2. Akthar New Member

    Can you try to setup the Mirror using Management Studio, by right click on the database Tasks - Mirrorring
  3. ghemant Moderator

    suggests to refer http://sqlserver-qa.net/blogs/ha/archive/2007/11/12/database-mirroring-sys-sp-dbmmonitorupdate-stored-procedure-fails-with-error-incorrect-syntax-near.aspx
  4. Walter Castillo New Member

    You have to use doble quotes for the database name, like "SharePoint_AdminContent_c32bc-190-4-b1-1cab"
    Because the sql doesn't understand the "-"

Share This Page