Video Screencast Help
Give us your opinion and win with Symantec! Please help us by taking this survey to tell us about your experience with Symantec Connect, so that we can continue to grow and improve.  Take the survey.

Script to Count the SQL DB's backed up in Daily manner

Created: 18 Mar 2009 • Updated: 18 Mar 2009 | 3 comments
Karthikeyan Sundaram's picture
0 0 Votes
Login to vote

Script to Count the SQL DB's backed up in Daily manner


1. Create a file D:\Servers.txt with List of Clients

2. Open the script file and change the line below as per your installed path.

Set objExec = objShell.Exec("SETX HOMEPATH D:\Program Files\Veritas\NetBackup\bin")

3.Save this file and execute it.

4.Output will be saved in Excel under D:\Details.xls

Find the attaced file for sample output.

Let me know if you face any issues.

Comments 3 CommentsJump to latest comment

peterdcross's picture

The script addresses a problem in backups which is knowing how many data bases are backed up in each instance of SQL configured. The problem as I have found out, is knowing how many should be backed up and then comparing that to the actual backup count. I have had an occurrence where an SQL instance with Backup All in the script was hanging on a database file and the remaining databases were not backed up, something like 13 of 19 databases in one SQL instance, which was one of several in a 4 server active-active setup. The database admins were moving the databases across the servers on a regular basis to complicate the issue. What is needed is a count of the databases installed as well as this backup count, then a simple list of any unsuccessful backups. I hope this comment provides food for thought for you.

Login to vote
Sathish Kumar R's picture

Hi Karthikeyan,

As per your advice , i have placed the "Servers" file in D drive with some server names. Also my master server has been installed in D drive only.I am executing this script , but it fails with error. Please find the attachment.

Login to vote
Karthikeyan Sundaram's picture


Sorry i have missed comments. Check out this 2 lines. It uses a temp staging test file. which will be created under this folder Test. You can create a folder called Test else remove the Test from that script line.

File_Name="D:\Test\" & strcomputer & ".txt"
Set myFile1 = myobj.CreateTextFile(File_Name, 2)

Thanks, Karthikeyan Sundaram.

Login to vote