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