Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

restor failed Expand / Collapse
Author
Message
Posted Saturday, February 23, 2013 10:07 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, June 26, 2014 1:17 AM
Points: 90, Visits: 239
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
Posted Saturday, February 23, 2013 10:12 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, August 18, 2014 10:45 PM
Points: 119, Visits: 490
Restore full, then differential. Thats enough to have as per your backups.

Cheers,
- Win
"Dont Judge a Book by its Cover"
Post #1423358
Posted Saturday, February 23, 2013 10:29 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 11:31 AM
Points: 40,177, Visits: 36,578
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
Posted Sunday, February 24, 2013 7:34 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, January 21, 2014 8:29 AM
Points: 244, Visits: 476
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.


Kind regards,

Patrick Fiedler
Consultant

Fiedler SQL Consulting

www.fiedler-sql-consulting.de
Post #1423417
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse