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 |
|
pithhelmet
Posting Yak Master
183 Posts |
 Posted - 2008-06-02 : 13:20:12
|
| Hello everyone -1) How do estimate the amount of transaction log that will need to be shipped?2) Would a transaction log shipping on 8 times a day schedule be too much?3) What kind of bandwidth should i expect to be used??thankstony |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-06-02 : 17:39:32
|
| 1)Log shipping takes a log backup and ships your log to destination server. you have to find your transaction rate with DBCC SQLperf or check activities.2) Depends on how you want to sync up.3)Depends on distance and is better to use good bandwidth . |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-06-02 : 20:21:52
|
| >> Would a transaction log shipping on 8 times a day schedule be too much?Depends on how much data you can offer to lose, we ship log every 15 minutes for most dbs. |
|
|
|
|
|
|
transaction log shipping questions