Enterprise wide Backup Audit

Question

Post reply

Enterprise wide Backup Audit

ps.

One Orange Chip

Points: 29422
More actions
November 12, 2009 at 9:07 pm

#216700

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

Pradeep Singh

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

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

ps. One Orange Chip Points: 29422 More actions · Answer 1

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

Pradeep Singh

mr.praveeng SSC Rookie Points: 30 More actions · Answer 2

Hi Pradeep

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

Thanks

ps. One Orange Chip Points: 29422 More actions · Answer 3

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 SSC Rookie Points: 30 More actions · Answer 4

ok, thanks Pradeep.

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

ps. One Orange Chip Points: 29422 More actions · Answer 5

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 SSCrazy Points: 2668 More actions · Answer 6

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

BlackHawk-17 SSChasing Mays Points: 628 More actions · Answer 7

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. One Orange Chip Points: 29422 More actions · Answer 8

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. One Orange Chip Points: 29422 More actions · Answer 9

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

das.priti Grasshopper Points: 11 More actions · Answer 10

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

akljfhnlaflkj SSC Guru Points: 76202 More actions · Answer 11

akljfhnlaflkj

SSC Guru

Points: 76202

May 23, 2016 at 7:02 am

#1880734

Thanks for the script.