March 6, 2009 at 12:48 pm
Hi,
When there is a server crash, first i restore latest FULL backup and differential backups from then, or the latest differential backups?
March 6, 2009 at 1:01 pm
Restore the full, the latest differential and then all the transaction log backups since the last diff (if you have log backups) in sequence
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 6, 2009 at 1:04 pm
I will do so... but now i tested a sample..After i restored the full backup with NORECOVERY, i found that in the console tree, the database seems unavailable..It says NO IETMS...
Is there a reason why this is happening?
March 6, 2009 at 1:20 pm
Sql Student (3/6/2009)
Is there a reason why this is happening?
Because the restore was with NORECOVERY.
The database won't be available until do a restore WITH RECOVERY and that must be on the very last backup that you restore (diff or log) as after that no more backups can be restored.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 6, 2009 at 1:35 pm
oh..thatz quite something...Well..thanks for letting me know..i will work on it and see if i can succeed in restoring the differential now..
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply