Post reply

Error when creating backup script with databasename that contains "-"

  • April 24, 2007 at 5:04 am

    #195423

    I'm making backup jobs, and one of the databases has the following name: VPMPATCH_SAN-MANAGE

    I get an error when i try to create the following jobstep:

    BACKUP DATABASE VPMPATCH_SAN-MANAGE TO SAN WITH INIT

    The error is raised because of the "-" in the db name..is there a walkaround for this?

    It's running on 2005.

  • April 24, 2007 at 5:07 am

    #702107

    Nevermind, it worked when i closed everything, and tried with the same code one more time...strange..

  • April 24, 2007 at 5:14 am

    #702111

    Hmm..the creation of the step worked, but when i try to run the job now, i get the following error:

    Executed as user: NT AUTHORITY\SYSTEM. Incorrect syntax near '-'. [SQLSTATE 42000] (Error 102) Incorrect syntax near the keyword 'with'. If this statement is a common table expression or an xmlnamespaces clause, the previous statement must be terminated with a semicolon. [SQLSTATE 42000] (Error 319). The step failed.

    It's created with the syntax in post #1, can anyone help me on this one?

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

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