SQL SERVER – Can Database Primary File Have Any Other Extention Than MDF

I just opened Pinal’s blog to check the updated articles and happened to read this. This option got my interest to test. Downloaded SQL 2014 Express edition and tested it. It was working fine and interesting for me.

But I am not sure how it helps. We cannot format our DB in to PDF and attach so obviously the DB is not useful.

Install Express edition using below link and test:

http://www.hanselman.com/blog/DownloadSqlServerExpress.aspx

Use below script to create the DB.

USE [master]
GO
CREATE DATABASE [tests] ON
( FILENAME = N'D:\data\tests.pdf' ),
( FILENAME = N'D:\data\tests_log.ldf' )
FOR ATTACH
GO

My DB Screen:

 

 

 

 

 

 

 

Pinal has given DB files in the below link

http://www.pinaldave.com/bimg/data.zip

References:

http://blog.sqlauthority.com/2014/12/14/sql-server-can-database-primary-file-have-any-other-extention-than-mdf/#comment-1573847