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

  • 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?

    ---------------------------------------------------------------------