Creating a filestream database using Sql packager 6

Forum for users of SQL Packager database archive utility

Creating a filestream database using Sql packager 6

Postby learner Prog » Mon Oct 29, 2012 6:32 am

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())

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?
learner Prog
Posts: 1
Joined: Mon Oct 29, 2012 6:15 am

Postby Manfred.Castro » Tue Oct 30, 2012 5:16 pm

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.
Manfred Castro
Product Support
Red Gate Software
Posts: 209
Joined: Mon Apr 23, 2012 2:49 pm

Return to SQL Packager Previous Versions

Who is online

Users browsing this forum: No registered users and 1 guest