SQL Server 2008 T-SQL Enhancements Part

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Arshad Ali » SQL Server 2008 T-SQL Enhancements Part - IV

14 posts, Page 2 of 2

««1 2

SQL Server 2008 T-SQL Enhancements Part - IV

Rate Topic

Display Mode

Topic Options

Author

Message

jacob sebastian

Posted Tuesday, March 30, 2010 8:30 PM

SSC-Addicted

Group: General Forum Members
Last Login: Saturday, May 11, 2013 8:17 AM
Points: 460, Visits: 2,521

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

L' Eomot Inversé

Posted Tuesday, April 06, 2010 12:57 PM

SSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 5:11 PM
Points: 7,104, Visits: 7,168

Thanks for another good useful article.

Tom
Que conclure à la fin de tous mes longs propos? C'est que les préjugés sont la raison des sots. (Voltaire, 1756)

Post #897826

Michelle-138172

Posted Thursday, April 22, 2010 1:43 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, May 03, 2013 1:32 PM
Points: 106, Visits: 173

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

pagolu.satheeshp

Posted Thursday, November 04, 2010 1:54 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, November 04, 2010 5:45 AM
Points: 1, Visits: 3

Hi,
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 »

14 posts, Page 2 of 2

««1 2

Permissions