Backing up MSDE 1

[kmcferrin]

Sorry if it seems like I'm a total newb, but I don't deal with SQL databases much.

We are using Veritas BackupExec 9.0 to do backups in a Win2K environment. One of our servers runs an application that makes use of an MSDE database (the SQL7 version, if that matters). Every time BackupExec trys to backup that server, the DB files are listed as an exception. Is there any way to get those files backed up without resorting to purchasing a Veritas SQL Agent license?

We do have a couple SQL servers that we have configured to backup to disk, then let our backup software backup the backup files and exclude the hot copies of the DB. Is it possible to do the same thing with MSDE since it is essentially a stripped-down version of SQL server? If so, how? I'm a bit lost without the SQL Manager GUI.

 

[nigelrivett]

>> We do have a couple SQL servers that we have configured to backup to disk, then let our backup software backup the backup files and exclude the hot copies of the DB. Is it possible to do the same thing with MSDE since it is essentially a stripped-down version of SQL server? If so, how? I'm a bit lost without the SQL Manager GUI.

Yes and it's the way to go
MSDE is similar to the full version but without the gui. If you have the full version then you will have enterprise manager which you can use to connect to the msde servers and configure in the same way.

======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

 

[kmcferrin]

Doh! Sometimes the answer is so simple that you wouldn't even think of it.

Thanks!