Solved

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

Posted on 2010-09-14
3
310 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
3 Comments
 
LVL 17

Assisted Solution

by:Chris Mangus
Chris Mangus earned 25 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 25 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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SQL Syntax 5 33
SQL Update trigger 5 16
Querying data from 3 SQL tables 2 30
Help Required 3 89
Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
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.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Via a live example, show how to shrink a transaction log file down to a reasonable size.

816 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

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now