SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Enterprise wide Backup Audit


Enterprise wide Backup Audit

Author
Message
ps.
ps.
SSChampion
SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)

Group: General Forum Members
Points: 10777 Visits: 3668
Comments posted to this topic are about the item Enterprise wide Backup Audit



Pradeep Singh
ps.
ps.
SSChampion
SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)

Group: General Forum Members
Points: 10777 Visits: 3668
Please remove the commented lines written before the < HTML > tag.



Pradeep Singh
mr.praveeng
mr.praveeng
Forum Newbie
Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)

Group: General Forum Members
Points: 6 Visits: 13
Hi Pradeep

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

Thanks
ps.
ps.
SSChampion
SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)

Group: General Forum Members
Points: 10777 Visits: 3668
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
mr.praveeng
mr.praveeng
Forum Newbie
Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)

Group: General Forum Members
Points: 6 Visits: 13
ok, thanks Pradeep.

How about connectiong to named instances? The script doesnt seem to connect if I give servername\instancename?
ps.
ps.
SSChampion
SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)

Group: General Forum Members
Points: 10777 Visits: 3668
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
Leonard Rutkowski
Leonard Rutkowski
SSC Eights!
SSC Eights! (974 reputation)SSC Eights! (974 reputation)SSC Eights! (974 reputation)SSC Eights! (974 reputation)SSC Eights! (974 reputation)SSC Eights! (974 reputation)SSC Eights! (974 reputation)SSC Eights! (974 reputation)

Group: General Forum Members
Points: 974 Visits: 1213
Just wanted to throw this out there, it might be easier, especially for scheduling purposes, to use Powershell.
BlackHawk-17
BlackHawk-17
SSC-Enthusiastic
SSC-Enthusiastic (184 reputation)SSC-Enthusiastic (184 reputation)SSC-Enthusiastic (184 reputation)SSC-Enthusiastic (184 reputation)SSC-Enthusiastic (184 reputation)SSC-Enthusiastic (184 reputation)SSC-Enthusiastic (184 reputation)SSC-Enthusiastic (184 reputation)

Group: General Forum Members
Points: 184 Visits: 401
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]
ps.
ps.
SSChampion
SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)

Group: General Forum Members
Points: 10777 Visits: 3668
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
ps.
ps.
SSChampion
SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)

Group: General Forum Members
Points: 10777 Visits: 3668
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
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search