Administering and Monitoring Multiple database versions

Question

Administering and Monitoring Multiple database versions

Ejacksonjames

SSC Journeyman

Points: 85
More actions
April 27, 2010 at 8:44 am

#142786

Hi I am new to SQL administration. We have over 100 production/development databases on multiple servers on different OS versions, win 2000 and 2003 server.
I daily monitor all database backups on each server to verify whether they were successful, but this is very time consuming.
Is there a way I can verify the backup from a central location by setting up a script that can run on each database that will create a report listing which backups failed?
Like I said, I am a newbie, so any and all suggestions will be greatly appreciated.
-James

Viewing 9 posts - 1 through 8 (of 8 total)

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

alen teplitsky SSC-Dedicated Points: 30014 More actions · Answer 1

i set up a system where i run SSIS packages to grab the data from msdb and then i have some SSRS reports emailed to me daily. it's based on an article here and i modified it.

email or PM me if you want more information

Ejacksonjames SSC Journeyman Points: 85 More actions · Answer 2

Hi Alen,

can you direct me to the link for the article?

Thanks for your reply,

-James

alen teplitsky SSC-Dedicated Points: 30014 More actions · Answer 3

http://www.sqlservercentral.com/articles/Backup/66564/

used this as a base, but made a lot of modifications and wrote a lot of my own reports. was going to submit it as an article but haven't had time to finish writing it

ps. One Orange Chip Points: 29422 More actions · Answer 4

Ejacksonjames (4/27/2010)
Is there a way I can verify the backup from a central location by setting up a script that can run on each database that will create a report listing which backups failed?

I wrote a script sometime back that generates backup report, time lag in a csv format from all servers in a company. Might be useful to you.

Here is the url.

http://www.sqlservercentral.com/scripts/Backup/68709/

Pradeep Singh

Ejacksonjames SSC Journeyman Points: 85 More actions · Answer 5

Ejacksonjames

SSC Journeyman

Points: 85

April 27, 2010 at 10:06 am

#1158353

Thank you Alen

Ejacksonjames SSC Journeyman Points: 85 More actions · Answer 6

Ejacksonjames

SSC Journeyman

Points: 85

April 27, 2010 at 10:07 am

#1158354

Thanks Pradeep

Ejacksonjames SSC Journeyman Points: 85 More actions · Answer 7

Hi Pradeep,

I didn't see the script on the link you provided.

Shawn Melton SSC-Insane Points: 24685 More actions · Answer 8

Ejacksonjames (4/27/2010)
Hi I am new to SQL administration. We have over 100 production/development databases on multiple servers on different OS versions, win 2000 and 2003 server.

Depending on your budget alloted to you, there is a free program offered by Idera that you can use to get a view of the SQL jobs running on each instance. As long as your desktop or machine you have this running on can talk to each server.

SQL Job Manager[/url]

I have used it before and it is very useful for getting a quick view of those jobs that failed or had errors.

There are other pay for programs that work excellent as well (you get more for your buck), it is just what amount of money they will give you. Most major vendors thorugh (Quest, Idera, etc) will allow demo time for their programs.

Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton