My computer is gone, but not the files. how to reinstall MSSQL 2000 with all the data

[dordort]

Hello. i got a problem in my windows with blue screens and in safe mode too, so i cant do anything. i tryed to startup with ERD Commander and i saw all my files its ok. =] but windows dont work. i tryed to fix the windows boot, so i burn a recovery console bootable iso and i started it up. first i did "chkdsk" and /r and all this but it dont want to up its wrote something like "System found that the hard disk got much problems that unrecoverable." i know its not this but i dont remember how it was :S so it write this and dont want start the check, i saw 2 commands that can help to fix things. first i tryed this one "fixboot" and then when i restart the system i got "NTLDR is missing" message. and then i tryed "fixmbr" command, and then all my HD is gone :S "Incorrect Partition table" message. :X and then i try again to boot ERD Commander and it dont found any Windows installed. all gone!! then, i boot with MiniPE, and start the software "GetDataBack for NTFS" scan. after 1.5Hours, it found all my files but my friend warring me that if i recover it to the same Hard disk (I got only one...) so all will gone!!!! so i fastly close it, and tommorow i will buy another Hardisk for recover my files in there. if anyone got another ideas so please please help me!

Now the question, because i cant recover the windows and i can only recover all my files i need help. when i format and install a new windows xp, so then i can copy back the files into my Hard disk. but, how i can reput all the MSSQL DATA in the new clean installed MSSQL? i will own only the files and directories but not the configurations in windows. the same i need to know with the VMWARE Virtual CentOS. i really need this help, sorry for my annoying english, and thanks a l-o-t!!!!!!!

Dor Turok.

Edit: I just saw now that VMware its not the problem, because in the setup it ask if create new hard disk or use exiting one. =] but my problem its with the SQL 2000, i must restore the data into it because all the members just all in there! :S

Edit:

I found this thing! thats all what i need to do?

All you have to do import MDF/LDF files is:

1) Copy the files to you hard disk on the Server that hosting SQL Server
2) Open Enterprise Manager.
3) Right click on Databases, choose All Tasks, Attach Database
4) Type in the path to your MDF file (or use the ... button to browse. I should find the LDF file too if it's in the same location.
5) Give the database a name (where its says 'Attach as'.
6) Click on OK.

.

And i got triggers and jobs of auto reset, how to import this too? :S please just a little explain..

 

[phiber]

please edit, and set up a font more small -.-

my eyees.

 

[dordort]

please edit, and set up a font more small -.-

my eyees.

You dont got anything smart to say? =\ chumpy sir i need you =P

 

[phiber]

you dont see anyting smat in my ask, a little respect for the people who read this?.

if you want some one help you, first try make feal that people happy to help you, and write with this font, etc dont help.


its that enough smart for you?

now ontopic, if you have the mdf or some backup you can re-atach the dbs.
If not, your sql its f****d.

for vmware the same. Vmware store the system files in 2 realy big .something, try find it.


bye.

 

[dordort]

you dont see anyting smat in my ask, a little respect for the people who read this?.

if you want some one help you, first try make feal that people happy to help you, and write with this font, etc dont help.


its that enough smart for you?

now ontopic, if you have the mdf or some backup you can re-atach the dbs.
If not, your sql its fucked.

for vmware the same. Vmware store the system files in 2 realy big .something, try find it.


bye.

Listen, i said that i have allthe files ok? all the files in my computer include the SQL 2000 directory with files its saved. but i gonna install new clean windows xp so i dont know how to reput/attach or whatever to make it work with the old configurations and Data. must get help :S someone can post any link to guide or something? ty.. =\ because i never was in that situation.

Edit:

I found this thing! thats all what i need to do?

All you have to do import MDF/LDF files is:

1) Copy the files to you hard disk on the Server that hosting SQL Server
2) Open Enterprise Manager.
3) Right click on Databases, choose All Tasks, Attach Database
4) Type in the path to your MDF file (or use the ... button to browse. I should find the LDF file too if it's in the same location.
5) Give the database a name (where its says 'Attach as'.
6) Click on OK.

.

And i got triggers and jobs of auto reset, how to import this too? :S please just a little explain..

 

[chumpywumpy]

The actual server files don't really matter as you can just recreate them from the files here. As long as you have the mdf/ldf database files from the sql server then your databases are safe. All of the triggers and the auto reset system are all stored in the mdf so once you have reinstalled windows just attach the databases like you posted above and you will have your exact databases back. Then just reinstall centos and copy the server files to it, edit for the db etc and you are all set.

That font is a bit big

 

[dordort]

The actual server files don't really matter as you can just recreate them from the files here. As long as you have the mdf/ldf database files from the sql server then your databases are safe. All of the triggers and the auto reset system are all stored in the mdf so once you have reinstalled windows just attach the databases like you posted above and you will have your exact databases back. Then just reinstall centos and copy the server files to it, edit for the db etc and you are all set.

That font is a bit big

Ok, big thanks for replying. =]
But i must recreate the CentOS? because as i said, i got the Hard disk file of the virtual machine, so i cant just use it and import it on vmware? because in the "create new virtual machine" in vmware i saw that in the setup theres a option to use exiting Hard disk file. so i can use this option with the file of my virtual centos? :S dont forget that i have a many changes in my configs, and i worked a lot on this thing.. =/

Thanks again.

Edit:

Nevermind, i checked it and my CentOS data saved. the only thing i need its the hard disk file (vmdk) and i just create a new virtual machine and import this file in there, and all back to normal. Thanks for help.