SQL Online Backup...

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Arijit Chatterjee

    SQL Online Backup...

    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

    #2
    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

    Comment

    • Scott S.

      #3
      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

      Comment

      Working...