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.
SSCoach
SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)

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



Pradeep Singh
ps.
ps.
SSCoach
SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)

Group: General Forum Members
Points: 15504 Visits: 3674
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.
SSCoach
SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)

Group: General Forum Members
Points: 15504 Visits: 3674
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.
SSCoach
SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)

Group: General Forum Members
Points: 15504 Visits: 3674
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
Ten Centuries
Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)

Group: General Forum Members
Points: 1414 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 Veteran
SSC Veteran (264 reputation)SSC Veteran (264 reputation)SSC Veteran (264 reputation)SSC Veteran (264 reputation)SSC Veteran (264 reputation)SSC Veteran (264 reputation)SSC Veteran (264 reputation)SSC Veteran (264 reputation)

Group: General Forum Members
Points: 264 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.
SSCoach
SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)

Group: General Forum Members
Points: 15504 Visits: 3674
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.
SSCoach
SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)

Group: General Forum Members
Points: 15504 Visits: 3674
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