Post reply

Restoring from a backup

  • December 9, 2008 at 6:53 pm

    #203894

    Hi All,

    I have a database with like 500gigs on orimary .mdf file and

    like3 .ndf files of around 50 GB and if i take the backup and restore

    it back would it distribute data evenly across all four files or file

    pattern would still remain same.

    Thanks to all .

  • December 9, 2008 at 8:03 pm

    #910035

    The data pages will be restored to the same place within the file that is was in when the backup ran.

  • December 9, 2008 at 9:35 pm

    #910057

    And you need to be sure you have the same space available. Regardless of if you have 1MB of data in there, you'd still need to the 650GB of data space for the files.

  • December 10, 2008 at 7:11 am

    #910327

    Hi,

    When you restore the database backup files, it restores the database and data files in the same manner and size when it was backed up. So if your mdf file was around 500GB and ldf files was around 50GB at the time of backup, the restore will create the mdf and ldf file is same 500GB and 50GB size.

    Regards

    Atul

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

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