October 31, 2011 at 5:08 pm
Hello Great DBA's,
The logshipping backup said that the backup was done 1:45AM but the 2:00AM log said that the backup crossed the threshold of 70 mins. I would much appreciate if anyone can help me why this log was generated.
Date,Source,Severity,Message
10/30/2011 02:00:16,Backup,Unknown,Log was backed up. Database: ACCESSCONTROL<c/> creation date(time): 2011/06/23(11:30:16)<c/> first LSN: 129489:67124:1<c/> last LSN: 129489:70311:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=DISK: {'D:\Log shipping Out\ACCESSCONTROL\ACCESSCONTROL_20111030100015.trn'}). This is an informational message only. No user action is required.
10/30/2011 02:00:15,Backup,Unknown,Log was backed up. Database: CARDHOLDERANALYSIS<c/> creation date(time): 2011/06/16(16:39:43)<c/> first LSN: 5340:54:1<c/> last LSN: 5340:142:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=DISK: {'D:\Log shipping Out\CARDHOLDERANALYSIS\CARDHOLDERANALYSIS_20111030100015.trn'}). This is an informational message only. No user action is required.
10/30/2011 02:00:15,Backup,Unknown,Log was backed up. Database: VISITORPASSARCHIVE<c/> creation date(time): 2011/06/23(01:27:48)<c/> first LSN: 246:194:1<c/> last LSN: 246:194:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=DISK: {'D:\Log shipping Out\VISITORPASSARCHIVE\VISITORPASSARCHIVE_20111030100015.trn'}). This is an informational message only. No user action is required.
10/30/2011 02:00:15,Backup,Unknown,Log was backed up. Database: HRSYNC<c/> creation date(time): 2011/06/16(14:44:36)<c/> first LSN: 43:62:1<c/> last LSN: 43:62:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=DISK: {'D:\Log shipping Out\HRSYNC\HRSYNC_20111030100015.trn'}). This is an informational message only. No user action is required.
10/30/2011 02:00:15,Backup,Unknown,Log was backed up. Database: PERFMON<c/> creation date(time): 2011/06/16(14:46:54)<c/> first LSN: 23:2224:1<c/> last LSN: 23:2224:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=DISK: {'D:\Log shipping Out\PERFMON\PERFMON_20111030100015.trn'}). This is an informational message only. No user action is required.
10/30/2011 02:00:15,Backup,Unknown,Log was backed up. Database: LENELUPGRADECUSTOMFIELDFIX<c/> creation date(time): 2011/06/16(14:46:09)<c/> first LSN: 114:135:1<c/> last LSN: 114:135:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=DISK: {'D:\Log shipping Out\LENELUPGRADECUSTOMFIELDFIX\LENELUPGRADECUSTOMFIELDFIX_20111030100015.trn'}). This is an informational message only. No user action is required.
10/30/2011 02:00:15,Backup,Unknown,Log was backed up. Database: PSCV3<c/> creation date(time): 2011/06/16(14:47:30)<c/> first LSN: 4850:391:1<c/> last LSN: 4850:391:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=DISK: {'D:\Log shipping Out\PSCV3\PSCV3_20111030100015.trn'}). This is an informational message only. No user action is required.
10/30/2011 02:00:00,spid140,Unknown,The log shipping primary database FEGUSCNMSDZ09P.VISITORPASSARCHIVE has backup threshold of 60 minutes and has not performed a backup log operation for 70 minutes. Check agent log and logshipping monitor information.
10/30/2011 02:00:00,spid140,Unknown,Error: 14420<c/> Severity: 16<c/> State: 1.
10/30/2011 02:00:00,spid140,Unknown,The log shipping primary database FEGUSCNMSDZ09P.PSCV3 has backup threshold of 60 minutes and has not performed a backup log operation for 70 minutes. Check agent log and logshipping monitor information.
10/30/2011 02:00:00,spid140,Unknown,Error: 14420<c/> Severity: 16<c/> State: 1.
10/30/2011 02:00:00,spid140,Unknown,The log shipping primary database FEGUSCNMSDZ09P.PERFMON has backup threshold of 60 minutes and has not performed a backup log operation for 70 minutes. Check agent log and logshipping monitor information.
10/30/2011 02:00:00,spid140,Unknown,Error: 14420<c/> Severity: 16<c/> State: 1.
10/30/2011 02:00:00,spid140,Unknown,The log shipping primary database FEGUSCNMSDZ09P.LENELUPGRADECUSTOMFIELDFIX has backup threshold of 60 minutes and has not performed a backup log operation for 75 minutes. Check agent log and logshipping monitor information.
10/30/2011 02:00:00,spid140,Unknown,Error: 14420<c/> Severity: 16<c/> State: 1.
10/30/2011 02:00:00,spid140,Unknown,The log shipping primary database FEGUSCNMSDZ09P.HRSYNC has backup threshold of 60 minutes and has not performed a backup log operation for 75 minutes. Check agent log and logshipping monitor information.
10/30/2011 02:00:00,spid140,Unknown,Error: 14420<c/> Severity: 16<c/> State: 1.
10/30/2011 02:00:00,spid140,Unknown,The log shipping primary database FEGUSCNMSDZ09P.CARDHOLDERANALYSIS has backup threshold of 60 minutes and has not performed a backup log operation for 75 minutes. Check agent log and logshipping monitor information.
10/30/2011 02:00:00,spid140,Unknown,Error: 14420<c/> Severity: 16<c/> State: 1.
10/30/2011 02:00:00,spid140,Unknown,The log shipping primary database FEGUSCNMSDZ09P.ACCESSCONTROL has backup threshold of 60 minutes and has not performed a backup log operation for 70 minutes. Check agent log and logshipping monitor information.
10/30/2011 02:00:00,spid140,Unknown,Error: 14420<c/> Severity: 16<c/> State: 1.
10/30/2011 01:50:15,Backup,Unknown,Log was backed up. Database: ACCESSCONTROL<c/> creation date(time): 2011/06/23(11:30:16)<c/> first LSN: 129489:67043:1<c/> last LSN: 129489:67124:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=DISK: {'D:\Log shipping Out\ACCESSCONTROL\ACCESSCONTROL_20111030085015.trn'}). This is an informational message only. No user action is required.
10/30/2011 01:50:15,Backup,Unknown,Log was backed up. Database: VISITORPASSARCHIVE<c/> creation date(time): 2011/06/23(01:27:48)<c/> first LSN: 246:194:1<c/> last LSN: 246:194:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=DISK: {'D:\Log shipping Out\VISITORPASSARCHIVE\VISITORPASSARCHIVE_20111030085015.trn'}). This is an informational message only. No user action is required.
10/30/2011 01:50:15,Backup,Unknown,Log was backed up. Database: PSCV3<c/> creation date(time): 2011/06/16(14:47:30)<c/> first LSN: 4850:391:1<c/> last LSN: 4850:391:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=DISK: {'D:\Log shipping Out\PSCV3\PSCV3_20111030085015.trn'}). This is an informational message only. No user action is required.
10/30/2011 01:50:15,Backup,Unknown,Log was backed up. Database: PERFMON<c/> creation date(time): 2011/06/16(14:46:54)<c/> first LSN: 23:2224:1<c/> last LSN: 23:2224:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=DISK: {'D:\Log shipping Out\PERFMON\PERFMON_20111030085015.trn'}). This is an informational message only. No user action is required.
10/30/2011 01:45:15,Backup,Unknown,Log was backed up. Database: CARDHOLDERANALYSIS<c/> creation date(time): 2011/06/16(16:39:43)<c/> first LSN: 5340:51:1<c/> last LSN: 5340:54:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=DISK: {'D:\Log shipping Out\CARDHOLDERANALYSIS\CARDHOLDERANALYSIS_20111030084515.trn'}). This is an informational message only. No user action is required.
10/30/2011 01:45:15,Backup,Unknown,Log was backed up. Database: LENELUPGRADECUSTOMFIELDFIX<c/> creation date(time): 2011/06/16(14:46:09)<c/> first LSN: 114:135:1<c/> last LSN: 114:135:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=DISK: {'D:\Log shipping Out\LENELUPGRADECUSTOMFIELDFIX\LENELUPGRADECUSTOMFIELDFIX_20111030084515.trn'}). This is an informational message only. No user action is required.
10/30/2011 01:45:15,Backup,Unknown,Log was backed up. Database: HRSYNC<c/> creation date(time): 2011/06/16(14:44:36)<c/> first LSN: 43:62:1<c/> last LSN: 43:62:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=DISK: {'D:\Log shipping Out\HRSYNC\HRSYNC_20111030084515.trn'}). This is an informational message only. No user action is required.
October 31, 2011 at 5:44 pm
Found..ITs a bug in MSSQL 2005.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply