A backup/copy is always an exact 1:1 copy with anything included in the database, you can not make a partial backup/copy of a database.
Why do you want to?
Export/Copy database without filestream data
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(284.8, 63%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ED%3C/text%3E%3C/svg%3E)
DSSH
61
Reputation points
New to this but can I take an export/copy of a database but NOT export/copy the filestream data? If so, how?
SQL Server | Other
2 answers
Sort by: Most helpful
-
Olaf Helper 47,581 Reputation points2022-03-31T05:46:13.613+00:00 -
DSSH 61 Reputation points
2022-03-31T12:56:05.473+00:00 Thanks, a copy of the database will be moved to a test server no need for filestream data.
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(108.80000000000001, 46%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
AmeliaGu-MSFT 14,011 Reputation points Microsoft External Staff2022-04-01T08:24:31.08+00:00 Hi DSSH-8859,
You can try to choose the test server as your destination in the Import and Export Wizard to export data excluding filestream column.
Please check https://learn.microsoft.com/en-us/sql/integration-services/import-export-data/get-started-with-this-simple-example-of-the-import-and-export-wizard?view=sql-server-ver15 which might be helpful.Best Regards,
Amelia
Sign in to comment -
-
AmeliaGu-MSFT 14,011 Reputation points Microsoft External Staff
2022-03-31T06:43:55.27+00:00 Hi DSSH-8859,
As an alternative, you can try to right-click a database ->Tasks-> Export Data to use Import and Export Wizard to export data excluding filestream column.
In the Specify Table Copy or Query page, select “Write a query to specify the data to transfer” and do not include the filestream cloumn in the SQL statement.
Please check https://learn.microsoft.com/en-us/sql/integration-services/import-export-data/import-and-export-data-with-the-sql-server-import-and-export-wizard?view=sql-server-ver15 and https://learn.microsoft.com/en-us/sql/integration-services/import-export-data/specify-table-copy-or-query-sql-server-import-and-export-wizard?view=sql-server-ver15 which might be helpful.
Best Regards,
Amelia
If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".