How to recover sql server database data

[shobert]

Hi all. A few days ago i installed mcafee total protection 2007 and that disabled my internet connection totally!! I couldn't fix it so i had to uninstall it. After uninstalling mcafee total protection 2007 still i couldn't join Internet!!

So i got mad and went and made repair installation of windows xp pro. After repair installation i couldn't activate it since Internet connection was still not working!! So i went and installed another copy of xp pro on different folder and named it WINDOWS (old one was WINDOWS2).Thanks god now i could join Internet but all my shortcuts and menu items are not visible.

Unfortunately I can't even start sql server 2000 either!! could any one tell me what should i do in order to get access to all database tables and data that i had in sql server and make a back up. I didn't install any new sql server yet. I be happy if an expert tell me what should i do. The installation folder of old windows(WINDOWS2) is still available along with sql server installation folder.Thank and looking forward for reply.

 

[ptheriault]

I would suggest that you re-install SQL. I take it that this is just your development database?

- Paul
- If at first you don't succeed, find out if the loser gets anything.

 

[shobert]

ptheriault thank for your reply. do you mean should i install sql server 2000 in the same folder ? do you think this way i can still get my data and database structure back? there were a few database that my asp applications had to access it and i need them.

 

[ptheriault]

yes I would reinstall to the same folders. I believe when you re-installed XP you overwrote you registry. I would rename you current data folder to data2. It will create a new data folder. Then copy your databases into the data folder and attach them.

- Paul
- If at first you don't succeed, find out if the loser gets anything.

 

[shobert]

ptrheriault could you tell me how to attach them . I need to know the steps before doing it.Thanks

 

[ptheriault]

From a query window you use sp_attach_db. You can look up that command in BOL.

- Paul
- If at first you don't succeed, find out if the loser gets anything.

 

[shobert]

is there away to get database structure too so i don't have to create dbs manually from scratch?

 

[SQLBill]

When you re-install SQL Server it will create new system databases (master, model, msdb,tempdb). Your user databases still exist as .mdf and .ldf files. Once SQL Server is re-installed, all you have to do is attach the user databases using the command Paul provided. As he said, look up the exact syntax in the BOL.

-SQLBill

Posting advice: FAQ481-4875