Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / How to Create a New Te...
Microsoft Dynamics NAV (Archived)

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

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

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

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: How to Create a New Test Database for Nav in SQL Server 2008 R2

    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.

  • Verified answer
    mmv Profile Picture
    mmv 11,465 on at
    RE: How to Create a New Test Database for Nav in SQL Server 2008 R2

    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).

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: How to Create a New Test Database for Nav in SQL Server 2008 R2

    Hi Mahesh,

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

  • Suggested answer
    Mohana Yadav Profile Picture
    Mohana Yadav 59,139 Super User 2024 Season 2 on at
    RE: How to Create a New Test Database for Nav in SQL Server 2008 R2

    Yes please. add test at the end etc.

  • mmv Profile Picture
    mmv 11,465 on at
    RE: How to Create a New Test Database for Nav in SQL Server 2008 R2

    Hi,

    Did you create the test db before you could restore?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: How to Create a New Test Database for Nav in SQL Server 2008 R2

    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

  • Suggested answer
    Mohana Yadav Profile Picture
    Mohana Yadav 59,139 Super User 2024 Season 2 on at
    RE: How to Create a New Test Database for Nav in SQL Server 2008 R2

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

  • mmv Profile Picture
    mmv 11,465 on at
    RE: How to Create a New Test Database for Nav in SQL Server 2008 R2

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans