Back up and restore in sql server 2000

• suri1984

  SSC-Addicted

  Points: 463

  More actions

  June 30, 2008 at 1:59 pm

  #71625

  HI,

  I have a back up of a named instance1.how do i restore that backup to the named instance 2 in sql server 2000?

  Thanks for ur help

• Greg Charles

  SSC-Forever

  Points: 45403

  More actions

  July 1, 2008 at 9:24 am

  #836776

  You have a database backup? Whether it's from a named instance doesn't matter. In instance 2, use

  RESTORE DATABASE mydatabase

  FROM DISK = 'filepath'

  WITH RECOVERY

  You'd use variations of this depending on whether you have additional differential and/or log backups. See 'RESTORE' in BOL for examples.

  Greg