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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-01-05 : 08:02:07
|
| Hosein writes "Hi,As you know differential backup backs up changes from the last full backup, but i need a solution to backup only the changes from the last differential backup, is there any solution, and if not why microsoft have not implemented such backup method?Thanks in advance." |
|
|
Wanderer
Master Smack Fu Yak Hacker
1168 Posts |
Posted - 2005-01-05 : 08:05:29
|
| There is - it is called a transaction log backup.Make sure that your DB is set to FULL recovery model, and see the BOL for details.*##* *##* *##* *##* Chaos, Disorder and Panic ... my work is done here! |
 |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-01-05 : 08:06:24
|
| Because it defeats the purpose of having a differential backup, which is to reduce the number of backups that need to be restored. There is no need for differential backups except for convenience, since you can get the same result by restoring database and transaction log backups. Only you'd end up restoring a lot more files and it can take quite a bit longer to do. For what you need, you can just restore the log backups made since the last differential backup. |
|
|
|
|
|
|
Backup