Regarding, which transaction log restore after full restore

Compresses, encrypts, secures and monitors SQL Server backups.

Regarding, which transaction log restore after full restore

Postby raj_technoman » Mon Mar 17, 2014 2:46 pm

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)â€
Posts: 7
Joined: Tue Feb 18, 2014 5:19 pm

Postby petey » Tue Mar 18, 2014 4:11 am

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 7
Posts: 2309
Joined: Sun Apr 24, 2005 11:34 am

Return to SQL Backup 7

Who is online

Users browsing this forum: No registered users and 0 guests