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?

migrated from stackoverflow.com Jan 22 '10 at 13:29

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


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.


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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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