Is it possible to create a dummy file filegroup to examine the contents of mdf?

Question

My application has a database that I create from a backup file as follows:

-- create empty db
CREATE DATABASE MyNewDB

-- restore on the empty db from file    
RESTORE DATABASE MyNewDB
FROM DISK = 'c:\Temp\MyNewDB.bak'
WITH REPLACE,
MOVE 'MyDB_Data' TO 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.EXPRESS2008R2\MSSQL\DATA\MyNewDB.mdf',
MOVE 'MyDB_Log' TO 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.EXPRESS2008R2\MSSQL\DATA\MyNewDB_log.LDF',
MOVE 'MyDBFS' TO 'C:\FileStreamData\MyNewDBFS'

I use the filestream filegroup to store only blobs, basically I have one table where the files are stored there, and one blob column containing binary data that is saved as SQL Server filter data.

As customers continue to use the application, part of the file stream becomes huge, maybe mdf is 500 MB and the stream is 60 GB.

Often, to debug a problem on a development machine, I need to pass "only tables" ("500 MB") and "not blobs" ("60 GB").

, , blob NULL ,

CHCEKPOINT

, , .

, .

, , , :

• .mdf + .ldf ( )

• - " " (, SQL Server )

• .mdf, .ldf

, , blobs , .

( , 3d party) , ?

Answer 1

, blob . . , , / .

script . script, . , , SQL 2014 SQL 2008 .. , , . ( "" → " ", .)

. , . blob blob.

, . https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/example-piecemeal-restore-of-only-some-filegroups-full-recovery-model

- A C. , , , . A C.

RESTORE DATABASE adb FILEGROUP='A', FILEGROUP='C' WITH RECOVERY  
RESTORE DATABASE adb FILEGROUP='B' FROM backup2b WITH RECOVERY  

filestream , . , . , , sql, , . sql , blob / ?

, , - , .

, , , , SQL .

sql. SSIS, , .