Timestamp error while Restoring Transaction Logsgreenspun.com : LUSENET : SQL Server Database Administration : One Thread
I have scheduled a database backup at 9 pm and 5 Transaction Log backups. The transaction Log backups happen at 11 am, 1 pm, 3 pm and 5 pm (device does not get initialized) and one at 11 pm where i initialize the backup device. now i have another server with the same database on it. I restore these backups on to this server by simple copying the files and then doing Restore ...From Device...Add file...option. I am able to restore the DB backup but when i try to restore the log backups it get the error msg -
'Specified file 'G:...' is out of sequence. current time stamp is Feb 9 2000 11:54 am while dump was from Feb 9 2000 11 am.' I am doing the restoration after backing up 11 am log.
When i am restoring the logs i start from the 1st backup buyt still i get this error. Can someone pls let me know what the problem is and how to resolve it. Thanks.
-- Anonymous, February 10, 2000
First of all, the way I read your message, you have a database backup at 9 PM, followed by transaction log backups at 11 PM(!), 11 AM, 1 PM, 3 PM, and 5 PM. You must apply them in that order.
The 4305 message is explained in the Knowledge Base article, Q95867 at http://support.microsoft.com/support/kb/articles/Q95/8/67.ASP.
Hope this helps,
-- Anonymous, February 13, 2000