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's avatar Anna DBA says:

    πŸ™‚ Agree. It is always databases’ fault! Thanks for the joke!

  2. Pamela Sprague's avatar Pamela Sprague says:

    🀣

  3. Kris's avatar Kris says:

    People who liked this might also like “Revenge: The SQL!” πŸ™‚

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

Leave a reply to Pamela Sprague Cancel reply

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 3,975 other subscribers

Follow me on Twitter

Archives

ToadWorld Pro of the Month November 2013