Is there a way to reset a SQL Server Express 2008 to it's initial configuration? Maybe re-creating the instance?

link|improve this question

feedback

2 Answers

up vote 2 down vote accepted

No, there's not a way to reset SQL Server Express to the default configuration and data.

Your best bet would be to uninstall Express and reinstall it.

link|improve this answer
Brent is right, and if you tried to manually compare your current instance to a "default" configuration, it would take a lot more time than it will to just reinstall. – Aaron Alton May 24 '09 at 15:27
feedback

Without providing more information on what you have changed its hard to answer your question properly.

You may want think about joining a SQL community to help you with your learning.

I use SQL Server Central and have found the forums and scripts to be a valuable resource when needing to extract information during my daily DBA tasks

Disclaimer: I am a member of the site but not affiliated in any other way.

link|improve this answer
I've changed many things, like protocols available and other bits. I'm most worried about those I don't remember I change. – J. Pablo Fernández May 24 '09 at 11:06
Why vote down? He has asked several questions on SQL server and this post was about joining another community SQL specific. – Wayne May 25 '09 at 5:06
feedback

Your Answer

 
or
required, but never shown

Not the answer you're looking for? Browse other questions tagged or ask your own question.