What causes SQL MDF and LDF files to have hexadecimal notation in the filename

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?

cbi1972Asked:
Who is Participating?
 
lundnakConnect With a Mentor Commented:
I agree that is likely the application that is creating these database files.  SQLServer does not add files unless it is told to.
0
 
Chris MangusConnect With a Mentor Database AdministratorCommented:
I've never seen such a thing.  I would suspect that either your application is creating them or you have a third party backup client that is causing it.
0
 
cbi1972Author Commented:
I believe it is the application doing the unusual behavior.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.