Replicate a database - Please Help!!! 2

[josel]

I have an old HD with an old database I need to transfer to my new server. The old HD no longer boots (crashed).

I added old HD to new server and it comes up as drive E:

So, I have a database in e:\programs files\MS SQL\data

How do I bring that database to my newly installed server side and have it accessible through SQL Manager?

Thanks,


Jose Lerebours


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

 

[tran008]

Do you have backup tape that you can restore? You can only attach the database back if you detach it in the first place.

 

[SQLBI]

Hi Jose,

You need to attach your database from your new hard drive to SQL Server Management Studio (2005) or Enterprise Manager (2000).

If you right click the databases folder in SSMS, Attach and select the .mdf file of your database. Not sure of the option in 2000, not got it on this machine but sp_attach will work in either version, do a search in Books Online.

Cheers,
Leigh

"If you had one shot, one opportunity, to seize everything you ever wanted, in one moment, would you capture it, or let it slip?" - Eminem

 

[josel]

Thank you guys ... Attaching the database did it!




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