|
|||||||||
|
|||||||||
|
|||||||||
 |
|||||||||
| |
||
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
ASP Free Forums Sponsor:
|
|
|
|
#1
November 18th, 2004, 05:00 AM
|
|||
|
|||
Finding database name from MDF and LDF file name
I am currently doing a clear up of our SQL server at my company and have come across what seems to be a rogue MDF and LDF file. The name of these files does not seem to match the names of any of the databases showing in Enterprise Manager. I want to find out what database these MDF and LDF files are attached to. There are around 90 databases on our SQL server and it's gonna take me ages going through them all one by one looking at the properties to find these files.
Does anyone know if there is a quick stored procedure I can use to achieve this? Many Thanks Steve
|
|
#2
November 18th, 2004, 01:16 PM
|
|||
|
|||
|
Probably a database was detached from your server. The db name should be the file name. Move the files to a testing server and reattach them, then take a look at whatever is inside.
__________________
====== Doug G ====== I didn't attend the funeral, but I sent a nice letter saying I approved of it. --Mark Twain
|
|
#3
November 19th, 2004, 04:58 AM
|
|||
|
|||
|
Thanks for that. I wasn't interested in what was in the database. I just wanted a quick way of finding out what database it is attached to, as the filename doesn't match any of the databases showing in Enterprise Manager, which I found a bit strange.
Thanks Steve
|
|
| Viewing: ASP Free Forums > Database > Microsoft SQL Server > Finding database |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
|
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
