Export/Copy database without filestream data

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
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
11,565 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Olaf Helper 36,001 Reputation points

    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?

  2. AmeliaGu-MSFT 13,936 Reputation points Microsoft Vendor

    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,

    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".

    0 comments No comments