A DBA horror story in database file extensions.

4

September 30, 2021 by Kenneth Fisher

CREATE DATABASE [Story]
 ON  PRIMARY 
( NAME = N'Story', FILENAME = N'C:\Data\Story.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:\Data\Story_log.ldf', SIZE = 111MB);
GO

4 thoughts on “A DBA horror story in database file extensions.

  1. Anna DBA says:

    🙂 Agree. It is always databases’ fault! Thanks for the joke!

  2. Pamela Sprague says:

    🤣

  3. Kris says:

    People who liked this might also like “Revenge: The SQL!” 🙂

    https://sqlbits.com/Sessions/Event12/Revenge_The_SQL

Leave a comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 6,758 other subscribers

Follow me on Twitter

Archives

ToadWorld Pro of the Month November 2013