I'm trying to restore a BAK of a database we have, onto new, better hardware. Here is a screenshot of the UI in Management Studio
The existing db has an mdf, and ndf file... and two log (ldf) files...
Is there any way I can restore it so that it just has ONE mdf and ONE ldf file...?
The existing db is SQL 2000 - I'm restoring it to a SQL 2008 instance - I created the db in 2000 compatibility mode however.
...as a side note: If i click Ok, in the screen shown above, i get the following error:
File 'D:\Navision4.LDF' is claimed by 'Navision4_Log3'(5) and 'Navision4_Log'(2). The WITH MOVE clause can be used to relocate one or more files. (Microsoft.SqlServer.Smo)