Tag Archives: MS SQL 2012

MS SQL 2012 FileTable with new DB instance

Here’s a simple example which helps setup the new FileTable feature in a new database. EXEC sp_configure filestream_access_level, 2 RECONFIGURE GO — Create Database CREATE DATABASE FileTableDB ON PRIMARY (Name = FileTableDB, FILENAME = ‘D:\FileTable\FTDB.mdf’), FILEGROUP FTFG CONTAINS FILESTREAM (NAME = FileTableFS, FILENAME=’D:\FileTable\FS’) LOG ON (Name = FileTableDBLog, FILENAME = ‘D:\FileTable\FTDBLog.ldf’) WITH FILESTREAM (NON_TRANSACTED_ACCESS = […]

MS SQL 2012 FileTable for Existing Instance

In order to use FileTables, the following four steps must be completed, in order: 1. Enable FileStream at the instance Level 2. Provide a FileStream Filegroup 3. Enable Non-Transactional access and specify FileTable directory at the Database Level 4. Create a FileTable ALTER DATABASE ADD FILEGROUP CONTAINS FILESTREAM GO — D:FileTableContainedTestDb must exist ALTER DATABASE […]

MS SQL 2012 contained database

A cool feature in MS SQL 2012 http://blogs.msdn.com/b/mvpawardprogram/archive/2012/07/16/contained-databases-in-sql-server-2012.aspx http://msdn.microsoft.com/en-us/library/ff929055.aspx http://msdn.microsoft.com/en-us/library/ff929071.aspx Configure your SQL in Mgmt studio: The primary purpose of contained databases is to make it easier to port your database to a new server without a lot of scaffolding around it. With that in mind, I’ll treat a few potential issues that will make […]