Tom,

What we did was use a PRE command to run the "sqlmaint" command.  That
command should be in the \Binn folder.

Try this syntax:

Binn>sqlmaint -S "MyServerName" -D "MyDatabaseName" -BkUpDB
"PathToMyBackupFolder" -BkUpMedia DISK

The utility will assign a filename.

When I pointed it at our McAfee ePolicy Orchestrator database it yielded a
backup file called:
ePO_CORP-NM1TEST_db_200211140730.BAK
which is a concatenation of the server and database names, plus the date
and time of the backup.

This utility cranks out the backup with the database UP, so there is no
downtime and no need for a restart script.

Good luck.

Tab Trepagnier
TSM Administrator
Laitram LLC







Del Hoobler <hoobler AT US.IBM DOT COM>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
01/27/2003 07:50 PM
Please respond to "ADSM: Dist Stor Manager"


        To:     ADSM-L AT VM.MARIST DOT EDU
        cc:
        Subject:        Re: Support for backing up MSDE?


Tom,

Data Protecton for SQL will probably work...
... but it is not a "supported" environment.

Del

============================================================

> Is there a TSM agent to back up MSDE (Microsoft Data Engine)? Would the
> MS-SQL Server agent work?