Click here to Skip to main content
14,384,396 members
Rate this:
Please Sign up or sign in to vote.

We are storing blob data in my data base.As part of new requirements,we planned to archive the blob data if it is more than 3 years from current day.We are currently using SQL server 2012.So after some google,we decided to use file stream concept for this mechanism instead of normal file system .We succeeded in this process but client wants to store the recent data (less than 3 yrs) with in DB server and more than 3 yrs data will be moved to one new server and pointing the address of blob in the table.

After googling,we found that in SQL server 2012 ,we can use multiple filestream file groups pointing to different servers for a database.But we were stuck in how to store recent data in one filestream filegroup and archive data in other filestream filegroup?

Could you please suggest weather it is possible or not. And please suggest any other way to do this?

Thanks in Advance

What I have tried:

Created one new database with multiple filestream file groups and tried to insert the data into table.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100