December 13, 2012 at 3:24 pm
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
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
December 13, 2012 at 5:03 pm
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