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 |
|
sandesh_moghe
Constraint Violating Yak Guru
310 Posts |
 Posted - 2003-08-29 : 22:04:30
|
| Hi,I have two full back up at 03:00AM and 13:30PM.And a differential backup at every hour.Now my question is while setting the differential backup, it should be Append to Media or Overwrite existing media?Mean to say, differential database backup records only the data that has changed since the last database backup. Last backup can be a differential backup also or only full backup?Thanks in advance.---------------------------Sandesh - The Messanger |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-08-30 : 01:17:29
|
| It records data since the last full backup so you can apply any differential to the full (usually the last one).How many differentials you keep is up to you but you need the full to apply any of them.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
sandesh_moghe
Constraint Violating Yak Guru
310 Posts |
Posted - 2003-08-30 : 02:16:38
|
| Thanks nr.One more thing, Which policy is better? Full Backup followed by Differential backup or full backup followed by Transactional backup?Please guide.---------------------------Sandesh - The Messanger |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-08-30 : 13:46:02
|
| Depends on your requirement. Simple recovery model is a lot easier to maintain and doesn't carry the risk of the tr log filling the disk if the backups fail. It is what I always use unless there is a reason not to and always set model to this so that new databases are created with it as default.It means that all data since the last differential will be lost - not a problem on batch systems as you can always retrieve the data again.On on-line systems (i.e. with user interaction) you may need the tr backups so that after a crash you can copy the last tr log and restore to the point of failure - depends on whether the business requirement allows for the re-input of the data in this eventuality.Remember to test your backups - just because the backup was successful doesn't mean it can be restored - especially important if you are not backing up to a local disk.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
Backup Policy