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 - 2007-12-28 : 10:44:23
|
| Hi everyone,We are talking about doing a transaction log shipping system.1) Is there a way to automate the process of adding a database to the log shipping system without going through the wizard?2) Does all the machines (Primary, secondary and monitor) all need to be on the same subnet?3) If the secondary and monitor servers are in house, and the primary server is in the NOC, will there be a lag between them, and if there is, what kind of performance impact should i expect?thanks in advance!take caretony |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-12-28 : 13:20:32
|
| 1. Yes, but it is super, super hard. I tried doing it and gave up after hours of trying to figure out what commands to run.2. No.3. Probably but it wouldn't impact production most likely. We log ship to a server 300 miles away and have no issues with performance except when we need to copy a large tlog backup file over. The file copy is just very slow, so log shipping could get out of sync but it'll recover once the files makes it to the secondary server.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
donpolix
Yak Posting Veteran
97 Posts |
Posted - 2007-12-28 : 13:55:30
|
| 1. You don't wan't to go back to complicated scripting as in version 7, and automating adding a db is not worth the effort, besides there will always be dba intervention with log shipping,..switching roles, restoring full db in standby mode in secondary server, synching logins,..so leave it.2. No3. Common problem is the size of the tran log backup. The bigger it is, the more frequent you may want to log ship. If you have periodic checkdb, or reindex on the primary db, that would be another problem as you are shipping even larger tlog backup files.Donn Policarpio |
|
|
|
pithhelmet
Posting Yak Master
183 Posts |
Posted - 2007-12-31 : 08:33:51
|
| Very Nice!Thank you very much!take caretony |
|
|
|
|
|
|
|
|
Transaction log shipping questions