question

ramesh 1 avatar image
ramesh 1 asked

Tran log restore Fail in sql server 2008 standard edition

hi team, today i have restored my database with transaction log, but it gives me a error like **The log or differantial backup cannot be restored because no files are ready to rollforward. RESTORE LOG is terminating abnormally** what might be the problem. i have planned for data mirroring
sql-server-2008backuprestore
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Cyborg avatar image
Cyborg answered
Ramesh, This error happens when Full back up is not restored before attempting to restore differential backup or full backup is restored with WITH RECOVERY option. Make sure database is not in operational conditional when differential backup is attempted to be restored. Also make sure that your log chain isn't broken. E.g. If you have a full back up @ 6 AM and Log backups every 1 hour. say you are at 8 Am if you want to restore your backup at 8 then RESTORE Full WITH NORECOVERY RESTORE LOG WITH NORECOVERY (of 7AM) RESTORE LOG WITH RECOVERY (of 8AM).
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.