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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Differential Backups

Author  Topic 

gmetaj
Starting Member

33 Posts

Posted - 2004-05-11 : 09:39:40
Are differential backups in SQL 7 incremental. What I am asking is when you do an incremental backup you backup all the files/content changed since last full back up or since last differential backup. If they are not incremental how do you do incremental backups?

Thank you in advance!

Gent

ravilobo
Master Smack Fu Yak Hacker

1184 Posts

Posted - 2004-05-11 : 09:53:53
Differential backup is the changes made after the last full backup. Hope this will help.

------------------------
I think, therefore I am
Go to Top of Page

derrickleggett
Pointy Haired Yak DBA

4184 Posts

Posted - 2004-05-11 : 09:54:24
They are since the last full backup. Transaction backups are since the last full, differential, or transaction backup (whichever happened last).

MeanOldDBA
derrickleggett@hotmail.com

When life gives you a lemon, fire the DBA.
Go to Top of Page
   

- Advertisement -