How does SQL 2000 Server back up user database?

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • B-BoB
    #1

    How does SQL 2000 Server back up user database?

    Hi All,

    Would someone give me an explanation on how SQL 2000 server backs up a
    user database? Is SQL server make a copy of user database first, and
    then backup it up to a defined backup device? Or is it going straight
    to the defined backup device.

    Thanks,
    Bob.

    Tags: None
    • Simon Hayes
      #2
      Re: How does SQL 2000 Server back up user database?


      "B-BoB" <balebob@hotmai l.com> wrote in message
      news:1110561950 .350420.193350@ z14g2000cwz.goo glegroups.com.. .[color=blue]
      > Hi All,
      >
      > Would someone give me an explanation on how SQL 2000 server backs up a
      > user database? Is SQL server make a copy of user database first, and
      > then backup it up to a defined backup device? Or is it going straight
      > to the defined backup device.
      >
      > Thanks,
      > Bob.
      >[/color]

      The backup goes straight to the backup file or device - there's no
      'temporary' copy of the data, if that's what you mean. Part of the
      transaction log is included in the backup, to make sure that the data is
      consistent.

      Simon


        Comment

        Previous template Next
        Working...