Home Forums SQL Server 2005 Backups restore several .ndf files to one mdf file RE: restore several .ndf files to one mdf file

  • No - you cannot restore a database with multiple files and reduce the number of files. What you have to do is restore the database with all of the files, then remove the extra files using shrinkfile and emptyfile (look it up in help).

    Jeffrey Williams
    “We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

    ― Charles R. Swindoll

    How to post questions to get better answers faster
    Managing Transaction Logs