June 9, 2005 at 3:25 pm
We have a situation where we will need to create log shipping for quite a few servers with quite a lot of databases. Is there a way to script SQL 2000 Log Shipping?
I need to stick to what is provided by Microsoft since we have 14 DBAs spread around the globe and training in a custome solution isn't feasible.
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
June 9, 2005 at 3:34 pm
I don't believe you can script this via a wizard the way you can right click replication and choose to script creation. However, the whole setup is done through stored procedures so you could learn the whole setup by studying these. What might be a better option is to run a trace on a server with no traffic and then set up the log shipping. Once you have captured the events you and your team could then presumably customize the script.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply