Post reply

FILEGROUP restore from DB to DB

  • December 13, 2012 at 3:24 pm

    #272037

    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.

  • December 13, 2012 at 3:43 pm

    #1568516

    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

  • December 13, 2012 at 5:03 pm

    #1568526

    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