Posted by Greg D. Moore \(Strider\) on 03/08/07 16:36

"Dominik Hirt" <removethis.dhi@dhi.ch> wrote in message
news:tCWHh.183311$_X1.48044@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

[Back to original message]