When running WSUS on a Small Business Server, the default location is the C:\ drive, when that drive gets full you need to move the content and the SQL database. Below are the steps to move the SQL database to another location.

1. Open command prompt and type: net stop “update services”

2. Next, at the command promt type: net stop w3svc (if it is SBS 2008 it will also stop the Terminal Services Gateway, remember to restart)

3. Open Microsoft SQL Express Management Studio (if you don’t have this, go to http://tinyurl.com/ynl9tv to download) and connect to the MICROSOFT##SSEE database, which is the WSUS database and the SharePoint databases in SBS 2008. You can’t just connect to the database normally, you need to type this in server name area:   \\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query

 4. Detach the SUSDB database, move the SUSDB folder to the new location and attach the database again with Management Studio

5. Restart the services: “update services”, “w3svc”, and “Terminal Services Gateway”

You have 2 options.

1. You can run the following SQL query:

   SELECT SERVERPROPERTY(’productversion’), SERVERPROPERTY (’productlevel’), SERVERPROPERTY (’edition’)
   

2. You can check the version of the sqlservr.exe file, below is a list of how the version breaks down:

   SQL Server 2005

   SQL Server 2005 RTM	2005.90.1399
   SQL Server 2005 Service Pack 1	2005.90.2047
   SQL Server 2005 Service Pack 2	2005.90.3042

   SQL Server 2000

   SQL Server 2000 RTM	2000.80.194.0
   SQL Server 2000 SP1	2000.80.384.0
   SQL Server 2000 SP2	2000.80.534.0
   SQL Server 2000 SP3	2000.80.760.0
   SQL Server 2000 SP3a	2000.80.760.0
   SQL Server 2000 SP4	2000.8.00.2039