Dear Friends,
I don't know anybody has asked this question before or not.But I need
a support urgently.How to take online backup in MS Sql server 2000.
Thanks
Arijit Chatterjee

arijitchatterjee123@yahoo.co.in (Arijit Chatterjee) wrote in message news:<ea01504d.0307162355.36173c44@posting.google. com>...
> Dear Friends,
> I don't know anybody has asked this question before or not.But I need
> a support urgently.How to take online backup in MS Sql server 2000.
> Thanks
> Arijit Chatterjee

What do you mean by an "online" backup? If you mean how to backup a
database without stopping MSSQL or taking the database offline, then
that is how all backups work. In other words, you can always do this,
even with active users connected to the database:

backup database MyDB to ...

There is a lot of information in Books Online about backup and restore
operations, so you might want to read up on this. If that doesn't
answer your question, perhaps you could give some more detail on what
your problem is, and what exactly you mean by an "online backup"?

Simon

On 17 Jul 2003 00:55:31 -0700, arijitchatterjee123@yahoo.co.in (Arijit
Chatterjee) wrote:

>Dear Friends,
>I don't know anybody has asked this question before or not.But I need
>a support urgently.How to take online backup in MS Sql server 2000.
>Thanks
>Arijit Chatterjee

I know of a company that does online backups and specializes in open
source backups (MS Exchange and SQL Server). If you want more
information, contact me offline.

Scott