May 14, 2003 at 9:42 am
I am having an issue trying to implement MSX. I am running a pure SQL2K sp3 environment. The biggest issue occurs after I create the master and target and try to create a maintenance plan to run on the target. The databases I am shown to choose from are the local databases, regardless of which server I choose for the plan.
I have tried restarting the SQL Agent on both the master and target servers, to no effect.
The ultimate goal is to set up log shipping from the target (production) to the master (staging). The prod machine is running standard edition and the staging server is on enterprise.
I would appreciate any advice as to what the hangup may be or to what I am doing wrong.
Thanks,
Rob Haas
May 14, 2003 at 10:05 am
Keep in mind that the plan goes to all servers. It is not "customized" for each server, otherwise you would not use master/targets.
Pick either "User Databases" or "System databases" and set the plan that way.
Steve Jones
May 14, 2003 at 10:07 am
That is how it works. You want see your targets servers databases in the maintenance plan. If you have the same db in the master server, then you can select it, and the job will run with no problems in all the target servers. But if you don't have it, you will have to manually create a job and script it so it use the db you have in the TSX.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply