Thanks for the input Crispin. I was hoping I was missing something, but your comment about "reassemble the blob" was my opinion also.

I wanted to use SQL, because, In...

Here are the filegroups:

Name FileID FileName FileGroup Size Maxsize Growth Usage

Doc_main 1 e:\mssqldata\Doc.mdf PRIMARY 116736 KB Unlimited 1024 KB data only

Doc_Log  2 f:\MSSQLDataLog\Doc_log.ndf NULL 2376256 KB 2147483648 KB 10% log only

FG_default 3 e:\mssqldata\fg.ndf FG 5120 KB Unlimited 1024 KB data only

FG1_dat  4 e:\mssqldata\fg1.ndf FG1 136236032 KB Unlimited 1024 KB data only

FG2_dat  5 e:\mssqldata\fg2.ndf FG2 110420992 KB Unlimited 1024 KB data only

FG3_dat  6 e:\mssqldata\fg3.ndf FG3 110420992 KB Unlimited 1024 KB data only

FG4_dat  7 e:\mssqldata\fg4.ndf FG4 110420992 KB Unlimited 1024 KB data only

FG5_dat  8 e:\mssqldata\fg5.ndf FG5 110420992 KB Unlimited 1024 KB data only

FG6_dat  9 e:\mssqldata\fg6.ndf FG6 110420992 KB Unlimited 1024 KB data...

Here are the table definitions. The table tblDocInfo has DocInfoID, which is the FK in tblDocs. The partitions are defined by this key.