What is the best way of automating DBA tasks like backups, space, jobs, errors on windows and sql? we have 200+ servers and there is no 3rd party monitoring tool. I'm thinking about using SSIS but I am not sure where to start. Any guidance on where to start? Thanks.
asked Mar 06 '11 at 08:43 PM in Default
In the past, I've taken the system built by David Bird in his series of articles on the main SQL Server Central website, and used this to monitor the basic health of the servers, including job failures.
In terms of automating scheduled tasks for routine maintenance, then I would look at using something quicker to roll out than the normal SQL Server maintenance tools. I would suggest you investigate Ola Hallengren's set of SQL Server maintenance scripts (SQL2005 and up).
answered Mar 07 '11 at 12:54 AM