Enterprise wide Backup Audit

  • Comments posted to this topic are about the item Enterprise wide Backup Audit



    Pradeep Singh

  • Please remove the commented lines written before the < HTML > tag.



    Pradeep Singh

  • Hi Pradeep

    Can we get this as vbs file so that it can be scheduled?

    Thanks

  • Hi Praveen,

    Good point. I'll try to write this into a vbs file (i'm actually not too competent in vb scripting, learnt recently).

    Even then it'd prompt you twice with a message that "the script is running slow, do you want to abort it" where we've to select the option NO.



    Pradeep Singh

  • ok, thanks Pradeep.

    How about connectiong to named instances? The script doesnt seem to connect if I give servername\instancename?

  • It does connect to named instances.

    You need to provide the instance name in the following format

    ServerName\InstanceName

    in the servers.txt file.



    Pradeep Singh

  • Just wanted to throw this out there, it might be easier, especially for scheduling purposes, to use Powershell.

  • To calculate the duration you may find this a little better than the method you are currently using:

    CONVERT(CHAR(8), backup_finish_date - backup_start_date, 8) AS [Duration]

  • lrutkowski (8/6/2010)


    Just wanted to throw this out there, it might be easier, especially for scheduling purposes, to use Powershell.

    Yes. but i knew little powershell at that time. I also use cscript now and run this as bat file instead of running from IE.



    Pradeep Singh

  • BlackHawk-17 (8/6/2010)


    To calculate the duration you may find this a little better than the method you are currently using:

    CONVERT(CHAR(8), backup_finish_date - backup_start_date, 8) AS [Duration]

    Thanks for the feedback. Will implement it.



    Pradeep Singh

  • Hi Pradeep,

    We added 4 servers in the servers.txt file but found that after it runs for the 1 st server it gives all details in csv,runs for 2nd server gives half details.

    When I added 1 server only in txt it gives all the details in csv but at end of it throws error at bkp.wrtite str ... cannot write while it does write to the csv.. any help

  • Thanks for the script.

Viewing 12 posts - 1 through 11 (of 11 total)

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