8

Short of reinstalling the software, is there a simple way to 'start from scratch' with a SQL instance? By that I mean:

  • Remove all created logons,
  • Remove all added databases,
  • Reset system databases,
  • Remove any new configuration,
  • Reset any SQL Server Agent configuration

I can't find anything online on how to do this.

13

You should rebuild the system databases.

Setup /QUIET /ACTION=REBUILDDATABASE /INSTANCENAME=InstanceName /SQLSYSADMINACCOUNTS=accounts [ /SAPWD= StrongPassword ] [ /SQLCOLLATION=CollationName]

This would not remove the data and log files relating to the old databases - it just removes all references to them. You would have to manually remove the files to free up the disk space.

You must also install all service packs and hotfixes again.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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