August 4, 2008 at 4:11 am
I have logshipping running in sql 2005. It has been scheduled to logship every 15 min from 6am till 7pm everyday. It workfine when i start logshipping ,the following morning it fails and the error i am getting is the the transaction logs are too recent to apply to the secondary database an earlier log is available to restore. can someone help please
August 4, 2008 at 4:52 am
Hi Nabil,
Do you have log backups (not the logshipping ones) running over night? If so, that explains the message you received as the LSN chain will have been broken - ie there is a log backup that hasn't been shipped to the failover server and the restore process needs it before it can carry on restoring the shipped logs. You either need to restore the 'missing' log(s) and resume logshipping or take a new full backup and reconfigure the logshipping job.
Hope that helps,
Cath
August 4, 2008 at 4:54 am
August 4, 2008 at 8:46 am
No, i don`t have logbackup. the onlything i got running is BEX agent doing a bckup all .mdf and .ldf files on the primary server.
August 4, 2008 at 8:52 am
You could run a query similar to the following to find out all the trx log backups that were made in the last 24 hrs, which may help in identifying if an ad-hoc backup was made
SELECT b.physical_device_name, a.backup_finish_date, a.position, a.first_lsn, a.last_lsn, a.user_name
FROM msdb..backupset a
INNER JOIN msdb..backupmediafamily b ON a.media_set_id = b.media_set_id
WHERE a.database_name = 'your database name here'
AND a.type = 'L'
AND a.backup_finish_date >= GETDATE() - 1
ORDER BY a.backup_finish_date DESC
SQL BAK Explorer - read SQL Server backup file details without SQL Server.
Supports backup files created with SQL Server 2005 up to SQL Server 2017.
August 5, 2008 at 2:55 am
I am getting these error
Date04/08/2008 20:20:00
LogWindows NT (Application)
SourceSQLSERVERAGENT
CategoryJob Engine
Event1073742032
ComputerDH-SQL1
Message
SQL Server Scheduled Job 'LSAlert_dh-SQL1' (0xE7C7FFB97CA2F14D9300B32A2925D5AB) - Status: Failed - Invoked on: 2008-08-04 20:20:00 - Message: The job failed. The Job was invoked by Schedule 123 (Log shipping alert job schedule.). The last step to run was step 1 (Log shipping alert job step.).
Date05/08/2008 09:40:00
LogWindows NT (Application)
SourceMSSQLSERVER
CategoryServer
Event3221239893
UserDH-SQL1\Administrator
ComputerDH-SQL1
Message
The log shipping secondary database DH-SQL1.TFHERTSUNI has restore threshold of 45 minutes and is out of sync. No restore was performed for 805 minutes. Restored latency is 15 minutes. Check agent log and logshipping monitor information.
August 5, 2008 at 3:00 am
I have run the script and come with nothing (no rows effected)
August 5, 2008 at 4:20 am
I trust you did change the database name value in this line
WHERE a.database_name = 'your database name here'
and given the time now, you'll probably need to change this line too:
AND a.backup_finish_date >= GETDATE() - 1
to perhaps look for backups 2 days old e.g.
AND a.backup_finish_date >= GETDATE() - 2
SQL BAK Explorer - read SQL Server backup file details without SQL Server.
Supports backup files created with SQL Server 2005 up to SQL Server 2017.
August 5, 2008 at 4:25 am
Hi Nabil,
The first error message is telling you that there's a log backup missing: 'the transaction logs are too recent to apply to the secondary database'. It also says: 'an earlier log is available to restore', which confirms that. I suspect it's the BEX backup that's done it, as I know it can disrupt differential backup/restores because of a mismatched LSN. Does anyone know this for sure?
Try restoring the full and log backups from tape, then reapplying the shipped logs.
Cath
August 5, 2008 at 4:42 am
This is what i get. what do you think?
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080805103001.trn2008-08-05 11:30:01.00013024800000000460000130248000000035700001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080805101501.trn2008-08-05 11:15:01.00013024700000003850000130248000000004600001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080805100000.trn2008-08-05 11:00:00.00013024700000002440000130247000000038500001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080805094500.trn2008-08-05 10:45:00.00013024700000001710000130247000000024400001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080805093000.trn2008-08-05 10:30:00.00013024700000000310000130247000000017100001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080805091500.trn2008-08-05 10:15:00.00013024500000003950000130247000000003100001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080805090001.trn2008-08-05 10:00:01.00013024500000003290000130245000000039500001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080805084501.trn2008-08-05 09:45:01.00013024500000002760000130245000000032900001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080805083001.trn2008-08-05 09:30:01.00013024500000002580000130245000000027600001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080805081504.trn2008-08-05 09:15:04.00013024500000001660000130245000000025800001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080805080001.trn2008-08-05 09:00:01.00013024500000001430000130245000000016600001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080805074501.trn2008-08-05 08:45:01.00013024500000001180000130245000000014300001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080805073001.trn2008-08-05 08:30:01.00013024500000001140000130245000000011800001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080805071501.trn2008-08-05 08:15:01.00013024500000000830000130245000000011400001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080805070001.trn2008-08-05 08:00:01.00013024500000000700000130245000000008300001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080805064501.trn2008-08-05 07:45:01.00013024500000000700000130245000000007000001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080805063001.trn2008-08-05 07:30:01.00013024500000000700000130245000000007000001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080805061501.trn2008-08-05 07:15:01.00013024500000000700000130245000000007000001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080805060001.trn2008-08-05 07:00:01.00013024500000000700000130245000000007000001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080805054501.trn2008-08-05 06:45:01.00013024500000000700000130245000000007000001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080805053001.trn2008-08-05 06:30:01.00013024500000000700000130245000000007000001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080805051501.trn2008-08-05 06:15:01.00013024500000000700000130245000000007000001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080805050001.trn2008-08-05 06:00:01.00013024500000000700000130245000000007000001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080805044501.trn2008-08-05 05:45:01.00013024500000000700000130245000000007000001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080805043001.trn2008-08-05 05:30:01.00013024500000000700000130245000000007000001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080805041501.trn2008-08-05 05:15:01.00013024500000000700000130245000000007000001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080805040001.trn2008-08-05 05:00:01.00013024500000000700000130245000000007000001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080805034501.trn2008-08-05 04:45:01.00013024500000000700000130245000000007000001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080805033001.trn2008-08-05 04:30:01.00013024500000000700000130245000000007000001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080805031501.trn2008-08-05 04:15:01.00013024500000000700000130245000000007000001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080805030001.trn2008-08-05 04:00:01.00013024500000000700000130245000000007000001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080805024501.trn2008-08-05 03:45:01.00013024500000000700000130245000000007000001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080805023001.trn2008-08-05 03:30:01.00013024500000000700000130245000000007000001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080805021501.trn2008-08-05 03:15:01.00013024500000000700000130245000000007000001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080805020001.trn2008-08-05 03:00:01.00013024500000000700000130245000000007000001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080805014501.trn2008-08-05 02:45:01.00013024500000000700000130245000000007000001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080805013001.trn2008-08-05 02:30:01.00013024500000000700000130245000000007000001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080805011501.trn2008-08-05 02:15:01.00013024500000000700000130245000000007000001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080805010001.trn2008-08-05 02:00:01.00013024500000000700000130245000000007000001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080805004501.trn2008-08-05 01:45:01.00013024500000000700000130245000000007000001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080805003001.trn2008-08-05 01:30:01.00013024500000000700000130245000000007000001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080805001501.trn2008-08-05 01:15:01.00013024500000000700000130245000000007000001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080805000001.trn2008-08-05 01:00:01.00013024500000000700000130245000000007000001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080804234501.trn2008-08-05 00:45:01.00013024500000000700000130245000000007000001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080804233001.trn2008-08-05 00:30:01.00013024500000000700000130245000000007000001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080804231501.trn2008-08-05 00:15:01.00013024500000000700000130245000000007000001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080804230001.trn2008-08-05 00:00:01.00013024500000000700000130245000000007000001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080804224501.trn2008-08-04 23:45:01.00013024500000000700000130245000000007000001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080804223004.trn2008-08-04 23:30:05.00013024500000000700000130245000000007000001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080804221505.trn2008-08-04 23:15:06.00013024500000000700000130245000000007000001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080804220001.trn2008-08-04 23:00:01.00013024500000000700000130245000000007000001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080804214501.trn2008-08-04 22:45:01.00013024500000000700000130245000000007000001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080804213001.trn2008-08-04 22:30:01.00013024500000000700000130245000000007000001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080804211503.trn2008-08-04 22:15:03.00013024500000000700000130245000000007000001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080804210001.trn2008-08-04 22:00:01.00013024500000000700000130245000000007000001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080804204501.trn2008-08-04 21:45:01.00013024500000000700000130245000000007000001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080804203001.trn2008-08-04 21:30:01.00013024500000000700000130245000000007000001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080804201504.trn2008-08-04 21:15:05.00013024500000000700000130245000000007000001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080804200001.trn2008-08-04 21:00:01.00013024500000000700000130245000000007000001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080804194501.trn2008-08-04 20:45:01.00013024500000000700000130245000000007000001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080804193001.trn2008-08-04 20:30:01.00013024500000000700000130245000000007000001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080804191501.trn2008-08-04 20:15:01.00013024500000000700000130245000000007000001CL-SQL1\Administrator
BEXVDI.1217876401.42008-08-04 20:11:53.00013024400000004660000130245000000007000001NT AUTHORITY\SYSTEM
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080804190001.trn2008-08-04 20:00:01.00013024400000004660000130244000000046600001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080804184501.trn2008-08-04 19:45:01.00013024400000004660000130244000000046600001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080804183001.trn2008-08-04 19:30:01.00013024400000004660000130244000000046600001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080804181503.trn2008-08-04 19:15:03.00013024400000004660000130244000000046600001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080804180001.trn2008-08-04 19:00:01.00013024400000004660000130244000000046600001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080804174501.trn2008-08-04 18:45:01.00013024400000004660000130244000000046600001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080804173001.trn2008-08-04 18:30:01.00013024400000004660000130244000000046600001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080804171501.trn2008-08-04 18:15:01.00013024400000004660000130244000000046600001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080804170001.trn2008-08-04 18:00:01.00013024400000004660000130244000000046600001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080804164501.trn2008-08-04 17:45:01.00013024400000004660000130244000000046600001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080804163001.trn2008-08-04 17:30:01.00013024400000004660000130244000000046600001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080804161504.trn2008-08-04 17:15:05.00013024400000004660000130244000000046600001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080804160001.trn2008-08-04 17:00:01.00013024400000004630000130244000000046600001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080804154501.trn2008-08-04 16:45:01.00013024400000004600000130244000000046300001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080804153001.trn2008-08-04 16:30:01.00013024400000002670000130244000000046000001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080804151501.trn2008-08-04 16:15:01.00013024300000002650000130244000000026700001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080804150001.trn2008-08-04 16:00:01.00013024200000002970000130243000000026500001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080804144501.trn2008-08-04 15:45:01.00013024200000000460000130242000000029700001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080804143001.trn2008-08-04 15:30:01.00013024100000004970000130242000000004600001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080804141504.trn2008-08-04 15:15:05.00013024100000004540000130241000000049700001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080804140001.trn2008-08-04 15:00:01.00013024100000004120000130241000000045400001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080804134501.trn2008-08-04 14:45:01.00013024100000003060000130241000000041200001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080804133001.trn2008-08-04 14:30:01.00013024100000000930000130241000000030600001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080804131501.trn2008-08-04 14:15:01.00013024000000002960000130241000000009300001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080804130001.trn2008-08-04 14:00:01.00013024000000000780000130240000000029600001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080804124501.trn2008-08-04 13:45:01.00013023900000003070000130240000000007800001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080804123001.trn2008-08-04 13:30:01.00013023900000002940000130239000000030700001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080804121501.trn2008-08-04 13:15:01.00013023900000002590000130239000000029400001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080804120001.trn2008-08-04 13:00:01.00013023900000002590000130239000000025900001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080804114501.trn2008-08-04 12:45:01.00013023900000002590000130239000000025900001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080804113001.trn2008-08-04 12:30:01.00013023900000002550000130239000000025900001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080804111501.trn2008-08-04 12:15:01.00013023900000002550000130239000000025500001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080804110001.trn2008-08-04 12:00:01.00013023900000000550000130239000000025500001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080804104501.trn2008-08-04 11:45:01.00013023800000005230000130239000000005500001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080804103001.trn2008-08-04 11:30:01.00013023800000004140000130238000000052300001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080804101500.trn2008-08-04 11:15:00.00013023800000003870000130238000000041400001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080804100000.trn2008-08-04 11:00:00.00013023800000003480000130238000000038700001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080804094500.trn2008-08-04 10:45:00.00013023800000002170000130238000000034800001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080804093000.trn2008-08-04 10:30:00.00013023800000000250000130238000000021700001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080804091500.trn2008-08-04 10:15:00.00013023700000003600000130238000000002500001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080804090000.trn2008-08-04 10:00:00.00013023700000001470000130237000000036000001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080804084500.trn2008-08-04 09:45:00.00013023600000004430000130237000000014700001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080804083000.trn2008-08-04 09:30:00.00013023600000002550000130236000000044300001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080804081503.trn2008-08-04 09:15:04.00013023600000002360000130236000000025500001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080804080000.trn2008-08-04 09:00:00.00013023600000002360000130236000000023600001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080804074500.trn2008-08-04 08:45:00.00013023600000002330000130236000000023600001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080804073000.trn2008-08-04 08:30:00.00013023600000001660000130236000000023300001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080804071500.trn2008-08-04 08:15:00.00013023600000000270000130236000000016600001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080804070000.trn2008-08-04 08:00:00.00013023500000003820000130236000000002700001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080804064500.trn2008-08-04 07:45:00.00013023500000003820000130235000000038200001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080804063000.trn2008-08-04 07:30:00.00013023500000003820000130235000000038200001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080804061500.trn2008-08-04 07:15:00.00013023500000003820000130235000000038200001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080804060000.trn2008-08-04 07:00:00.00013023500000003820000130235000000038200001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080804054500.trn2008-08-04 06:45:00.00013023500000003820000130235000000038200001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080804053000.trn2008-08-04 06:30:00.00013023500000003820000130235000000038200001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080804051500.trn2008-08-04 06:15:00.00013023500000003820000130235000000038200001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080804050000.trn2008-08-04 06:00:00.00013023500000003820000130235000000038200001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080804044500.trn2008-08-04 05:45:00.00013023500000003820000130235000000038200001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080804043000.trn2008-08-04 05:30:00.00013023500000003820000130235000000038200001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080804041500.trn2008-08-04 05:15:00.00013023500000003820000130235000000038200001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080804040000.trn2008-08-04 05:00:00.00013023500000003820000130235000000038200001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080804034500.trn2008-08-04 04:45:00.00013023500000003820000130235000000038200001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080804033000.trn2008-08-04 04:30:00.00013023500000003820000130235000000038200001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080804031500.trn2008-08-04 04:15:00.00013023500000003820000130235000000038200001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080804030000.trn2008-08-04 04:00:00.00013023500000003820000130235000000038200001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080804024500.trn2008-08-04 03:45:00.00013023500000003820000130235000000038200001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080804023000.trn2008-08-04 03:30:00.00013023500000003820000130235000000038200001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080804021500.trn2008-08-04 03:15:00.00013023500000003820000130235000000038200001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080804020000.trn2008-08-04 03:00:00.00013023500000003820000130235000000038200001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080804014500.trn2008-08-04 02:45:00.00013023500000003820000130235000000038200001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080804013000.trn2008-08-04 02:30:00.00013023500000003820000130235000000038200001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080804011500.trn2008-08-04 02:15:00.00013023500000003820000130235000000038200001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080804010000.trn2008-08-04 02:00:00.00013023500000003820000130235000000038200001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080804004500.trn2008-08-04 01:45:00.00013023500000003820000130235000000038200001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080804003000.trn2008-08-04 01:30:00.00013023500000003820000130235000000038200001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080804001500.trn2008-08-04 01:15:00.00013023500000003820000130235000000038200001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080804000000.trn2008-08-04 01:00:00.00013023500000003820000130235000000038200001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080803234500.trn2008-08-04 00:45:00.00013023500000003820000130235000000038200001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080803233000.trn2008-08-04 00:30:00.00013023500000003820000130235000000038200001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080803231502.trn2008-08-04 00:15:02.00013023500000003820000130235000000038200001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080803230000.trn2008-08-04 00:00:00.00013023500000003820000130235000000038200001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080803224500.trn2008-08-03 23:45:00.00013023500000003820000130235000000038200001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080803223000.trn2008-08-03 23:30:00.00013023500000003820000130235000000038200001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080803221500.trn2008-08-03 23:15:00.00013023500000003820000130235000000038200001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080803220000.trn2008-08-03 23:00:00.00013023500000003820000130235000000038200001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080803214500.trn2008-08-03 22:45:00.00013023500000003820000130235000000038200001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080803213000.trn2008-08-03 22:30:00.00013023500000003820000130235000000038200001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080803211500.trn2008-08-03 22:15:00.00013023500000003820000130235000000038200001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080803210000.trn2008-08-03 22:00:00.00013023500000003820000130235000000038200001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080803204500.trn2008-08-03 21:45:00.00013023500000003820000130235000000038200001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080803203000.trn2008-08-03 21:30:00.00013023500000003820000130235000000038200001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080803201502.trn2008-08-03 21:15:03.00013023500000003820000130235000000038200001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080803200000.trn2008-08-03 21:00:00.00013023500000003820000130235000000038200001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080803194500.trn2008-08-03 20:45:00.00013023500000003820000130235000000038200001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080803193000.trn2008-08-03 20:30:00.00013023500000003820000130235000000038200001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080803191500.trn2008-08-03 20:15:00.00013023500000003820000130235000000038200001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080803190000.trn2008-08-03 20:00:00.00013023500000003820000130235000000038200001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080803184500.trn2008-08-03 19:45:00.00013023500000003820000130235000000038200001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080803183000.trn2008-08-03 19:30:00.00013023500000003820000130235000000038200001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080803181500.trn2008-08-03 19:15:00.00013023500000003820000130235000000038200001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080803180000.trn2008-08-03 19:00:00.00013023500000003820000130235000000038200001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080803174500.trn2008-08-03 18:45:00.00013023500000003820000130235000000038200001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080803173000.trn2008-08-03 18:30:00.00013023500000003820000130235000000038200001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080803171500.trn2008-08-03 18:15:00.00013023500000003820000130235000000038200001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080803170000.trn2008-08-03 18:00:00.00013023500000003820000130235000000038200001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080803164500.trn2008-08-03 17:45:00.00013023500000003820000130235000000038200001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080803163000.trn2008-08-03 17:30:00.00013023500000003820000130235000000038200001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080803161500.trn2008-08-03 17:15:00.00013023500000003820000130235000000038200001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080803160000.trn2008-08-03 17:00:00.00013023500000003820000130235000000038200001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080803154500.trn2008-08-03 16:45:00.00013023500000003820000130235000000038200001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080803153000.trn2008-08-03 16:30:00.00013023500000003820000130235000000038200001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080803151503.trn2008-08-03 16:15:04.00013023500000003820000130235000000038200001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080803150000.trn2008-08-03 16:00:00.00013023500000003820000130235000000038200001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080803144500.trn2008-08-03 15:45:00.00013023500000003820000130235000000038200001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080803143000.trn2008-08-03 15:30:00.00013023500000003820000130235000000038200001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080803141500.trn2008-08-03 15:15:00.00013023500000003820000130235000000038200001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080803140000.trn2008-08-03 15:00:00.00013023500000003820000130235000000038200001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080803134500.trn2008-08-03 14:45:00.00013023500000003820000130235000000038200001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080803133000.trn2008-08-03 14:30:00.00013023500000003820000130235000000038200001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080803131500.trn2008-08-03 14:15:00.00013023500000003820000130235000000038200001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080803130000.trn2008-08-03 14:00:00.00013023500000003820000130235000000038200001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080803124500.trn2008-08-03 13:45:00.00013023500000003820000130235000000038200001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080803123000.trn2008-08-03 13:30:00.00013023500000003820000130235000000038200001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080803121500.trn2008-08-03 13:15:00.00013023500000003820000130235000000038200001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080803120000.trn2008-08-03 13:00:00.00013023500000003820000130235000000038200001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080803114500.trn2008-08-03 12:45:00.00013023500000003820000130235000000038200001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080803113000.trn2008-08-03 12:30:00.00013023500000003820000130235000000038200001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080803111500.trn2008-08-03 12:15:00.00013023500000003820000130235000000038200001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080803110000.trn2008-08-03 12:00:00.00013023500000003820000130235000000038200001CL-SQL1\Administrator
\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080803104500.trn2008-08-03 11:45:00.00013023500000003820000130235000000038200001CL-SQL1\Administrator
August 5, 2008 at 4:53 am
Well, it certainly looks like BEX (BackupExec?) made a transaction log backup on 2008-08-04 20:11:53.000. You'll need to restore the backup made by it, before you can restore the subsequent transaction logs (\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080804191501.trn, \\cl-sql1\TFHertsLogs\TFHERTSUNI_20080804193001.trn ...).
SQL BAK Explorer - read SQL Server backup file details without SQL Server.
Supports backup files created with SQL Server 2005 up to SQL Server 2017.
August 5, 2008 at 5:06 am
Any other way to setup logshipping ? because it sound like ihave to do this every morning. can i tell BEx to not backup the .ldf file? would it solve the problem
August 5, 2008 at 6:16 am
Yes, that should sort it.
Cath
August 14, 2008 at 5:05 am
hi,
what do think if i get bex to backup the database on the secondary server? would it work because its stanby server contantly restoring database. i mean the DB are in restoing mode.
thanks
August 14, 2008 at 7:34 am
Hiya,
No, you can't backup a database that's in recovery, but that's OK - you already have a backup because of the logshipping.
Cath
Viewing 15 posts - 1 through 14 (of 14 total)
You must be logged in to reply to this topic. Login to reply