I've set up log shipping with 2 nodes running sql server 2000 enterprise. My question is that is there a fast way (perhaps scripting) to set up multiple databases all at once to use log shipping? I'm sure that using the stored procedurees to do it directly is possible, but I've no idea which procedures to use and what the paramters would then be.
I only ask this question because I realize that if I ever suffer a failure not only are the sp_change_secondary_role and sp_resolve_logins for each individual database I've also got to go through reseting up all the log shipping jobs from the new primary server to the new secondary server (old primary server assuming a rebuild).
Any help to reduce this from an day long operation to an hour long operation would be helpful considering I'll probobly be rebuilding the primary at the same time too.