SharePoint Stuff



Quest Tools

Written by admin. Posted in Microsoft

LiteSpeed – for SQL Server
———————————-

In summary LiteSpeed is a backup utility. This backup tool is being used by Microsoft and some of the leading banks to backup there SQL Server. This backup utility has the ability to improve backup and restore times by up to 70% faster and will compress the data up to 90% smaller. Light speed will also encrypt (256bit) the backups, allow for Row level restore and transaction log rollback.

In the next version of LiteSpeed version 5, the tool will contain a policy base system this will allow you to tweak your backup schedules, from one location to multiple SQL Servers and SQL instances.

SQL Data Size Backup size and time
1.1TB of SQL Data SQL Server backup 850GB completes in about 10hrs
LiteSpeed SQL Server backup 124GB completes in 2hrs

LiteSpeed

More information can be here: http://www.quest.com/litespeed-for-sql-server/

Spotlight – for SQL Server
——————————–

In summary Spotlight allows DBA’s to view at a quick glance the performance and health of a SQL Server. It has the ability to alert DBAs of a problem, and then though the tool allows the DBA to resolve the issue without having the need to open SQL Manager.

Spotlight has been configured to the Microsoft Best practices (these can be tweaked) and comes with a usable Knowledge Base.

This tool will only add an additional 1% CPU over head to the SQL Server and can monitor up to 50 SQL Instance on one server.

Spotlight can also integrate with Tivoli, MOM and SCOM. This tool will help greatly in areas such as governance and supportability.

Not only that but it has a cool star trek interface (which any geek would like)

SpotLight

More information can be here: http://www.quest.com/spotlight-on-sql-server-enterprise/

Performance Manager – for SQL Server
————————————————

Performance Manager is a real-time in-depth workload analysis tool for SQL Server. The tool can work out over a period time the base line of SQL Server and when unusual workload spikes occur. This tool has the ability to drill down to the specific SQL statement that caused the problem and will then provide recommendations on how to resolve the problem.

This tool will only add an additional 3% CPU over head to the SQL Server

For me this was the most powerful business tool that I have seen

More information can be here: http://www.quest.com/sql-server/performance-management.aspx

Recovery Manager for SharePoint
—————————————–

Recovery manager for SharePoint has the ability to granularly restore documents into SharePoint sites without having to restore a complete content database.

It should be noted that Recovery Manager does not backup SharePoint instead it consumes backups from SharePoint backups, Windows Backups, SQL Backups, Tivoli, Backup exec and LiteSpeed Backups. However we only saw it working with LiteSpeed

Other tools in this area is BackupExec, Microsoft DPM and AvePoint

More information can be here: http://www.quest.com/recovery-manager-for-sharepoint/
More Information.

Spotlight also comes in the following MS flavours:
Exchange
Windows
Active Directory

Recovery Manager Comes in the following MS flavours:
Active Directory
Exchange

Quest has many more products which can be found here: http://www.quest.com/products/all-products.aspx

SharePoint MOSS 2007 Service Pack and Hotfix levels

Written by admin. Posted in Microsoft

Below are the hotfixes and service pack (SP) levels for MOSS 2007 and WSS v3.0:

NOTE: Don’t forget MOSS installations will also require the WSS patches applying as well. the patch order should be WSS then SharePoint update.

The latest Service Pack must be applied before applying any other updates (Post the Service Pack)

Cumulative updates includes all previous updates apart from the Service Pack

When installing SharePoint Updates your login account must:

  • Be an administrator account on all MOSS Servers.
  • Have at least the Database Creator role and the Security Administrator role.
  • Have access to all the SharePoint Server databases.
Version Knowledge Base Article Description
12.0.6562 MOSS 2007 or WSS 3.0 (KB2544399, KB2544398) June 2011 Cumulative Update
12.0.6557 MOSS 2007 or WSS 3.0 (KB2512783, KB2512782) April 2011 Cumulative Update
12.0.6554 MOSS 2007 or WSS 3.0 (KB2475886, KB2475885) February 2011 Cumulative Update
12.0.6550 MOSS 2007 or WSS 3.0 (KB2458606, KB2458605) December 2010 Cumulative Update
12.0.0.6548 MOSS 2007 or WSS 3.0 (KB2412268, KB2412267) October 2010 Cumulative Update
12.0.0.6545 MOSS 2007 or WSS 3.0 (KB2276474, KB2276472) August 2010 Cumulative Update
12.0.0.6539 MOSS 2007 or WSS 3.0 (KB983311, KB983310) June 2010 Cumulative Update
12.0.0.6535 MOSS 2007 or WSS 3.0 (KB981043, KB981042) April 2010 Cumulative Update
12.0.0.6529 MOSS 2007 or WSS 3.0 (KB978396, KB978395) February 2010 Cumulative Update
12.0.0.6524 MOSS 2007 or WSS 3.0 (KB977026, KB977027) December 2009 Cumulative update
12.0.0.6520 MOSS 2007 or WSS 3.0 (KB974988, KB974989) October 2009 Cumulative update
12.0.0.6514 MOSS 2007 or WSS 3.0 (KB974988, KB972989) August 2009 Cumulative update
12.0.0.6510 MOSS 2007 or WSS 3.0 (KB973409, KB973410) June 2009 Cumulative update
12.0.0.6504 MOSS 2007 or WSS 3.0 (KB9698851, KB968857, KB968850) April 2009 Cumulative update
12.0.0.6421 MOSS 2007 or WSS 3.0 Service Pack 2  April 28, 2009 (Service Pack 2)
12.0.0.6341 MOSS 2007 or WSS 3.0 (KB961749, KB961750) February 24, 2009 (Cumulative Update)
12.0.0.6335 MOSS 2007 or WSS 3.0 (KB960011, KB960010) December 16, 2008, (Cumulative Update)
12.0.0.6332 MOSS 2007 or WSS 3.02 (KB957691, KB957693, KB958847) October 28, 2008, (Cumulative Update)
12.0.0.6327 MOSS 2007 or WSS 3.0 (KB956056 & KB956057) August 26, 2008 updates
12.0.0.6318 MOSS 2007 or WSS 3.0 (KB951695 & KB951297) July 15, 2008, (Infrastructure Update )
12.0.0.6317 MOSS 2007 or WSS 3.0 Hotfix (KB953484, KB953473)  June 5, 2008
12.0.0.6316 MOSS 2007 or WSS 3.0 Hotfix (KB953138, KB953137)  May 29, 2008
12.0.0.6315 MOSS 2007 or WSS 3.0 Hofix (KB952698 & KB952704) May 20, 2008 post-SP1 hotfix (Content Deployment Updates)
12.0.0.6314 MOSS 2007 or WSS 3.0 post-SP1 hotfix (KB952294) Search extension Update
12.0.0.6303 MOSS 2007 or WSS 3.0 (KB948945) February 15, 2008 post-SP1 hotfix
12.0.0.6301 MOSS 2007 or WSS 3.0 (KB941274) January 31, 2008 , post-SP1 hotfix
12.0.0.6300 MOSS 2007 or WSS 3.0 (KB941422) January 31, 2008, post-SP1 hotfix
12.0.0.6219  MOSS 2007 (KB945013) or WSS 3.0 (KB  December 12, 2008, SP1 RTM
12.0.0.6039 MOSS 2007 or WSS 3.0 October public update October 12 ,2008, public update
12.0.0.6036 MOSS 2007 or WSS 3.0 August 24 August 24, 2007 hotfix package
12.0.0.4518 MOSS 2007 or WSS 3.0 RTM  
12.0.0.4407 MOSS 2007 or WSS 3.0 Beta 2 TR  
12.0.0.4017 MOSS 2007 or WSS 3.0 Beta 2:  

If you are restoringInstallingadding an existing content DB and you receive an error regarding versions, make sure you are running the same patch level as the existing site or higher. If you are not sure deploy the latest update.

Note: for some hotfixes you will need to run the SharePoint Products and Technologies Configuration Wizard or “psconfig –cmd upgrade –inplace b2b -wait” if wait fails then try “psconfig –cmd upgrade –inplace b2b -force’”in command line

Follow the latest update information here: http://technet.microsoft.com/en-us/office/sharepointserver/bb735839.aspx

UPDATED: 13-Jul-2011