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 |
|
laddu
Constraint Violating Yak Guru
332 Posts |
 Posted - 2009-11-19 : 16:49:28
|
| I have configured using logshipping for 3 databases, but job schedules are confilcting.Please advice the best schedules for 3 databases |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-11-19 : 19:16:34
|
| up to u how often you want 'em backed up and shipped. the question is answered by the answer to this question: "how much work can you afford to lose?" |
 |
|
|
laddu
Constraint Violating Yak Guru
332 Posts |
Posted - 2009-11-19 : 23:20:37
|
| 5 min |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-11-19 : 23:45:17
|
| are you getting errors? is the copy overlapping the backup? |
|
|
|
laddu
Constraint Violating Yak Guru
332 Posts |
Posted - 2009-11-20 : 00:17:42
|
quote:
Originally posted by russell
are you getting errors? is the copy overlapping the backup?
No errors so far. Backup and restore jobs are sheduled same time for 3 databasesbackup job every 5 min starting 12:00 am to 11 :59 pmrestore job efvery 3 min starting 12:08 am to 11 :59 pm |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-11-20 : 00:23:11
|
| should be ok as long as backups don't fail. we've had some issues with multiple backups to NAS running concurrently, but it's rare. |
|
|
|
|
|
|
logshipping: backup and restore job shcedule