Advice needed to reinstall SQL 2005
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.
Software/Hardware used:
Software/Hardware used:
ASKED:
September 23, 2008 11:20 AM
UPDATED:
September 28, 2008 5:16 AM
Answer Wiki:
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.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
