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

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

>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.net> wrote in message
news:0lh0v2pam34rqi0ps0sra9p5snboj68knn@4ax.com...
> On Thu, 08 Mar 2007 16:36:50 GMT, "Greg D. Moore \(Strider\)"
> <mooregr_deleteth1s@greenms.com> wrote:
>
>>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:
> 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.ch> wrote in message
newsPtJh.220196$Wn.61860@fe06.news.easynews.com. ..
> Greg D. Moore (Strider) schrieb:
>> 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