Log shipping copy job is failing in SQL Server 2008

• gary1

  SSC-Insane

  Points: 21152

  More actions

  November 1, 2010 at 9:41 pm

  #225741

  Hi, we are using log shipping for disaster recovery in production on SQL Server 2008 SP1.

  All of the sudden, all the copy jobs are failing and after some time the restore job also failed

  Log shipping copy job is failing in SQL Server 2008 with the below message:

  Date11/1/2010 6:45:01 PM

  LogJob History (LSCopy_Mydb)

  Step ID1

  ServerSQL1\INS1

  Job NameLSCopy_Mydb

  Step NameLog shipping copy job step.

  Duration00:02:43

  Sql Severity0

  Sql Message ID0

  Operator Emailed

  Operator Net sent

  Operator Paged

  Retries Attempted0

  Message

  2010-11-01 18:47:44.90*** Error: The specified network name is no longer available

  and the restore job is failed with the below message:

  The backup data at the end of "\\DR1\Logshipping_Backups\Mydb_20101101234500.trn" is incorrectly formatted. Backup sets on the media might be damaged and unusable. To determine the backup sets on the media, use RESTORE HEADERONLY. To determine the usability of the backup sets, run RESTORE VERIFYONLY. If all of the backup sets are incomplete, reformat the media using BACKUP WITH FORMAT, which destroys all the backup sets.

  Could you please advice?

  Thanks

• Patrick_Fiedler

  SSCommitted

  Points: 1904

  More actions

  November 2, 2010 at 2:06 am

  #1245226

  Hi,

  are backing up up the logs on local disk or on network share?

  if so then change your backing up folder to local disk, because if the network connection is broken while backing up, the backup is also broken.

  Greets pitcher

  [font="Arial"]Kind regards,

  Patrick Fiedler
  Consultant

  Fiedler SQL Consulting

  www.fiedler-sql-consulting.de
  [/font]