InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 18 May 2013 18:54:38 GMT20http://www.sqlservercentral.com/Forums/Topic1432371-1550-1.aspxRead more on filestreamhttp://www.sqlskills.com/blogs/paul/category/filestream/ Tue, 19 Mar 2013 06:14:28 GMTsankar276http://www.sqlservercentral.com/Forums/Topic1432371-1550-1.aspxAFAIK, this works the same as it does for filegroups without Filestream.You can see some backup and restore here: [url]http://www.mssqltips.com/sqlservertip/1854/how-to-backup-and-restore-a-sql-server-filestream-enabled-database/[/url]I haven't tested a filegroup restore, but you should be able to do this, but it would follow the rules for filegroup restores: [url]http://support.microsoft.com/kb/281122[/url]Mon, 18 Mar 2013 18:23:01 GMTSteve Jones - SSC Editorhttp://www.sqlservercentral.com/Forums/Topic1432371-1550-1.aspxWe're using MS SQLServer 2008 R2 and we are exploring the possibility of using FILESTREAM to store in a separate filegroup our documents and images, mostly PDFs. I have read a few articles on filestream and I'm running a few small tests to convert our existing data. It seems to work pretty good. My question is in regards to backing up and restoring the data and also I'd to make some clarifications. Is there a good article in regards to backing up and restoring filestreams? Can a backup/restore be done independently for each filegroup? For example, if a user deletes some data from the filestream filegroup, can I restored that portion of the database only? I'm running some tests on my development machine and I'm running into some error messages. I'm getting errors where it leaves the DB in restoring mode.Mon, 18 Mar 2013 15:57:04 GMTHildaJ