Scripted Decommission SharePoint 2007 Web Application

We have approval to decommission one of our last SharePoint 2007 Web Applications! Only two more to go then we are a full 2010 shop!!  I was going to write a script to perform the whole process with one click but can not justify it as we only have two web applications left to decommission.  I am happy with this THREE step process.  Feel free to use it or post comments.

Get the list of Site Collections

1. Run the following command to get all of the site collection URL's and
2. stsadm -o enumsites -url https://webapplication.url > c:\temp\SiteCollections.xml

This will give you all of the details in an XML file that you need to work with

Generate the STSADM / SQL Delete statements

1. Open the XML file in Excel 2010 (it will put everything into columns for you
2. Create a new column with the following formula (this is your "Site Collection Delete Script")
3. ="stsadm -o deletesite -url " &[@Url] & " -gradualdelete"
4. Create a new column with the following formula (this is your "Content DB Delete Script")
5. ="stsadm -o deletecontentdb -url https://webapplication.url  -databasename " & [@ContentDatabase]
6. In this web application we have one Site Collection for each Content Database if you do not you will have to remove non Unique values for this script (or just let it fail)
7. Create a new column with the following formula (this is your "DROP Database script")
8. ="DROP DATABASE [" & [@ContentDatabase] &"]"
9. Your scripts will look like this:

• stsadm -o deletesite -url https://webapplication.url/stuff/eight -gradualdelete
• stsadm -o deletecontentdb -url https://webapplication.url -databasename eight -data
• DROP DATABASE [eight]

I always thought that if you have a multi server farm you had to specify the database server to delete the content database.  Turns out you don't.

Run the scripts

1. Run the "Delete Site Collection Script"
2. Check to make sure you got all of the Site Collections by going to Central Admin --> Application Management --> Content Databases
3. Every Content Database should by in a stopped State and have 0 Sites
4. Run the "Content Database Delete Script"
5. Check to make all the Content Databases have been deleted by going to Central Admin --> Application Management --> Content Databases
6. This only detaches the databases from SharePoint!  You still have Drop the Databases
7. Run the "DROP Database script" (on the SQL Server)

The only thing left to do is delete the Web Application I did that in Central Admin though not using stsadm.

If some one writes a one click decom prodecdure let me know.