x

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
more ▼

asked Nov 18, 2010 at 10:26 PM in Default

ramesh 1 gravatar image

ramesh 1
2.2k 63 67 69

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

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).

more ▼

answered Nov 18, 2010 at 11:07 PM

Cyborg gravatar image

Cyborg
10.6k 36 40 45

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x1841
x192
x102

asked: Nov 18, 2010 at 10:26 PM

Seen: 1211 times

Last Updated: Nov 19, 2010 at 01:05 AM