Post reply

Database maintenance attributes using T-Sql

  • September 27, 2006 at 4:45 pm

    #120827

     I am trying to see if anyone knows how to find the attributes of the Database maintenance that is set up by using T-Sql. 

    Reason I ask is I have been tasked with making sure that all of our servers have the same maintenance plans in place.  I know I could look at the GUI for each server, but we have over 95 servers and this would take me some time.

    Thanks.

  • September 29, 2006 at 5:47 am

    #663280

    Hi Shaw,

    What u can do is first to generate scripts of TSQL and to designate a job server and make it run the job on all the remaining servers.  Don't ask me how to implement to job server. Open SQL Server Agent not and see the properties for multi server through MSX/TSX server administration.  and go accordingly

     

     

    Thanks

    R Suresh

     

     

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply