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[/url] 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" 😉