Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a Sql server DataBase.i have a complete Backup in one day of week and differential backup in every day.

if my DataBase damage,how i can Restore Complete And Last Differential Backup together?

share|improve this question

migrated from Jan 22 '10 at 13:29

This question came from our site for professional and enthusiast programmers.

up vote 4 down vote accepted

You would need to restore these in sequence (and FYI I'd recommend adding a transaction log backup to the mix) - see this MSDN link

I would also recommend using Redgate's SQLBackup - it's fantastic, and in my experience much better than the built in SQL backup.

share|improve this answer

When you do need to restore from your backups you will have to select the recovery state from the options menu in the restore window. You will want to select "Restore with norecovery" with the default option checked you won't be able to restore additional logs.

@Bob Palmer is correct if the DB is in production you should think about doing transaction log backups at least once an hour.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.