Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
MBeal
Posting Yak Master
110 Posts |
 Posted - 2005-01-25 : 13:39:28
|
| My Log Shipping failed so I switched back to complete backups every 2 hours until I can get it up and running again. Originally it was setup to perform transaction log backups every 15 minutes and it seemed to run pretty smooth until I decided to try Log Shipping. Now with complete backups every 2 hours I am experiencing a hit in performance.Log Shipping is new for me and this was my first attempt at getting it to work -- it was working for about one week until it began to fail. My goal is to get Log Shipping to work properly. Any assistance would be greatly appreciated.Here are my steps...Step 1) Disable Transaction Log Backupsexec msdb..sp_update_job @job_id = 0x60C20BEBCA336145BF23F3744C7BC452 , @enabled = 0Step 2) Backup DatabaseBACKUP DATABASE [Data1] TO DISK = N'\\StandbyServer\d$\sql\backups\Data1Bak.bak' WITH INIT , NOUNLOAD , NAME = N' Data1Backup', NOSKIP , STATS = 10, NOFORMATStep 3) Clear Transaction LogBACKUP LOG [Data1] TO DISK = N'\\StandbyServer\d$\sql\backups\Data1Tlog.bak' WITH INIT , NOUNLOAD , NAME = N'TlogBackup', NOSKIP , NO_TRUNCATE, STATS = 10, NOFORMATStep 4) Restore Database on Standby ServerExec StandbyServer.logshipping.dbo.Restore_Data1_BackupStep 5) Enable Transaction Log Backups Againexec msdb..sp_update_job @job_id = 0x60C20BEBCA336145BF23F3744C7BC452 , @enabled = 1The symptoms are as follows... the backup gives you the impression that it succeeds, and it looks like it is failing during the restore step, however the failure on the Sql Server Error Log leads me to believe that the backups are not completing across the wire so it can't restore an incomplete backup."The backup data is incorrectly formatted. Backups cannot be appended, but existing backup sets may still be usable."The additional message is "BACKUP failed to complete the command BACKUP DATABASE..."Any suggestions? Am I missing something obvious?Thank you in advance.MBeal |
|
|
nr
SQLTeam MVY
12543 Posts |
|
|
|
|
|
|
|
Log Shipping