Database transfer

• Senthil T

  Hall of Fame

  Points: 3367

  More actions

  September 25, 2006 at 3:18 pm

  #114462

  [Cross post]

  Hi,

  I have to transfer the database from one hard drive (secondary) to another hard drive (primary) on the same machine. There is nothing in the primary database. I just installed sql server 2000 on it. Is it enough if I do a 'database backup' from the secondary database and do a 'restore database' in the primary database?

  Do I have to worry about the system databases, like master, msdb etc? Will the user and login information will be transfered? Can I transfer sql server agent jobs?

  Thanks.

• Prasad Bhogadi

  SSCrazy Eights

  Points: 9235

  More actions

  September 26, 2006 at 3:32 am

  #662429

  Yes you can do a backup and restore to map the files to a location on your primary hard drive.

   

  Prasad Bhogadi
  www.inforaise.com