...and if you don't want to spend any $$$ you can use the SQL Maintenance tools
to dump all of the databases to a disk (if you have space) and have Networker
do a file backup of the dumps. You would also want to do the same with the SQL
transaction logs.
Ben
-----Original Message-----
From: Terry Lemons [mailto:lemons_terry AT EMC DOT COM]
Sent: Wednesday, December 11, 2002 2:52 PM
To: NETWORKER AT LISTMAIL.TEMPLE DOT EDU
Subject: Re: MSSQL 2000 Backup
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.
=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=
--
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.
=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=
|