Post reply

Backup Reporting and job failure monitoring

  • August 23, 2012 at 8:44 am

    #265660

    Good afternoon,

    I have the following scenario:

    Management would like the following:

    1) Automate the backups & send notifications when there is a job failure.

    2) Produce reports to give status of backups.

    3) Database usage report.

    For the first point I'm comfortable with scheduling the jobs and generating email notifications if jobs fail.

    For the database usage report I'm also happy to produce this.

    For status of backups I'm also comfortable querying the needed DMVs.

    I know I will need to a create a centralised database to house all this information so that I can report on but I'm not sure where to store this database. I'm also unsure of how to get my information from the servers that are outside of the trusted network to my centralised database that's obviously going to live in the trusted domain.

    Hope I'm making sense.

    Any hints/tips would be greatly appreciated.

    Thanks in advance.

    ---------------------------------------------------------

    It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
    David Edwards - Media lens[/url]

    Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
    Howard Zinn

  • August 23, 2012 at 9:32 am

    #1529331

    Database usage report.

    what are you going to do on this?

    Regards
    Durai Nagarajan

  • August 23, 2012 at 9:36 am

    #1529335

    [quote-0but I'm not sure where to store this database. I'm also unsure of how to get my information from the servers that are outside of the trusted network to my centralised database that's obviously going to live in the trusted domain.

    [/quote-0]

    other domain servers can be connected using ip, cant u intergrate SSIS and try.

    i have try tried the complete sequence.

    Regards
    Durai Nagarajan

  • August 23, 2012 at 9:42 am

    #1529339

    durai nagarajan (8/23/2012)

    Database usage report.

    what are you going to do on this?

    Sorry but what I meant was that management would like a report that would give them information on database growth and available server disk space etc....

    ---------------------------------------------------------

    It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
    David Edwards - Media lens[/url]

    Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
    Howard Zinn

  • August 23, 2012 at 9:48 am

    #1529345

    durai nagarajan (8/23/2012)

    [quote-0but I'm not sure where to store this database. I'm also unsure of how to get my information from the servers that are outside of the trusted network to my centralised database that's obviously going to live in the trusted domain.

    other domain servers can be connected using ip, cant u intergrate SSIS and try.

    i have try tried the complete sequence.

    [/quote-0]

    Yes it may be possible to use SSIS for this. I've just checked and it is an installed component on one of the servers used for staging databases.

    ---------------------------------------------------------

    It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
    David Edwards - Media lens[/url]

    Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
    Howard Zinn

Viewing 5 posts - 1 through 4 (of 4 total)

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