/
Prepare to work with FILESTREAM data in MS-SQL

Prepare to work with FILESTREAM data in MS-SQL

Owned by Michael Litner
May 14, 2025

General

A customer database may include FILESTREAM data. This data will be transferred to GI and VDB automatically.

Configuration

On both source and target servers perform:

  1. Open SQL server configuration manager → SQL Server services

  2. Select SQL server with needed instance name

    image-20250509-145123.png

  3. Right click → properties → FILESTREAM

  4. Check all checkboxes

    image-20250509-145219.png

  5. Run SQL Management studio and connect to the needed server

    image-20250509-145340.png

  6. Run :
    EXEC sp_configure filestream_access_level, 2;
    RECONFIGURE;

Remember to do it for both source and target servers!