In simple terms:
create a new database on SQL Server and restore the backup.
But I guess this isn't what you're looking for?
Thats all that i thought was needed, i've created the database and snyched the users but the new database isn't showing up in the list when i try to select it in NAV!?
Are you using the 'Microsoft SQL Server Option for the CSIDE Client' shortcut now? They'll look similar but it's a new executable you'll launch to get at a SQL instance.
Comments
create a new database on SQL Server and restore the backup.
But I guess this isn't what you're looking for?
Eric Wauters
MVP - Microsoft Dynamics NAV
My blog
Is your SQL Browser running?
Eric Wauters
MVP - Microsoft Dynamics NAV
My blog
For any queries you can also visit my blog site: http://msnavarena.blogspot.com/