← 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
Si è verificato un errore imprevisto. Ricarica

Rejoining the server...

Rejoin failed... trying again in seconds.

Failed to rejoin.
Please retry or reload the page.

The session has been paused by the server.

Failed to resume the session.
Please retry or reload the page.