Post reply

Restore a backup from primary filegroup into the secondary filegroup

  • January 20, 2017 at 2:53 am

    #320700

    Hi,

    We have to migrate a SQL-2008 DBe to SQL 2014. All 300 tables are hosted in primary filegroup.
    The new server has a secondary filegroup with multiple files.
    Can i restore a backup from old server to the new server into the secondary filegroup? (Upgrade advisor is done)
    Or, have i to move the tables manually from primary to secondary (over clustered index).
    Or, create a empty Target-DB with (Insert into new table - Select from old table) for all 300 tables 🙁 ?
    What is the most effective way to do this?
    Or are there helping tools to do a lot of this work?

    Regards
    Nicole

  • January 20, 2017 at 3:34 am

    #1923957

    info 58414 - Friday, January 20, 2017 2:53 AM

    Can i restore a backup from old server to the new server into the secondary filegroup? (Upgrade advisor is done)

    No.

    Restoring a backup will recreate the DB as it was at time of backup, so once you restore that database on the new server, all tables will be in Primary. You can then create the secondary filegroup and move the tables over.

    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

  • January 23, 2017 at 10:26 pm

    This was removed by the editor as SPAM

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

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