ishultz


Hello,

I've got a weird problem that started today on our SQL server at work. Apparently the transaction logs filled up for one DB, and SQL server decided to create 230 gb of errors on the subject, filling my D: drive. Well, I had no problem deleting the error logs and truncating the transaction logs, but my Enterprise Manager MMC will no longer function.

Search results turned up a fix that worked for most people, but not for me. So I'm pretty sure I've got no choice but to reinstall over-the-top. But, will this cause any loss of existing databases (obviously back them up first), users/security, and scheduled tasks (db backups, etc)

I'd like to do minimal damage to this thing because there are several DB's set up from before my time, and I don't have time to manage this thing completely (as you might have guessed, no one really manages things here). Any help is appreciated.



Re: Reinstalling MSSQL Server 2000 Over-the-top?

Deepak Rangarajan


Just stop the sql services and take a backup oif all the ldf and mdf files to another location and try to run the client tools alone and see if it works ! else if you uninstall sql server and reinstall it you can then attach all the dbs without any problem...

- Deepak







Re: Reinstalling MSSQL Server 2000 Over-the-top?

ishultz

And the users/jobs Are they contained within the database, or will they be cleared after reinstalling




Re: Reinstalling MSSQL Server 2000 Over-the-top?

Deepak Rangarajan

Pls follow the below steps,

  • Stop the sql services
  • Copy the ldf and mdf files to a safe location
  • Uninstall sql server and reinstall the same edition
  • Attach the databases (once you attach the msdb all the jobs will be present in it and logins will be present in master db after you attach it)

If you have anymore questions feel free to ask Smile

- Deepak






Re: Reinstalling MSSQL Server 2000 Over-the-top?

Madhu K Nair

If the problem is with only Enterprise Manager... Try to reinstall only client tools. It should work. If you are uninstalling the instance itself... keep proper backup and check the current version. After installation upgrade the system with Service pack to get it pervious version. If for some reasone , you are not able to restore/attach system db you should not loose anything. You have to have backup of all the user databases.

To be in safer side

(a) Script Jobs

(b) for login check this http://support.microsoft.com/kb/246133

(c) You may need to keep backup of DTS also.

Madhu