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.