Hemant.R (3/29/2013)
As mention ,log file extension idf .Database is accessible but in case of attach detach process it might create problem .
It won't create any problems at any time. The ldf extension is a convention, nothing more. As far as SQL's concerned, the extension of the log file is irrelevant (it knows by checking the first section of the file whether a particular file is a log file or not)
This works fine, though is obviously silly. The only problems it'll cause is with the admins. Not recommended, but that's because people expect to see the common extensions used the normal way, not because of any problems it'll cause with SQL
CREATE DATABASE Weird ON PRIMARY
( NAME = N'Weird', FILENAME = N'D:\Develop\Databases\Weird.xlsx' , SIZE = 3072KB , FILEGROWTH = 1024KB )
LOG ON
( NAME = N'Weird_log', FILENAME = N'D:\Develop\Databases\Weird_log.txt' , SIZE = 1024KB , FILEGROWTH = 1024KB)
GO
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability