What are the challenges you face when working across database platforms? Take the survey

Regarding, which transaction log restore after full restore

raj_technomanraj_technoman Posts: 10
edited March 18, 2014 12:11AM in SQL Backup Previous Versions
Hi There,
I have face problem when try to restore transaction log,

Suppose we have two DB servers : SERVER-A and SERVER-B
Database is PayrollDB on SERVER-A, which we want to logshipping on SERVER-B.

We have full back at 3:45 AM every day for PayrollDB on SERVER-A.
And transaction log backup every 10 minutes for every day for entire day.

Our last SERVER-A’s PayrollDB full back up start at 3:45 am and completed at 4:08 am (took around 23 min for full backup).
As transaction log backup at every 10 min , we have transaction log backup at 3:40 am, 3:50 am, 4:00 am, 4:10 am , 4:20 am ,4:30 am , 12:30 pm , 1:00 pm and for entire day.

For Start log shipping , I restore SERVER-A’s PayrollDB with “Non-operational (RESTORE WITH NORECOVERY)â€


  • Options
    peteypetey Posts: 2,358 New member
    SQL Backup generates a log file for each process that it runs. The default folder where the logs are stored is C:\Documents and Settings\All Users\Application Data\Red Gate\SQL Backup\Log\<instance name> on Windows 2003 and older, and C:\ProgramData\Red Gate\SQL Backup\Log\<instance name> on Windows Vista and newer.

    Could you please post the contents of the log for the backups that failed?
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
Sign In or Register to comment.