restore backup in dynamic nav

Business Central/NAV Technical Forum
1

Hi guys i face problem how i make restore to backup in dynamic nav connected to sql server 2005 i have already backup but

the problem in restore(i mean restore backup in dynamic nav not in classic)

2

You have SQL backup and want to restore it in SQL server, right?

3

it seems that you have blackup of of native database, is it ?

4

No i have dynamic nav backup but i want to restore(meaning i need dynamic nav backup display as database in sqlserver 2005)

5

you have navision backup and want to restore in new database and show in SQL,right?

6

yes true

7

Open Microsoft Dynamics NAV 2009 R2 Classic with Microsoft SQL Server and click File–>Database–>New

Enter the Database name and files to store

the restore the backup in created database…

8

For Restoration

Go to File–> Database–> Click on New-> Select Server Name, and authetication(Userid,password) →

Give Database Name in General Tab

Click on Database Files Tab and In File Name Field give path of Data File

Click on Transaction Log Files Tab and In File Name Field give path of Log File

Click on Ok

This will create New Database

Now for restoration of DB

Click on Tools–> Restore–> Select Backup File

Thats it