Missing log file. - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Missing log file.

Author

Topic

cornall
Posting Yak Master

148 Posts

Posted - 2007-06-13 : 15:51:21

From my SQL server logs

Log backed up: Database: *****, creation date(time): 2005/10/09(19:54:38), first LSN: 987145:146:1, last LSN: 987232:4405:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'D:\backups\data\day0\20070613_17_45_02_log'}).
Log backed up: Database: ***** , creation date(time): 2005/10/09(19:54:38), first LSN: 987268:18:1, last LSN: 987268:1033:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'D:\backups\data\day0\20070613_17_55_02_log'}).

The server logs show that the above logs were created on after another.

20070613_17_45_02_log (applied ok)
20070613_17_55_02_log (gave an error saying I must apply an earlier log file!)

Can anyone offer any advise or should I simply restore a full backup and start log shipping again.

cornall
Posting Yak Master

148 Posts

Posted - 2007-06-13 : 16:11:07

More info from the log creation job history

Executed as user: NT AUTHORITY\SYSTEM. DBA job started on server "*****" at "13 Jun 2007 17:45:02:830". [SQLSTATE 01000] (Message 0)  <---------------------------------------- JOB LOG ----------------------------------------> [SQLSTATE 01000] (Message 0)  Processed 9875 pages for database '*****', file 'CBS_Log' on file 1. [SQLSTATE 01000] (Message 4035)  BACKUP LOG successfully processed 9875 pages in 17.528 seconds (4.614 MB/sec). [SQLSTATE 01000] (Message 3014)  <---------------------------------------- SUMMARY ----------------------------------------> [SQLSTATE 01000] (Message 0)  DBA job completed on server "*****" at "13 Jun 2007 17:48:34:240". [SQLSTATE 01000] (Message 0).  The step succeeded.

Executed as user: NT AUTHORITY\SYSTEM. DBA job started on server "*****" at "13 Jun 2007 17:50:02:820". [SQLSTATE 01000] (Message 0)  <---------------------------------------- JOB LOG ----------------------------------------> [SQLSTATE 01000] (Message 0)  <---------------------------------------- SUMMARY ----------------------------------------> [SQLSTATE 01000] (Message 0)  DBA job completed on server "*****" at "13 Jun 2007 17:50:02:820". [SQLSTATE 01000] (Message 0).  The step succeeded.

Executed as user: NT AUTHORITY\SYSTEM. DBA job started on server "*****" at "13 Jun 2007 17:55:02:823". [SQLSTATE 01000] (Message 0)  <---------------------------------------- JOB LOG ----------------------------------------> [SQLSTATE 01000] (Message 0)  There is no current database backup. This log backup cannot be used to roll forward a preceding database backup. [SQLSTATE 01000] (Message 4214)  Processed 64 pages for database '*****', file 'CBS_Log' on file 1. [SQLSTATE 01000] (Message 4035)  BACKUP LOG successfully processed 64 pages in 5.155 seconds (0.100 MB/sec). [SQLSTATE 01000] (Message 3014)  <---------------------------------------- SUMMARY ----------------------------------------> [SQLSTATE 01000] (Message 0)  DBA job completed on server "*****" at "13 Jun 2007 17:55:10:370". [SQLSTATE 01000] (Message 0).  The step succeeded.

As you can see the job that creates the logs did run between the two logs that I have. however it is missing the part that says how many pages were processed and there is no file?

Is this a sign of anything? Any ideas of what may be in store?

Cheers D