Packages and compresses schema and contents of SQL Server databases
Moderators: JonathanWatts, Chris Auckland, David Atkinson, david connell, Anu Deshpande, Michelle Taylor, james.billings, Marianne
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?
- Posts: 1
- Joined: Mon Oct 29, 2012 6:15 am
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.
Red Gate Software
- Posts: 209
- Joined: Mon Apr 23, 2012 2:49 pm
Return to SQL Packager 6
Who is online
Users browsing this forum: No registered users and 0 guests