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

  • You'll have to create a new database with just the single data file and export / import the data from the old database to the new one. There are numerous utilities out there that will do this. If you don't have alot of internal RI the easiest method would be the import/export SSIS wizard.