Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase ««12

SQL Server 2008 T-SQL Enhancements Part - IV Expand / Collapse
Posted Tuesday, March 30, 2010 8:30 PM


Group: General Forum Members
Last Login: Tuesday, December 24, 2013 4:42 AM
Points: 460, Visits: 2,523
When you restore a FILESTREAM enabled database, you can specify the location where the filestream data container(s) should be placed. Just like you specify the MDF and LDF file locations, you can also specify the location where the FILESTREAM file group(s) should be placed.

If you are restoring using SSMS wizard, by default SQL Server will show the same locations as in the original database and give you an option to change the locations.

Post #893449
Posted Tuesday, April 6, 2010 12:57 PM



Group: General Forum Members
Last Login: 2 days ago @ 4:21 PM
Points: 7,928, Visits: 9,653
Thanks for another good useful article.

Post #897826
Posted Thursday, April 22, 2010 1:43 PM


Group: General Forum Members
Last Login: Friday, August 8, 2014 1:02 PM
Points: 116, Visits: 207
My question is, is there any easy way to transfer existing files into a table that contains a filestream column?

We are currently using indexing services to do article searches - as the function is going away with Windows 2008 R2, we are looking to move the articles into a database to take advantage of the full text indexing of sql server.
Post #908960
Posted Thursday, November 4, 2010 1:54 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, November 4, 2010 5:45 AM
Points: 1, Visits: 3
Thanks for gr8 article.I have a question regarding the storage of data in filestream scenario.
If the file is gonna be saved on file system,why should the column type be varbinary.
how exactly this will stored.Please clarify..
Post #1015714
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse