Post reply

restore a database using multiple mdf files

  • May 20, 2008 at 2:37 am

    #70482

    is it possible to restore a database using multiple mdf files?

  • May 20, 2008 at 2:55 am

    #817645

    Databases only have 1 mdf file. They can have multiple ndf files (secondary data files)

    Could you explain a bit more what you're trying to do? I'm not sure that I understand what you're asking.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • May 20, 2008 at 2:58 am

    #817646

    Hi

    I know there is a feature to do a backup and split the backup into multiple files:

    So if you have a 10GB DB to backup and specify 3 files:

    Backup1.BAK Size approx 3.3GB

    Backup2.BAK Size approx 3.3GB

    Backup3.BAK Size approx 3.3GB

    These are .BAK files though.

    To answer your question, you can restore to a Database using your .BAK files.

    In the process of the restore - you can not* restore to anything other than what the original Data and Log files were at the time of the Backup. Once you have your DB you can create more Filegroups etc.

    Maybe you can let us know what you have and what you are trying to do

    Thanks

    Kevin

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply