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.
more ▼

asked Mar 06, 2011 at 08:43 PM in Default

ebzm gravatar image

423 29 33 35

(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first

Funny you should ask - that was last month's T-SQL Tuesday topic. You should be able to get quite a bit of insight from reading the various topics available on [the summary page][1].

[1]: http://sqlasylum.wordpress.com/2011/02/11/t-sql-tuesday-15-summary/
more ▼

answered Mar 06, 2011 at 11:32 PM

Matt Whitfield gravatar image

Matt Whitfield ♦♦
29.5k 61 65 87

(comments are locked)
10|1200 characters needed characters left

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][2] (SQL2005 and up).

[2]: http://ola.hallengren.com
more ▼

answered Mar 07, 2011 at 12:54 AM

ThomasRushton gravatar image

ThomasRushton ♦
34.2k 18 20 44

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Mar 06, 2011 at 08:43 PM

Seen: 805 times

Last Updated: Mar 06, 2011 at 08:43 PM