Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

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 stackoverflow.com Jan 22 '10 at 13:29

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

2 Answers 2

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

 
discard

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.