Rebuilding Your SharePoint 2010 Farm
If you’re doing some SharePoint Server 2010 testing like I am, you might find yourself needing to rebuild your environment. For simple testing, I’m using a single-server SharePoint Server 2010 farm. Just like in MOSS 2007, the easiest way to rebuild is to break the task into two steps:
Step 1: From the 14 hive SharePoint root, run:
psconfig –cmd configdb -disconnect
This will detach the server from the farm (or if it’s the only server, it will remove the farm).

Step 2: Using SQL Management studio, delete all of the SharePoint databases. If you are using the stand-alone installation of SharePoint 2010 with SQL Express, you can download SQL Server Management Studio Express. (And look here for tips on installation of the express version of the management tool.)

Once you’ve got your server farm clean, you can run psconfig (or the SharePoint 2010 Products Configuration Wizard) to get your SharePoint farm back up with a clean install.







The other way to cleanup quickly, of course, is to use a virtual environment and then rollback to a clean checkpoint. But this method works well when a VM isn’t available or your checkpoint is further back.
Thanks. Very helpful posting.