Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Peace2007
Posting Yak Master
239 Posts |
 Posted - 2008-05-18 : 00:50:05
|
| Hi, I've defined a maintenance plan in SQL2005, which creates a differential backup of a DB daily. Suppose I'm having differential backups from May, 10 to May, 14 but backup files of May 12 and May 13 are lost (deleted unexpectedly). Am I losing some data, if I restore from backup file of May 14?Thanks & Regards, |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-05-18 : 02:51:57
|
| No,you won't lose data.Just restore fullbackup and differential backup of May14 and you are good. |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-05-18 : 21:38:13
|
| Depends on what you need. You can't recover the db to May 12th nor May 13th. |
|
|
|
Peace2007
Posting Yak Master
239 Posts |
Posted - 2008-05-20 : 08:51:03
|
Thanks all for your comments.  I got my answer Anyway, does it know when the full backup is taken?! I mean when it doesn't lose data while restoring from file of May 14, it's concluded that it keeps log of full backup and keeps changes after that; am I right? |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-05-20 : 09:48:22
|
| Yes ,differential backup captures everything after full backup. |
|
|
|
Peace2007
Posting Yak Master
239 Posts |
Posted - 2008-05-21 : 00:31:40
|
| Nice SQL :) I love it as well as such forums ;) |
|
|
|
|
|
|
Differential Backup