FILEGROUP restore from DB to DB

  • I have a VLDB VLtable (>300GB table) that I need to move from a development environment to a production environment. Our game plan was to use backup/restore of the filegroup to the new instance but in testing that plan we are failing. Is this "truly" not possible? If so, does anyone have any ideas on how to move 400GB in a table? Note: this is SS2005.

  • Not possible. Filegroups can't be restored to a different DB to the one they were backed up from.

    SSIS. Bulk insert. bpc.

    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
  • Or backup/restore the entire db, then remove the data you don't need.

    No good way to do this, but if I were choosing, I'd use SSIS as Gail suggested.

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

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