Excluding FILESTREAM when backing up a Database

When using a script to backup a SQL Server database, it can be tricky to exclude the filestream.
But, you can exclude filestream by only including the Primary file group, which typically only includes the data and log files.

BACKUP DATABASE MyDatabase
FILEGROUP = 'PRIMARY' 
TO DISK = 'C:\MyPath\MyDatabase.BAK' WITH INIT

I hope this helps.

Subscribe

0 comments