Snapshot Job failure

• SqlDBA-437129

  SSC-Addicted

  Points: 450

  More actions

  June 1, 2007 at 7:27 am

  #68681

  Hi I have setup a snapshot job which creates a new table in the same database using an existing table.

   

  I get the following job failure message

  There is already an object named 'PKPS'in the database. [SQLSTATE 42S01] (Error 2714)  Could not create constraint. See previous errors. [SQLSTATE 42000] (Error 1750).  The step failed.

   

   

  Please advice

• Sugesh Kumar

  One Orange Chip

  Points: 27311

  More actions

  June 1, 2007 at 7:33 am

  #710326

  You can't create a table with the same name. If you would like to take backup of tables daily or periodically then you can use the script written by me and posted @ my @ http://sugeshkr.blogspot.com

  Cheers,
  Sugeshkumar Rajendran
  SQL Server MVP
  http://sugeshkr.blogspot.com

• Maverick100877

  SSCertifiable

  Points: 5240

  More actions

  June 1, 2007 at 9:37 am

  #710370

  The error message is very clear. the table is having a constraint named PKPS and when you are again creating the table then it is also building the constraint and giving error.