restor failed

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 Administration » restor failed

restor failed

Rate Topic

Display Mode

Topic Options

Author

Message

Posted Saturday, February 23, 2013 10:07 AM

SSC Journeyman

Group: General Forum Members
Last Login: Friday, April 26, 2013 11:23 AM
Points: 76, Visits: 188

Dear Experts

I have taken a full backup at 3 am, log backups at 12 pm and 3 pm, and differential backup at 6 pm

now I am trying to resore database on another sql server
first,I restored full backup with no recovery
then, I restored log
then trying to restore differential
but this error is raised

The log or differential backup cannot be restored because no files are ready to rollforwared

any idea what should I do
Thanks

Post #1423357

- Win

Posted Saturday, February 23, 2013 10:12 AM

SSC Journeyman

Group: General Forum Members
Last Login: Monday, June 10, 2013 11:35 PM
Points: 86, Visits: 321

Restore full, then differential. Thats enough to have as per your backups.

Cheers,
- Win
"Dont Judge a Book by its Cover"

Post #1423358

GilaMonster

Posted Saturday, February 23, 2013 10:29 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 2:13 AM
Points: 38,105, Visits: 30,396

The error is because you restored a log backup WITH RECOVERY.
Besides, that's the wrong order. Restore full, the last diff and then the log backups to reach the point you want to restore to.

Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1423362

Patrick_Fiedler

Posted Sunday, February 24, 2013 7:34 AM

SSC Veteran

Group: General Forum Members
Last Login: Friday, June 14, 2013 5:15 AM
Points: 244, Visits: 473

Hi,

you have three types of backups.

full - which can be restored independent from any other backup
differential - which is based on the recent full backup
log - which is based on the recent differential or full backup

In conclusion that mean:
1. Restore the recent full backup
2. Restore the recent differential backup after the before restored full backup - and forget all log backups before this differential backup
3. Restore all log backups after the before restored differential backup in the timely order

I hope that makes it clear enough. Wink

Kind regards,

Patrick Fiedler
Consultant

Fiedler SQL Consulting

www.fiedler-sql-consulting.de

Post #1423417

« Prev Topic | Next Topic »

Permissions