1. Create database with a FILESTREAM filegroup
USE [master] GO –create database with Filestream CREATE DATABASE [FileStreamTest] CONTAINMENT = NONE ON PRIMARY ( NAME = N’FileStreamTest’, FILENAME = N’C:Program FilesMicrosoft SQL ServerMSSQL15.MSSQLSERVERMSSQLDATAFileStreamTest.mdf’ , SIZE = 204800KB , MAXSIZE = UNLIMITED, FILEGROWTH = 65536KB ), FILEGROUP [FileStreamFG] CONTAINS FILESTREAM DEFAULT ( NAME = N’FileStreamTestFStream’, FILENAME = N’C:Program FilesMicrosoft SQL ServerMSSQL15.MSSQLSERVERMSSQLDATAFileStreamTestFStream’ , MAXSIZE = UNLIMITED) LOG ON ( NAME = N’FileStreamTest_log’, FILENAME = N’C:Program FilesMicrosoft SQL ServerMSSQL15.MSSQLSERVERMSSQLDATAFileStreamTest_log.ldf’ , SIZE = 270336KB , MAXSIZE = 2048GB , FILEGROWTH = 65536KB ) WITH CATALOG_COLLATION = DATABASE_DEFAULT GO
2.