SQL Online Backup...

[Arijit Chatterjee]

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

[Simon Hayes]

Re: SQL Online Backup...

arijitchatterje e123@yahoo.co.i n (Arijit Chatterjee) wrote in message news:<ea01504d. 0307162355.3617 3c44@posting.go ogle.com>...[color=blue]
> 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[/color]

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

[Scott S.]

Re: SQL Online Backup...

On 17 Jul 2003 00:55:31 -0700, arijitchatterje e123@yahoo.co.i n (Arijit
Chatterjee) wrote:
[color=blue]
>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[/color]

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