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 |
|
ballabhoks
Starting Member
18 Posts |
 Posted - 2003-04-15 : 00:39:35
|
| Hi, After taking full backup of a database, how can we take incremental backup.Is differential backup is same as incremental backup or not.Can we store incremental backup in sepearte file or device. If yes, then how.Ballabh |
|
|
samsekar
Constraint Violating Yak Guru
437 Posts |
Posted - 2003-04-15 : 02:42:59
|
quote:
Is differential backup is same as incremental backup or not.
Yes they are same.quote:
Can we store incremental backup in sepearte file or device. If yes, then how.
Yes. Change the desired path name.BACKUP DATABASENORTHWINDTO DISK = 'c:\BACKUP.DAT'WITH DIFFERENTIALSekar~~~~Success is not a destination that you ever reach. Success is the quality of your journey.Edited by - samsekar on 04/15/2003 02:44:10 |
 |
|
|
|
|
|
Incremental Backup