March 18, 2013 at 3:57 pm
We'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.
March 18, 2013 at 6:23 pm
AFAIK, this works the same as it does for filegroups without Filestream.
You can see some backup and restore here: http://www.mssqltips.com/sqlservertip/1854/how-to-backup-and-restore-a-sql-server-filestream-enabled-database/
I haven't tested a filegroup restore, but you should be able to do this, but it would follow the rules for filegroup restores: http://support.microsoft.com/kb/281122
March 19, 2013 at 6:14 am
Read more on filestream
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply