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 |
|
dineshrajan_it
Posting Yak Master
217 Posts |
 Posted - 2010-02-23 : 02:37:09
|
| Hi All,Whats interval time period required for Full backup and its corresponding Differential Backup. I usually take between 3 days for Full backup.Iam a slow walker but i never walk back |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-02-23 : 03:18:59
|
| I think 15 minutes is a good interval for Transaction Log Backup.Full backup is up to you - how long will it take you to recover from Full Backup and all following TLog backups?How much data can you afford to lose if, say, the Tlog backups are damaged?Differential backup is to speed up the restore process. SO you may take Full backup every 3 days, and differential backup twice a day - then you can recover:Full backupDiff backupAll tlog backups (maximum is half-a-day's worth) |
 |
|
|
dineshrajan_it
Posting Yak Master
217 Posts |
Posted - 2010-02-23 : 04:51:29
|
| Thanks for reply. I will implement in mine.Iam a slow walker but i never walk back |
|
|
|
|
|
|
Backup