hi,

1)First Take backup of current database with to NewTestDbNew.bak

BACKUP DATABASE [oldTestDb] TO DISK = N'D:\NewTestDbNew.bak' WITH NOFORMAT, NOINIT, SKIP, NOREWIND, NOUNLOAD, STATS = 10

GO

2) Restore above NewTestDbNew.bak to your required name and required file path.

RESTORE DATABASE [NewTestDbNew] FROM DISK = N'D:\NewTestDbNew.bak'

WITH FILE = 1, MOVE N'BACKUPAEMMS_Data'

TO N'E:\database\NewTestDbNew.MDF',

MOVE N'BACKUPAEMMS_Log' TO N'E:\database\NewTestDbNew_1.LDF',

NOUNLOAD, STATS = 10

GO