How to Create a New Test Database for Nav in SQL Server 2008 R2

(0) Share

Report

Posted on by Community Member

I created a New Database in SQL Server 2008 R2 for Creating a Test in Environment for MS Dynamics NAV in the same SQL Server where our Live Database exists. The idea is that I want to restore the Live Backup Data to the Test Database. My Question is Can I safely restore the Live Data to Test Database? I am getting the error " the backup set holds a backup of other a database other than the existing" when I try to restore it. And how safe it is to use the Restore with Replace Option because I don't want to alter the LIVE Database in any case.

Thank you,

*This post is locked for comments

I have the same question (0)

All responses (8)

Answers (1)

mmv 11,471 on at

Like (0)

Report

Hi,

It means that you have created a database and trying to restore the backup to that database. Instead, try to restore the backup with a new database name.

Was this reply helpful? Yes No
Suggested answer

Mohana Yadav 61,001 Super User 2025 Season 2 on at

Like (0)

Report

Also check the backup file names like mdf and ldf are different to Live file names.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Those files you mentioned are the same as the live , I checked them on Options Tab of the Properties. So do have to change them? And The Test Database Name is different from the Live.

Thanks

Was this reply helpful? Yes No
mmv 11,471 on at

Like (0)

Report

Hi,

Did you create the test db before you could restore?

Was this reply helpful? Yes No
Suggested answer

Mohana Yadav 61,001 Super User 2025 Season 2 on at

Like (0)

Report

Yes please. add test at the end etc.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Mahesh,

Yes , I created the test DB first and I try to restore the bkp of the live data from disk.

Was this reply helpful? Yes No
Verified answer

mmv 11,471 on at

Like (0)

Report

Hi,

Don't create the DB first. Just try to restore with a new db name. (you have an option to put the db name. Please enter a new name and proceed).

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

You need to be very careful, when you are planning to setup the test environment in the same live machine.

It is not advisable at all, as you might end up restoring the Test DB on live database, if you are not well versed with the SQL database & files..

Better you look for any other machine and plan for the required development or test environment setup there.

Was this reply helpful? Yes No