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 Tuesday, February 26, 2013 8:08 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, December 10, 2014 12:07 PM
Points: 219, Visits: 727
The production database has 1 MDF and 1 log file.

The log file extension is idf instead of LDF. Would this cause issues?
Post #1424099
Posted Tuesday, February 26, 2013 8:58 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 12:05 AM
Points: 1,058, Visits: 2,697
i havent heard of it, is the database accessible for you?

can you check the extension again?


Regards
Durai Nagarajan
Post #1424126
Posted Tuesday, February 26, 2013 9:15 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: Yesterday @ 1:14 PM
Points: 40,615, Visits: 37,081
You could call the transaction log file readme.txt if you wanted. SQL doesn't care what the name or extension of the file is in any way.


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 #1424137
Posted Tuesday, February 26, 2013 9:49 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, December 10, 2014 12:07 PM
Points: 219, Visits: 727
Interesting. I did not realize that. I am still going to relocate if off the data drive tonight and move it over to a dedicated log drive.

Thanks again Gail!
Post #1424158
Posted Tuesday, February 26, 2013 3:00 PM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Sunday, November 9, 2014 7:56 PM
Points: 450, Visits: 1,343
Using MDF, NDF & LDF is really historical and convention more than anything else, it does however allow the files to be easily identified as database files. When you move the log file to the log drive you can rename the physical file, including the file extension(s) as shown below.
ALTER DATABASE MyDatabase 
SET OFFLINE;
GO

-- for mdf
ALTER DATABASE MyDatabase
MODIFY FILE (NAME='MyDatabase', FILENAME='H:\Data\MSSQL.3\MSSQL\Data\MyDatabase.mdf');
GO

-- for ldf
ALTER DATABASE MyDatabase
MODIFY FILE (NAME='MyDatabase_Log', FILENAME='H:\Data\MSSQL.3\MSSQL\Data\MyDatabase_log.ldf');
GO

-- Move and rename the physical files before the next step as appropriate

ALTER DATABASE MyDatabase
SET ONLINE;
GO

Cheers

Leo
Post #1424259
Posted Wednesday, February 27, 2013 5:15 AM


SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Wednesday, December 17, 2014 8:37 AM
Points: 621, Visits: 877
I can't help myself - I have to ask:

Maybe it could be a lower-case "L" ("l") instead of an Upper-case "I" ?


Regards, Mike
Post #1424470
Posted Wednesday, February 27, 2013 5:27 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 2:36 PM
Points: 6,759, Visits: 14,408
Vertigo44 (2/26/2013)
The production database has 1 MDF and 1 log file.

The log file extension is idf instead of LDF. Would this cause issues?

You just need to change the name in the SQL Server system catalogs and rename the OS file. Leo has detailed fully for you, you only need to complete the file rename and alter if you just want to rename the file. See my article at this link for more info.


GilaMonster (2/26/2013)
You could call the transaction log file readme.txt if you wanted

I bet someone, somewhere in the world has too


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

"Ya can't make an omelette without breaking just a few eggs"
Post #1424473
Posted Wednesday, February 27, 2013 6:47 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: Yesterday @ 1:14 PM
Points: 40,615, Visits: 37,081
Perry Whittle (2/27/2013)
GilaMonster (2/26/2013)
You could call the transaction log file readme.txt if you wanted

I bet someone, somewhere in the world has too


For the sake of playing around, I once created a DB where both the data and log files were alternate streams of a text file. Was silly, but it worked. CheckDB wouldn't run on it though.



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 #1424507
Posted Wednesday, March 27, 2013 3:10 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Thursday, December 18, 2014 11:28 AM
Points: 1,588, Visits: 1,653
As noted previously, SQL itself doesn't care.
What does sometimes care is antivirus (not to start a thread on good idea or not, just that some shops do run AV and should be aware of this).
They can ignore certain file types by extension (either out or the box or by configuration), and it wouldn't know that IDF is a special file to ignore. That file gets scanned and activity to that file gets scanned. It's a non-obvious performance hit.

I can't comment on all AV packages, but I've had some in the past that would have created a problem with IDF.
Post #1436183
Posted Wednesday, March 27, 2013 3:29 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, December 10, 2014 12:07 PM
Points: 219, Visits: 727
Tony++ (3/27/2013)
As noted previously, SQL itself doesn't care.
What does sometimes care is antivirus (not to start a thread on good idea or not, just that some shops do run AV and should be aware of this).
They can ignore certain file types by extension (either out or the box or by configuration), and it wouldn't know that IDF is a special file to ignore. That file gets scanned and activity to that file gets scanned. It's a non-obvious performance hit.

I can't comment on all AV packages, but I've had some in the past that would have created a problem with IDF.


This is a good point. That file extension wouldnt be on the exclusions list.
Post #1436192
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse