Hi

I'm not really a MS SQL Admin. I have only one
system in our house holding an MS SQL DB.

I need to made a backup of the DB.
Can someone tell me what is the cheapest way?
To buy Backup Exec is not an option.

And I can't shut down the service while the backup is
running...

Regards and thanks in advance

Dominik

"Dominik Hirt" <removethis.dhi (AT) dhi (DOT) ch> wrote

Use QUERY Analyzer and look up details BACKUP DATABASE

You'll want something like BACKUP DATABASE 'foo' to
disk='\\remoteserver\share1\backupfilename.bak'

If your database is in full recovery mode, make sure to do a log backup also
on a regular basis.

And you can schedule backups also which is a good idea.

And all this can be done while the server is on line.





--
Greg Moore
SQL Server DBA Consulting
sql (at) greenms.com http://www.greenms.com

On Thu, 08 Mar 2007 16:36:50 GMT, "Greg D. Moore \(Strider\)"
<mooregr_deleteth1s (AT) greenms (DOT) com> wrote:

To be more specific, all this can ONLY be donw while the server is on
line.

Roy Harvey
Beacon Falls, CT

"Roy Harvey" <roy_harvey (AT) snet (DOT) net> wrote


True, but I was answering his specific question to that effect. I probably
should have been more clear in that regard.

--
Greg Moore
SQL Server DBA Consulting
sql (at) greenms.com http://www.greenms.com

Greg D. Moore (Strider) schrieb:
Many thanks. That worked for me.

Dominik

"Dominik Hirt" <removethis.dhi (AT) dhi (DOT) ch> wrote

Welcome. Glad I could help.



--
Greg Moore
SQL Server DBA Consulting
Email: sql (at) greenms.com http://www.greenms.com