Hi Matt

Legato's NetWorker Module for SQL Server is very powerful; check out the
document, "The Legato NetWorker® Module for Microsoft® SQL Server(tm)
Installation Guide Release 3.1 Windows® Version"
(http://web1.legato.com/infodev/publications/BSM_MSSQL/3.1/nmsqlig.pdf).
See the features of the product on pp. 11-13.  Though it costs a few
thousand dollars, you might find this well worth it, as it will eliminate
fiddling with scripts and other weirdness.

And, it certainly backs up your database while it is online.

Hope this helps.
tl

Terry Lemons
CLARiiON Applications Integration Engineering
        EMC²            
where information lives

4400 Computer Drive, MS D239
Westboro MA 01580
Phone: 508 898 7312
Email: Lemons_Terry AT emc DOT com


-----Original Message-----
From: Matt Hemingway [mailto:matt.hemingway AT pcnalert DOT com]
Sent: Wednesday, December 11, 2002 2:42 PM
To: NETWORKER AT LISTMAIL.TEMPLE DOT EDU
Subject: [Networker] MSSQL 2000 Backup


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.
=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=

--
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.
=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=