Solved

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

Posted on 2010-09-14
3
314 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 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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

I have a large data set and a SSIS package. How can I load this file in multi threading?
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

696 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