Blog Post

A DBA horror story in database file extensions.

,

CREATE DATABASE [Story]
 ON  PRIMARY 
( NAME = N'Story', FILENAME = N'C:DataStory.mdf',SIZE = 101MB), 
 FILEGROUP [Line1] 
( NAME = N'File1', FILENAME = N'C:Data_.It',SIZE = 102MB),
( NAME = N'File2', FILENAME = N'C:Data_.was',SIZE = 103MB),
( NAME = N'File3', FILENAME = N'C:Data_.actually',SIZE = 104MB),
( NAME = N'File4', FILENAME = N'C:Data_.the',SIZE = 105MB), 
( NAME = N'File5', FILENAME = N'C:Data_.databases',SIZE = 106MB), 
( NAME = N'File6', FILENAME = N'C:Data_.fault',SIZE = 107MB), 
( NAME = N'File7', FILENAME = N'C:Data_.!',SIZE = 108MB), 
 FILEGROUP [Line2] 
( NAME = N'File8', FILENAME = N'C:Data__.The',SIZE = 109MB),
( NAME = N'File9', FILENAME = N'C:Data__.End',SIZE = 110MB)
 LOG ON 
( NAME = N'Story_log', FILENAME = N'C:DataStory_log.ldf', SIZE = 111MB);
GO

Original post (opens in new tab)
View comments in original post (opens in new tab)

Rate

(1)

You rated this post out of 5. Change rating

Share

Share

Rate

(1)

You rated this post out of 5. Change rating