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

  • Hi Robin,

    A standard restore would attempt to create the database files at the same paths as the original files.

    You can use the WITH MOVE option in the RESTORE statement to give the files new paths if required.

    No need to create the original database first.

    Cheers