Home Forums SQL Server 2005 Backups Move from a multiple file database to single file with backup+restore RE: Move from a multiple file database to single file with backup+restore

  • george sibbald (1/4/2012)


    I am afraid you cannot use backup\restore to change the number of files. All you can do is change where those files are restored to (a single drive from multiple drives for instance)

    do you have multiple filegroups or just multiple files, or a mixture of the two?

    Hi George

    There is one primary filegroup.

    This contains:

    1 x MDF file

    6 x NDF files

    1 x LDF file

    All these files are on the same logical disk in the mssql\data folder.

    Would you know another way of achieving our aims?