Restore

• Nita Reddy

  SSCarpal Tunnel

  Points: 4177

  More actions

  December 2, 2004 at 11:45 am

  #102300

  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

• RandyB

  SSCommitted

  Points: 1565

  More actions

  December 3, 2004 at 5:22 am

  #532391

  When restoring, did you use the MOVE keyword.

  Here is an example from BOL:

   

  RESTORE DATABASE TestDB

     FROM DISK = 'c:\Northwind.bak'

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

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