Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

Automate Disaster Recovery Prep of SEP 11 Site

Created: 25 Mar 2009 • Updated: 22 May 2010 | 7 comments

Hello, I'm trying to automate the Disaster Recovery preparation procedure for my site and the only thing I can't locate is a way to run a backup of my DB from a command-line. I located the dbtools.bat file that launches the Database Backup and Restore utility...but beyond that, I'm not sure how to use dbtools (or something else) to script the backup.

Any suggestions?

Thanks,

-Mike

Comments 7 CommentsJump to latest comment

Maximilian's picture

Why do you need to do it from a command line?
_______________________________________________
Page 285 in the Admin Guide

1

In the console, click Admin, and then click Servers.

2

embedded database and whose backup settings you want to change.

Under View Servers, click the icon that represents the Microsoft SQL or

3

Under Tasks, click Edit Backup Settings.

4

In the Backup Site for Local Site dialog box, click Schedule Backups.

5

then specifying one of the following options:

Specify the backup frequency by selecting Hourly, Daily, or Weekly, and

after the hour that backups should occur.

If you choose Hourly, in the Start Time box, specify the number of minutes

to indicate at what time each day backups should occur.

If you choose Daily, in the Start Time box, specify the hour and minutes

Managing databases

Scheduling automatic database backups from the Symantec Endpoint Protection Manager

284

to indicate the time that backups should occur.

If you choose Weekly, in the Start Time box, specify the hour and minutes

which backups should occur.

If you choose Weekly, specify the Day of Week to indicate the day on

6

At the scheduled time, backups occur automatically and are placed in a .zip

file that is labeled with the date on which the backup occurs. The backup file

is stored in a backup folder that is created in the path as specified for the

server data root.

For example, a backup file that is created on August 1, 2007 at 9:46 AM is

called 2007-Aug-01_09-46-13-AM.zip.

Click OK.

Sandeep Cheema's picture

I think the point is to automate the procedure so that it can be integrated with the install procedure and distributed to the site admins with a doc. Good idea.
I tried to get somewhere, But the command line inside dbtools.bat runs the javaw.exe process and with parameters but that just launches the GUI for the backup thing when executed. Even Processmonitor doesnt read the command line other than the default. But if tried a little harder I think it's possible.

 

De facto when AV does something, it starts jumping up and down, waving its arms, and shouting...

"Hey!  I found a virus!  Look at me!  I'm soooo goooood!"

iamadmin's picture

Thanks Maximilian!

This is a possible work around but I'd still like to find a way to start the backup manually outside of the console.

With your method I could automate the backup as you suggested, then use my custom utility to look for the "current" backup in the "Backup Folder".

Have a great day!

-Mike

iamadmin's picture

"I think the point is to automate the procedure so that it can be integrated with the install procedure and distributed to the site admins with a doc. Good idea.
I tried to get somewhere, But the command line inside dbtools.bat runs the javaw.exe process and with parameters but that just launches the GUI for the backup thing when executed. Even Processmonitor doesnt read the command line other than the default. But if tried a little harder I think it's possible."

 
Sandeep, you have read my mind.That is exactly what I was thinking! If you have any success, please do let me know. I'd be happy to share my utility if we can come up with a solution.

-Mike

Maximilian's picture

It sounds like a great idea and I hope you come up with a working solution