Where is configuration info stored?

[josel]

Howdy!

My server crashed and was forced to setup new server (Windows). I have successfully installed OS (W2K3) and CFMX in new server. I also installed MS-SQL Server.

Now, my problem is getting my SQL database back to new server (no backup ... shame on me ... ). It has been such a long time since I last looked at these things that I do not remember where I put the database itself. I have searched high and low and cannot find it (while I could not boot off of old HD, I managed to installed it as a physical drive).

I figure that if I can read the CFMX configuration file, read how the data source was configured, I can then figure out where is my database.

The truth is that I do not even remember the name of the database itself, I just might be looking at it and not know it.

Thank you all in advance for your help!

Regards,


Jose Lerebours


KNOWLEDGE: Something you can give away endlessly and gain more of it in the process! - Jose Lerebours

 

[Sarky78]

Jose

CFMX comes with an admin api that you can access and run. Now I assume from the above message that you can still access the other hard drive, so this might work for you:

<cfobject component="cfide.administrator.components.administrator" name="admin">
<cfset admin.login("MY_SECRET_ADMIN_PSWD")>
<cfobject component="cfide.administrator.components.datasource" name="ds">
<cfdump var="#ds.getdatasource()#">
<cfset admin.loginout()>

you might need to create a mapping for the component to the other hard drive, but it should work

Hope this helps!

Tony

 

[ecobb]

If all you need is the SQL Server database, and you have access to the hard drive it's on, then it should be just a matter of looking in the right directory. By default, SQL Server creates a database in 'C:\Program Files\Microsoft SQL Server\MSSQL\Data'. Unless you changed the directory when you created the database, it should be there on the hard drive. The database will have a .MDF extension, and the log file will have a .LDF extension.


Hope This Helps!

ECAR
ECAR Technologies

http://www.ecartech.com

"My work is a game, a very serious game." - M.C. Escher

 

[josel]

Sarky78 - I'll give that a try.

ECAR - I did that already, but as I said, I don't even remember the name of the database itself. Hey, I am over 40 and I have not looked at these things for months.

Thanks,


Jose Lerebours


KNOWLEDGE: Something you can give away endlessly and gain more of it in the process! - Jose Lerebours

 

[philhege]

If your install took the default location, just look for any .MDF file excepting master, model, tempdb, and msdb. You should be able to sort it out from there.

Phil Hegedusich
Senior Programmer/Analyst
IIMAK

http://www.iimak.com

-----------
Pity the insomniac dyslexic agnostic. He stays up all night, wondering if there really is a dog.