"Dominik Hirt" <re************@dhi.chwrote in message
news:tC********************@fe05.news.easynews.com ...
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.
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.
And I can't shut down the service while the backup is
running...
Regards and thanks in advance
Dominik
--
Greg Moore
SQL Server DBA Consulting
sql (at) greenms.com
http://www.greenms.com