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