Will it be successful or will it break the logshipping?

Question

Will it be successful or will it break the logshipping?

forsqlserver

SSCoach

Points: 18902
More actions
June 1, 2011 at 10:54 am

#252066

Hi,
I have sql server 2008 logshipping.It has broken because some Transaction files from DR Site folder has deleted.Therefore except restore job all other jobs are working fine.I have checked TUF file is also in place.
The DB size is 16 GB and it is around 4 months old happening.
Now what I am going to do Stopping all the jobs of Logshipping and restore a full backup of production database to Dr site and start all the jobs as usual.
My question is : Will it be successful or will it break the logshipping?
Thanks

Viewing 7 posts - 1 through 6 (of 6 total)

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

calvo SSChampion Points: 12930 More actions · Answer 1

forsqlserver (6/1/2011)
Hi,
I have sql server 2008 logshipping.It has broken because some Transaction files from DR Site folder has deleted.Therefore except restore job all other jobs are working fine.I have checked TUF file is also in place.
The DB size is 16 GB and it is around 4 months old happening.
Now what I am going to do Stopping all the jobs of Logshipping and restore a full backup of production database to Dr site and start all the jobs as usual.
My question is : Will it be successful or will it break the logshipping?

It's already broken, no? Which means your DR site is way out of sync if it has been happening for four months.

First, I'd figure out why some log files at the dr site have been mysteriously deleted.

______________________________________________________________________________________________
Forum posting etiquette.[/url] Get your answers faster.

forsqlserver SSCoach Points: 18902 More actions · Answer 2

Thanks,

The site was not in our support now before.

Please confirmm my question first.

Thanks

Steve Jones - SSC Editor SSC Guru Points: 736478 More actions · Answer 3

I believe that log shipping should restart. Move over a full backup and then only log files since the full backup completed and log shipping should be able to pick back up.

forsqlserver SSCoach Points: 18902 More actions · Answer 4

Hi Steve,

1.The servers are in XYZ domain.

2.Actually the site was 4 month before and the sa password and the Windows login XYZ\NOC_Admin(using to configure logshipping)password has forgotten.

3.Can I restore the database using my local administrator ID.Beause on DR site the shared folder is not accessible using the local administrator ID yet the copy job is working,I have checked this by seeing the time stamp of theshared folder.

This is the time of need,I know u all will be surprising.

Thanks

Reo Hall of Fame Points: 3774 More actions · Answer 5

Steve Jones - SSC Editor (6/1/2011)
I believe that log shipping should restart. Move over a full backup and then only log files since the full backup completed and log shipping should be able to pick back up.

If your Tran log broken then you have to reconfigure it. But your case you just take the differential backup and then start transaction log backup again without restoring Full backup.

Ram
MSSQL DBA

forsqlserver SSCoach Points: 18902 More actions · Answer 6

On One DB it is completed.

Another is pending..will do it tomorrow.

The restore job was skipping the log file: as below

Date6/2/2011 3:15:00 PM

LogJob History (LSRestore_NOCDB_HYD_HPSM)

Step ID1

ServerNOCDB_MUM

Job NameLSRestore_NOCDB_HYD_HPSM

Step NameLog shipping restore log job step.

Duration00:06:30

Sql Severity0

Sql Message ID0

Operator Emailed

Operator Net sent

Operator Paged

Retries Attempted0

Message

2011-06-02 15:21:30.17Skipped log backup file. Secondary DB: 'HPSM', File: 'E:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\secondaryLogShip\HPSMTran\HPSM_20110425104501.trn'

2011-06-02 15:21:30.20Skipped log backup file. Secondary DB: 'HPSM', File: 'E:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\secondaryLogShip\HPSMTran\HPSM_20110425110001.trn'

Thanks