Two SQL versions installed - How to manage?

Business Central/NAV Technical Forum
1

Hi everyone,

I started working with NAV 2009 R2, having SQL Server 2005 SP3 installed…
Today, I installed SQL Server 2008 R2.

I wanted to ask how can I , from now on, when I need to restore a backup, select which SQL Server to use???

And what about the existing databases (in SQL Server 2005)??? Shall I simply restore them again in SQL Server 2008???

2

You can restore older version DB i.e 2005 directly on Sql Server 2008. It will work.

3

While creating new database you need to manually give Server name so you can enter either SQL2005 or SQL2008