← Tutti gli articoli

TSql script to create a database with filestream in Sql Server 2008

06 maggio 2011  · Sql Server 2008 · Recipe  ·  317 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