Creating a filestream database using Sql packager 6

learner Prog

Hi,
I'm trying to restore a filestream enable database and get the following error:
Default FILESTREAM filegroup is not available in database 'TestDB'

I used sql packager to create a C# project. the original database was filestream enabled and had a table with a filstream data column.

the inner exception shows the create table script:
CREATE TABLE [dbo].[FileStreamDataStorage]
(
[ID] [int] NOT NULL IDENTITY(1, 1),
[FileStreamData] [varbinary] (max) FILESTREAM NULL,
[FileStreamDataGUID] [uniqueidentifier] NOT NULL ROWGUIDCOL CONSTRAINT [DF__FileStrea__FileS__014935CB] DEFAULT (newsequentialid()),
[DateTime] [datetime] NULL CONSTRAINT [DF__FileStrea__DateT__023D5A04] DEFAULT (getdate())
CONSTRAINT [UQ__FileStre__FB6FAD9C7F60ED59] UNIQUE NONCLUSTERED ([FileStreamDataGUID])
)

I think the problem is the new databse is not filestream enabled and when it tries to create a table with filestream column it is erroring.

can anyone please help?

Manfred.Castro

Before you can start to use FILESTREAM, you must enable FILESTREAM on the instance of the SQL Server Database Engine. This topic describes how to enable FILESTREAM by using SQL Server Configuration Manager.
http://msdn.microsoft.com/en-us/library/cc645923