Restore

• Nita Reddy

  SSCarpal Tunnel

  Points: 4171

  More actions

  December 2, 2004 at 11:59 am

  #109769

  I have HEALTH database in Production as well in Development,

  I Created a new database called HEALTH_DEV in development and I want to restore HEALTH data from production.

  When I tried to restore in Health_dev from production Health database its giving me an error data file is already there...and its pointing to Health_data.mdf instead of Health_dev_data.mdf

  When I try to change the path still its giving me an error.

  Nita

• Allen Cui-55137

  SSC Guru

  Points: 51650

  More actions

  December 2, 2004 at 1:21 pm

  #532288

  Drop the database HEALTH_DEV and restore production database backup into it with 'move' parameter. For example,

  RESTORE DATABASE TestDB

     FROM DISK = 'c:\Northwind.bak'

     WITH MOVE 'Northwind' TO 'c:\test\testdb.mdf',

     MOVE 'Northwind_log' TO 'c:\test\testdb.ldf'