Post reply

Restore .mdf file on different drives with One backup file?

  • March 8, 2011 at 9:52 am

    #233689

    I have a 500gb file( this db has only one mdf of around 450gb). I need to use this backup but split the mdf's in multiple on the target like i want to have the first mdf 200gb,second 150 gb and so on. Is that possible?

  • March 8, 2011 at 10:01 am

    #1295987

    No, that's not possible. A restore would create the same files as the original database.

    If you're short of disk space, you could consider using Red Gate's SQL Virtual Restore to mount the backup file as a database.

    If you want to split the mdf file, I think you'll need to first restore the database, then create new filegroup(s), then move data from the primary filegroup to the new filegroup(s).

    SQL BAK Explorer - read SQL Server backup file details without SQL Server.
    Supports backup files created with SQL Server 2005 up to SQL Server 2017.

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

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