CODEWITHSUNDEEP
c#sqlbackupsmodatabase-restore
Muhammad Al-Own
Muhammad Al-Own

Reputation: 237

How To Backup And Restore DataBase With FILE STREAM Using SMO in C#

How can i backup and restore a database with file stream Using SMO in C#. i found some attributes in Server Class in SMO Like "FilestreamLevel" and "FilestreamShareName" but i do not know how to use them.

please help and thanks for all

Upvotes: 7

Views: 2827

Answers (2)

Damien_The_Unbeliever
Damien_The_Unbeliever

Reputation: 239824

There's nothing special you need to do to backup a database that is using FILESTREAM:

Because FILESTREAM is implemented as a varbinary(max) column and integrated directly into the Database Engine, most SQL Server management tools and functions work without modification for FILESTREAM data. For example, you can use all backup and recovery models with FILESTREAM data, and the FILESTREAM data is backed up with the structured data in the database

and as the next statement points out, you actually have to do more to exclude filestream data from the backup:

If you do not want to back up FILESTREAM data with relational data, you can use a partial backup to exclude FILESTREAM filegroups.

Upvotes: 2

Sai Kalyan Kumar Akshinthala
Sai Kalyan Kumar Akshinthala

Reputation: 11844

You refer to this site, which will give you some basic idea to do Database Backup and Restore with SMO

Upvotes: 0

Related Questions