Hi all.

I'm wondering if anybody has a way of backing up (successfully) a MS SQL
Server 2000 database while it is up and running.

Every night, the backups fail (partially) because certain SQL Server files
are open.

The way we do it with our MySQL databases, is by running mysqldump which
dumps the entire database into a flat file and that file gets backed up.  To
restore we just import that flat file back into MySQL.  Is this a good way of
doing it with MS SQL Server?  Is there a better way?

Thanks,

-Matt
--
----------
Matt Hemingway
matt.hemingway AT pcnalert DOT com
http://www.pcnalert.com
626-585-2788 x136
----------

--
Note: To sign off this list, send a "signoff" command via email
to listserv AT listmail.temple DOT edu or visit the list's Web site at
http://listmail.temple.edu/archives/networker.html where you can
also view and post messages to the list.
=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=