← Tutti gli articoli
TSql script to create a database with filestream in Sql Server 2008
06 May 2011 ·
Sql Server 2008 · Recipe ·
311 visite
Recipes
CREATE DATABASE [MaragnaNet] ON PRIMARY
( NAME = N'MaragnaNet', FILENAME = N'c:\database\MaragnaNet.mdf' , SIZE = 3072KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB ),
FILEGROUP [MaragnaNetfg] CONTAINS FILESTREAM DEFAULT
( NAME = N'MaragnaNet_files', FILENAME = N'c:\database\MaragnaNet_files\MaragnaNet_files' )
LOG ON
( NAME = N'MaragnaNet_log', FILENAME = N'c:\database\MaragnaNet_log.ldf' , SIZE = 1024KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
GO
ALTER DATABASE [MaragnaNet] SET COMPATIBILITY_LEVEL = 100
GO
IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
begin
EXEC [MaragnaNet].[dbo].[sp_fulltext_database] @action = 'enable'
end
GO