December 2, 2004 at 11:45 am
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
December 3, 2004 at 5:22 am
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'
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply