Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

LDF is IDF instead Expand / Collapse
Author
Message
Posted Wednesday, March 27, 2013 3:40 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 7:35 AM
Points: 6,304, Visits: 13,599
Just about all AV programs can be customised. If you did have a file with .idf extension just add it to the exclusion list

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1436200
Posted Friday, March 29, 2013 3:54 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, March 3, 2014 4:05 AM
Points: 47, Visits: 236
As mention ,log file extension idf .Database is accessible but in case of attach detach process it might create problem .

Regards,

HEMANT
Post #1436857
Posted Friday, March 29, 2013 5:13 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 7:53 AM
Points: 42,822, Visits: 35,952
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 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1436872
Posted Friday, March 29, 2013 8:56 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 7:35 AM
Points: 6,304, Visits: 13,599
The only problem the attach will cause is the part where you open the file browser to locate the log file. The file browser will search for *.mdf and *.ldf so you'll need to change this to all files.
Apart from that, it makes no difference at all.


-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1436966
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse