November 23, 2010 at 6:49 am
Sorry guys, I found out we are running websense and was having trouble posting. Anyway you lost me at Linked Servers however from what i have read about it, it sounds like the way to go since I found out I have over 150+ servers running the sqlserver.exe service around the office. So if I were able to connect to a whole bunch at one time and run a distributed query againt all of the ones I am connected to it would save me loads of time. I am currently connecting to each server then running a query to determine the backup method,type,time since last,etc. I am going to try and figure out how to set up a Linked server config. Now I am running 2005 management studio on my pc if that make a difference?
November 24, 2010 at 1:48 am
Hi,
You can also go through the SQL Server Tacklebox and set up the repository.
http://www.sqlservercentral.com/articles/books/67536/
__________________________
Allzu viel ist ungesund...
Viewing 2 posts - 16 through 17 (of 17 total)
You must be logged in to reply to this topic. Login to reply