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 |
|
avijit_mca
Posting Yak Master
109 Posts |
 Posted - 2009-08-01 : 04:57:27
|
| what the frequency i should set for full back / differential / log backup in production db.Regards,AvijitRegards,avijit |
|
|
shah429
Yak Posting Veteran
52 Posts |
Posted - 2009-08-01 : 05:16:58
|
| It depends on the business requirements. How many days worth of data loss can you afford? The answer depends on this question. |
 |
|
|
avijit_mca
Posting Yak Master
109 Posts |
Posted - 2009-08-01 : 05:43:39
|
| Maximum one day data loss is affordable.Regards,avijit |
|
|
|
shah429
Yak Posting Veteran
52 Posts |
Posted - 2009-08-01 : 06:09:38
|
| OK, here are a couple of options:1. Daily Full backup. In this case you don't need any log backups. Please note that if your recovery model is full, you have to manage the log yourself, otherwise it will grow wildly. If the recovery model is simple, you are good.2. Weekly full backups and daily transactional log backups.Hope that helps. |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-08-01 : 07:57:11
|
quote:
Originally posted by shah429
OK, here are a couple of options:1. Daily Full backup. In this case you don't need any log backups. Please note that if your recovery model is full, you have to manage the log yourself, otherwise it will grow wildly. If the recovery model is simple, you are good.2. Weekly full backups and daily transactional log backups.Hope that helps.
If not taking log backups, change recovery to simple. |
|
|
|
|
|
|
Frequency Of DB Backup