What causes SQL MDF and LDF files to have hexadecimal notation in the filename
Posted on 2010-09-14
I support an application that uses Microsoft SQL 2000/2005/2008 databases that are typically named "Attendance" but sometimes are named something else. A customer's name, an abbrevation, or some other reasonably normal name.
The database filenames are typically Attendance.mdf and Attendance_log.ldf.
From time to time, I will see database filenames like Attendance_0xC49EEE467551E04181C1864FE9987BCE.mdf
Sometimes they are quite large, and sometimes, but not always, they are the actual database files as indicated in the "Files" page of the database properties using Microsoft SQL Server Management Studio. Other times, they are not listed as database file in the properties of the database, but as far as I can tell, only exist on the filesystem. Sometimes, I will see both the normally-named files and these hexadecimal files coexisting.
My question is this: What could cause these strange hexadecimal file names?