Backup of a MS SQL 2000 DB

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@.dhi.chwrote in message
news:tCWHh.183311$_X1.48044@.fe05.news.easynews.com ...

Quote:

Originally Posted by

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.

Quote:

Originally Posted by

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|||On Thu, 08 Mar 2007 16:36:50 GMT, "Greg D. Moore \(Strider\)"
<mooregr_deleteth1s@.greenms.comwrote:

Quote:

Originally Posted by

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

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@.snet.netwrote in message
news:0lh0v2pam34rqi0ps0sra9p5snboj68knn@.4ax.com...

Quote:

Originally Posted by

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

Quote:

Originally Posted by

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

>
To be more specific, all this can ONLY be donw while the server is on
line.
>
Roy Harvey
Beacon Falls, CT

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:

Quote:

Originally Posted by

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.

Many thanks. That worked for me.

Dominik|||"Dominik Hirt" <removethis.dhi@.dhi.chwrote in message
news:DPtJh.220196$Wn.61860@.fe06.news.easynews.com. ..

Quote:

Originally Posted by

Greg D. Moore (Strider) schrieb:

Quote:

Originally Posted by

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

>
Many thanks. That worked for me.
>
Dominik

Welcome. Glad I could help.

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