reg edit happy, mucked up a server...help!!

_Jimlad_ · 5 Nov 2007 at 11:19

Tried to install SQL 2005 on a windows 2000 server. It failed on install asking me to edit something in the reg. using regedt32.exe, I did this and then the whole line

([HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Perflib])

Turned to IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII ????????

To cut a long stort short, but backup notepad failed and now SQL 2005 wont get past the fist install button……

Can anything be done guys?

Dess_Aramea · 5 Nov 2007 at 11:33

hmm

Try reverting to a system restore point; luckily all the things you have changed will be reset.

Next time, always make a copy of the setting or key being changed, export the key to your desktop and execute it from there if things go pear shaped. I can only recommend a system restore :/

_Jimlad_ · 5 Nov 2007 at 11:35

Dess_Aramea said:
Try reverting to a system restore point; luckily all the things you have changed will be reset.

Next time, always make a copy of the setting or key being changed, export the key to your desktop and execute it from there if things go pear shaped. I can only recommend a system restore :/

windows 2000 no restore is there?

Burnsy2023 · 5 Nov 2007 at 11:43

Do you have any sort of registry backup? The only thing I can think of is to recreate all of the keys from another 2000 Server one by one.

Looking at my 2003 box, there are 5 keys in the perfib folder which are:

Base Index (REG_DWORD) 737 (hex)
ExtCounterTestLevel (REG_DWORD) 4 (hex)
Last Counter (REG_DWORD) 27ce (hex)
Last Help (REG_DWORD) 27cf (hex)
Version (REG_DWORD) 10001 (hex)

THat might work, but maybe someone with a 2000 box could verify?

Burnsy

_Jimlad_ · 5 Nov 2007 at 11:48

cheers chris, if you go in via regedt32.exe you get just two lines i think? can you check mate?

basmic · 5 Nov 2007 at 11:51

From my XP, if its any use:

Code:

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Perflib]
"Base Index"=dword:00000737
"ExtCounterTestLevel"=dword:00000004
"Last Counter"=dword:0000137a
"Last Help"=dword:0000137b
"Version"=dword:00010001

_Jimlad_ · 5 Nov 2007 at 12:12

cheers mate, i have found another 2k server i may be able to get the info from... i'm such a tool not taking the proper backup route, i thought i had it covered!

regedt32.exe seems to give diffirent results to normal regedit, but this maybe a 2k thing!

Burnsy2023 · 5 Nov 2007 at 13:09

I get the same results in regedit and regedt32 in Windows 2003

Burnsy

_Jimlad_ · 5 Nov 2007 at 16:04

must be a 2k thing!

ps you going to the redbridge xmas do mate?

Burnsy2023 · 5 Nov 2007 at 16:06

Crazy Fool said:
must be a 2k thing!

ps you going to the redbridge xmas do mate?

No mate, I'll be skiing

Burnsy

_Jimlad_ · 5 Nov 2007 at 16:21

Burnsy2023 said:
No mate, I'll be skiing

Burnsy

well that sounds like more fun mate! i will have a beer for you!