Post reply

how to gather backup information on remote servers

  • April 23, 2008 at 4:46 pm

    #184773

    I am looking for some advice on how to gather backup information for about 50+ servers. Some of the instances are named and most are default. There is a mix of 2000 and 2005. I already have a script that runs on both versions to get me the information I want. My problem is how do I connect to all those servers? Should I use dmo, smo, dts, ssis or something else.

    Thanks,

    Dave

  • April 25, 2008 at 7:40 am

    #807175

    For these situations, I use one central SQL Server as a repository for the info from all the other servers. Since you have SQL Server 2005, I would use one of those servers for the repository and use SSIS to gather the info. You get more flexibility with using SSIS to gather the info then you do with DTS in my opinion. Once all the data is collected, it is very easy to query this info from the one source to find anomilies in all the servers.

    Dave Novak

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

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