Jeff Gilbert's Web blog at myITforum.com

This posting is provided "AS IS" with no warranties, and confers no rights :-)

Browse by Tags

All Tags » SQL Server Stuff (RSS)
Finding Installed Editions of SQL Server Using SMS 2003 Hardware Inventory
If you're running SMS 2003 SP2 (or earlier versions of SMS 2003) then inventorying SQL Server installations can be a little difficult. The information displayed in Add/Remove programs for SQL Server...

Posted Sunday, January 27, 2008 9:38 PM by jgilbert | 2 comment(s)

Filed under: , ,

Moving the SMS 2003 site database from SQL Server 2000 to a SQL Server 2005 remote database instance
In order to upgrade an SMS 2003 SP2 or SP3 site to Configuration Manager 2007 the site database must be at the SQL Server 2005 SP2 level. If you don't want to upgrade a SQL Server 2000 instance hosting...

Posted Wednesday, November 21, 2007 4:50 PM by jgilbert | with no comments

Filed under: ,

Upgrading SQL for SMS Sites
In order to upgrade an SMS 2003 SP2 or SP3 site to Configuration Manager 2007 the site database must be at the SQL Server 2005 SP2 level. Upgrading SQL Server can be a daunting prospect for a lot of SMS...

Posted Saturday, November 17, 2007 6:13 PM by jgilbert | 4 comment(s)

Filed under: , ,

You should probably use the SQL Server Simple Recovery Model for the SMS/Configuration Manager site database
Why? Using the simple recovery model improves performance and saves your server hard drive space from a useless (from an SMS recovery point of view) and possibly large, transaction log file. Using the...

Posted Thursday, August 16, 2007 4:23 AM by jgilbert | 1 comment(s)

Filed under: