Advice needed to reinstall SQL 2005

5 pts.
Tags:
SQL Server 2005
SQL Server installation
I'm fairly new to administrering SQL 2005. I need to reinstall SQL Server 2005 due to a few problems I've been having with dll's not being registered. We also run the reporting services. I just need to know what impact uninstalling and reinstalling SQL will have on the current DB's and reports and the historical information. Any guidance gratefully received.

Answer Wiki

Thanks. We'll let you know when a new response is added.

Doing a reinstall shouldn’t have any impact on your existing databases or reports. The databases can be reattached, as can the reporting services databases. When the new reporting services instance checks in it should pick up all the reports.

Before doing the reinstall be sure to export all the encryption data from the SSRS configuration tool.

All your historical job data will be replaced by the new MSDB database.

Try reinstalling the service pack or hotfix that you are running. This may reregister all the DLLs.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following