This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](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)
New to this but can I take an export/copy of a database but NOT export/copy the filestream data? If so, how?
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?
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)
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
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".