What are the challenges you face when working across database platforms? Take the survey

Restore of multi datafiles via gui

eilanddeilandd Posts: 44
edited July 30, 2010 4:26AM in SQL Backup Previous Versions
There seems to be an issues with relocating multiple datafiles within a single file group when restoring via the gui. We are using SQL Backup

We are relocating our database to a new server. In this move the logical drives for all the datafiles are being changed. When using the gui to do the restore the script generated only contains one datafile for the the file groups that have multiple datafiles.

Of course our correction was to copy the script to SSMS, correct it and execute it manually.


  • Options
    Brian DonahueBrian Donahue Posts: 6,590 Bronze 1

    I believe this is a long-standing issue with SQL Backup we know about already. SQL Backup attempts to idiot-proof the restore by changing the data file paths to a valid location on the server. You just have to remember to go into the files and folders bit and set the destination files manually.
  • Options

    Thanks for the reply. However, this was not an issue about paths. We are splitting our data files across multiple paths and had to touch the settings for that reason anyway. The issue was that the script only contained a entry for one data file per file group while we have multiple files for several file groups. After further testing here is what we found:

    1) Normally we take single file non-encrypted backups. A restore from one of these backups, changing the data file locations, would generate a correct script.

    2) We took a 5 file non-encrypted backup and a backup using it, also relocating the data files, generated the correct script as well.

    3) In moving our data center we generated a 10 file encrypted backup, for transmission we wanted the files fairly small. When attempting to restore with this backup, relocating the data files, the generated script only contains 1 data file in each file group.

    This is not a normal situation for us so it is not a critical problem for us. We have successfully restored all of our databases in our new hosting center.
  • Options
    Brian DonahueBrian Donahue Posts: 6,590 Bronze 1

    I'll have to look into this a bit further, but SQL Backup definitely does support multiple files in a filegroup as described on our knowledge base.
Sign In or Register to comment.