Home Forums SQL Server 2008 SQL Server 2008 - General Restore a backup from primary filegroup into the secondary filegroup RE: Restore a backup from primary filegroup into the secondary filegroup

  • 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