SQL Server Performance

Multi Server Administration

Discussion in 'SQL Server 2008 General DBA Questions' started by madduri, Feb 15, 2010.

  1. madduri New Member

    Hi,
    I would like to setup Multi Server Administration in our environment. I would like to create a maintenance plan for all the dbs on the master server and deploy them to the target servers. Unfortunately the backup location and error log location for all the servers vary. Is there a way that I can use variables that dynamically change the backup location and log location on each server?
    Any ideas would be of extreme help.
  2. preethi Member

    Hi Madduri,
    I believe you want to pass a parameter to each job. but how will you pass a value for an automated job?
    1. Even though you mentioned as maintenance job, I am not sure whether you refer to an SSIS package
    We use something like this. We will have a table in the same database in each environment and read the value. Manually update the value in each environment
    On SSIS you can manually set the values for parameters (configurations).
  3. madduri New Member

    Thank you for the reply.
    Yes, I was refering to creating a Maintenance plan job (using a wizard). Is there any way we can open and tweak the SSIS package configuration that gets created at the backend? else we have to script out and make modifications to the script.
  4. ghemant Moderator

Share This Page