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)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.0.1600.22+((SQL_PreRelease).080709-1414+)&LinkId=20476


I'd suggest restoring the database as is and then remove the superfluous log file afterward. The error is because the two logs have the same name and you're tying to restore to the same volume - restore one of them using a different name.

There may be a good reason why the database file has been split into two (one .MDF and one .NDF) check with whoever supports the application also look for filegroups.

  • +1. One of our vendor applications likes to do this, for performance reasons, and the customers usually put both files on the same disk anyway. Kinda foolish, but what can you do?
    – user3914
    Jan 5 '10 at 14:25

Not at the time of the restore. You'll need to restore it as is. Once it's on the server, you can remove the additional log file and move the objects stored in the .ndf file to the .mdf file.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.