11

1.) How can I backup my FILESTREAM database on SQL Server 2008 from SQL Server Management Studio?
2.) Do I have to make a separate backup of the FILESTREAM folder on disc?

Breeze
  • 2,010
  • 2
  • 32
  • 43
Zo Has
  • 12,599
  • 22
  • 87
  • 149

1 Answers1

15

1.) You can backup the filestream data using the normal SQL Backup & Recovery process. See this article for reference. You can also exclude filestream data explicitly from your backup should you want to.

2.) You can take a separate backup of the filestream directory, but you really don't need to. It only makes sense to the SQL Server DB instance that created it.

SliverNinja - MSFT
  • 31,051
  • 11
  • 110
  • 173
  • 1
    Thanks for the detailed reply SilverNinja. I followed what you advice & end up with a single backup file.Does that contain my filestream data as well ? I was following this article previously http://www.mssqltips.com/sqlservertip/1854/how-to-backup-and-restore-a-sql-server-filestream-enabled-database/ – Zo Has Nov 10 '11 at 09:46