?
Solved

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

Posted on 2010-09-14
3
Medium Priority
?
315 Views
Last Modified: 2012-05-10
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?

0
Comment
Question by:cbi1972
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 17

Assisted Solution

by:Chris Mangus
Chris Mangus earned 100 total points
ID: 33677446
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
 
LVL 7

Accepted Solution

by:
lundnak earned 100 total points
ID: 33686355
I agree that is likely the application that is creating these database files.  SQLServer does not add files unless it is told to.
0
 

Author Closing Comment

by:cbi1972
ID: 33807970
I believe it is the application doing the unusual behavior.
0

Featured Post

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Suggested Courses

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question