Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

hi i am a beginner with sql server 2008, i was trying to add a file to a filegroup so that i an create a table which uses filestream, but i keep getting an errors.

here is the code that i am trying:

ALTER DATABASE dbtry1

ADD FILEGROUP dbtry1_fg_filestream CONTAINS FILESTREAM

GO

ALTER DATABASE dbtry1

ADD FILE

(

NAME= 'dbtry1_filestream',

FILENAME = 'E:\Projects\fs.ndf'

)

TO FILEGROUP dbtry1_fg_filestream

GO

the errors:

Msg 5134, Level 16, State 2, Line 1

The path that is specified by 'E:\Projects\fs.ndf' cannot be used for FILESTREAM files because it is not on a supported file system.

Msg 5009, Level 16, State 14, Line 1

One or more files listed in the statement could not be found or could not be initialized.

Please help!

share|improve this question
add comment

1 Answer

FILESTREAMs require NTFS. Is your e: drive FAT?

See http://technet.microsoft.com/library/bb933993 and note the second paragraph (emphasis added):

FILESTREAM integrates the SQL Server Database Engine with an NTFS file system by storing varbinary(max) binary large object

share|improve this answer
    
yes, my E: drive is FAT32! can i not use FAT32 drives at all? –  Sneha Aug 25 '09 at 13:54
    
See the first sentence of my reply. –  Richard Aug 25 '09 at 19:12
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.