• 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'