Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Enterprise wide Backup Audit Expand / Collapse
Author
Message
Posted Thursday, November 12, 2009 9:07 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, November 10, 2014 2:21 AM
Points: 2,223, Visits: 3,652
Comments posted to this topic are about the item Enterprise wide Backup Audit




Pradeep Singh
Post #818224
Posted Thursday, December 3, 2009 1:57 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, November 10, 2014 2:21 AM
Points: 2,223, Visits: 3,652
Please remove the commented lines written before the < HTML > tag.





Pradeep Singh
Post #828006
Posted Thursday, December 3, 2009 2:20 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, December 7, 2009 9:05 PM
Points: 2, Visits: 13
Hi Pradeep

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

Thanks
Post #828012
Posted Thursday, December 3, 2009 3:46 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, November 10, 2014 2:21 AM
Points: 2,223, Visits: 3,652
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
Post #828037
Posted Monday, December 7, 2009 2:27 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, December 7, 2009 9:05 PM
Points: 2, Visits: 13
ok, thanks Pradeep.

How about connectiong to named instances? The script doesnt seem to connect if I give servername\instancename?
Post #829706
Posted Monday, December 7, 2009 6:08 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, November 10, 2014 2:21 AM
Points: 2,223, Visits: 3,652
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
Post #829777
Posted Friday, August 6, 2010 6:27 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, December 16, 2014 2:40 PM
Points: 160, Visits: 984
Just wanted to throw this out there, it might be easier, especially for scheduling purposes, to use Powershell.
Post #965058
Posted Friday, August 6, 2010 7:01 AM


SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, June 4, 2014 7:34 AM
Points: 42, Visits: 398
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]
Post #965110
Posted Friday, August 6, 2010 9:23 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, November 10, 2014 2:21 AM
Points: 2,223, Visits: 3,652
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
Post #965247
Posted Friday, August 6, 2010 9:23 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, November 10, 2014 2:21 AM
Points: 2,223, Visits: 3,652
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
Post #965250
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse