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)
Deploying SQL Server 2005 with SP2 Using an OSD Task Sequence (Part 2)
The first thing that you need to do before deploying SQL Server 2005 and SQL Server 2005 SP2 using a task sequence is to create the packages and programs...

Posted Friday, October 31, 2008 2:33 AM by jgilbert | with no comments

Deploying SQL Server 2005 with SP2 Using an OSD Task Sequence (Part 1)
One of the coolest features (I think) of Configuration Manager is the ability to deploy software using task sequences, but because task sequences are generally...

Posted Friday, October 31, 2008 2:01 AM by jgilbert | 1 comment(s)

Getting Required Updates on Non-Internet Connected SUPs (Part 1)
Before you get to this point: You need to have successfully synchronized your active SUP with the latest and greatest software updates metadata and the...

Posted Tuesday, October 28, 2008 8:24 PM by jgilbert | with no comments

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...

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

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...

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

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...

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

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...

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

Filed under: