Log Shipping Problem

• vs.satheesh

  SSCrazy

  Points: 2392

  More actions

  May 6, 2016 at 3:13 am

  #147657

  Hi

  In my log shipping configuration, i did mistake for delete the job manually.Now i want to remove log shipping .But i am facing following error.

  TITLE: Microsoft SQL Server Management Studio

  ------------------------------

  The current log shipping configuration is not functional because the required backup job cannot be found. You must drop the current configuration by clearing the 'Enable this as a primary database in a log shipping configuration' checkbox. To resume log shipping, recreate the configuration using the same settings.

  If you resume log shipping and you specify the backup and restore paths that you used before, any backup files from the old configuration that are uncopied or unrestored will be copied and restored by the new configuration. Reinitializing the secondary database(s) is unnecessary.

  ------------------------------

  ADDITIONAL INFORMATION:

  The specified @job_id ('990789BC-7270-481E-B318-2DB95A24A124') does not exist. (Microsoft SQL Server, Error: 14262)

  For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=14262&LinkId=20476

  ------------------------------

  BUTTONS:

  OK

  ------------------------------

  Please give me solution.