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

5 (1)

Share

Share

Rate

5 (1)