Tags: alli, backup, database, dbname, disk, files, haveperformed, mdf, microsoft, multiple, mysql, ndf, oracle, restore, server, sql

Restore Database with Multiple Files

On Database » Microsoft SQL Server

1,658 words with 1 Comments; publish: Tue, 20 May 2008 01:26:00 GMT; (25046.88, « »)

All

I have a database with multiple files ie. an mdf and two ndf. I have

performed a full database backup using BACKUP DATABASE dbname to DISK =

'filename' and I would like to restore the database to another server and

only have one file ie. PRIMARY mdf instead of the three files. Can anyone

advise how this can be achieved.

Thanks

All Comments

Leave a comment...

  • 1 Comments
    • That is not possible. A SQL Server backup is more or less a binary dump if t

      he data pages, so SQL

      Server need to put each page in the same file and on the same page address (

      as other pages might be

      pointing to this page). Restore as original, and do the shuffling after the

      restore. Or do the

      shuffling before the backup.

      Tibor Karaszi, SQL Server MVP

      http://www.karaszi.com/sqlserver/default.asp

      http://www.solidqualitylearning.com/

      http://www.sqlug.se/

      "David" <David.sqlserver.todaysummary.com.discussions.microsoft.com> wrote in message

      news:89EB659B-C421-4DB2-BB1B-17D30C6CFB8A.sqlserver.todaysummary.com.microsoft.com...

      > All

      > I have a database with multiple files ie. an mdf and two ndf. I have

      > performed a full database backup using BACKUP DATABASE dbname to DISK =

      > 'filename' and I would like to restore the database to another server and

      > only have one file ie. PRIMARY mdf instead of the three files. Can anyone

      > advise how this can be achieved.

      > Thanks

      >

      #1; Tue, 20 May 2008 01:27:00 GMT