Detached DB in Temp folder

Question

Detached DB in Temp folder

Vertigo44

SSCarpal Tunnel

Points: 4055
More actions
May 24, 2011 at 6:32 am

#238071

I am looking to free up some drive space and ran across a large MDF and LDF file located in PF\MSS\MSSQL\DATA\TEMP on the server drive. I do not see this particular database as being attached to the instance however it looks like it has recent backups in the Backups folder. Any ideas how this is possible?

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Lowell SSC Guru Points: 323518 More actions · Answer 1

do you have an additional instance of SQL on that server? maybe the isntance is using that mdf and not the default instance?

if you

select * from master.sys.sysaltfiles

do you see that mdf file name?

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

M&M SSC-Insane Points: 21700 More actions · Answer 2

How recent are the backups?

Were you able to check the maintenance plans or any backup job etc?

M&M

Vertigo44 SSCarpal Tunnel Points: 4055 More actions · Answer 3

I feel embarrassed now... It has another instance that I was not aware of.

Thanks guys!

Lowell (5/24/2011)
do you have an additional instance of SQL on that server? maybe the isntance is using that mdf and not the default instance?
if you
select * from master.sys.sysaltfiles
do you see that mdf file name?

muthukkumaran Kaliyamoorthy SSCoach Points: 19026 More actions · Answer 4

Check the Backupset and backupmediafamily tables in msdb.

You will get the recent backups.

Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/