SQL Server sp2 problem

[yogiberr]

Hi,

I have just installed the "SQL Server sp2" on my win 2000 machine.
I was running the "Enterprise" edition of the product.

Unfortunately, after the install, when I click on the "enterprise Manager" Icon, I now receive the following error:

“The instruction at “0x77a6c612” referenced memory at “0x00000000”.
The memory could not be read”

Another dialog box opened up, named:
“Just-In-Time Debugging”

it gave me the following message:

“An exception ‘Unhandled win32 Exception’ has occurred in mmc.exe”
I am desperate, please help.
Is there anything that I can do?
Cheers,
Yogiberr.

 

[tlbroadbent]

Looks like a windows problem or a corrupted installation. Have you tried rebiooting and possibly reinstalling the SQL client tools? Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm

If you want to get the best answer for your question read faq183-874.

 

[yogiberr]

Hi Terry,

Thanks for getting back to me.I would like to re-install client tools.Unfortunately, I have a USER database which I would like to keep.If I re-install the client tools, will this database be deleted? ( I have this file on a cd, it is called "dbTardis_Data"... a database file.) If i re-install the client tools, will I be able to keep/restore this file?

I must admit, it is pretty worrying.

Thanks very much,
yogiberr

 

[tlbroadbent]

Even if you reinstall SQL Server, your database will be intact. If you only reinstall the tools your DB will be intact. Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm

If you want to get the best answer for your question read faq183-874.

 

[SQLBill]

If you are uncomfortable with reinstalling, I suggest you detach the user database, then copy the user database's .mdf and .ldf file to another location (not backup just copy them). Then do your reinstall and attach the database. If the database can't be found, or is corrupt, just copy the .mdf and .ldf files back to their original location, then attach them.

But like Terry said, the reinstallation shouldn't do anything to your database.

-SQLBill

 

[yogiberr]

Thanks guys, I'll give that a try.I am fairly familiar with db stuff, such as creating tables , stored procs, etc.
However, would you know of any practical, compact tutorials that would deal with general db housekeeping & troubleshooting issues such as the one that I faced?

cheers,
yogi.
PS.I'll let you know how I got on!