mylifeinaminute.com

Attempting to run the SharePoint 2010 Configuration Wizard through PowerShell (New-SPConfigurationDatabase) yielded the following error:

New-SPConfigurationDatabase : SQL server at CLSHPT2010SQL has an unsupported version 10.0.2531.0. Please refer to “http://go.microsoft.com/fwlink/?LinkId=165761″ for information on the minimum required SQL Server versions and how to download them.

At line:1 char:28

I had never installed the latest cumulative update for SQL Server 2008 after completing my cluster configuration. The fix is simple. Install the Cumulative update package 2 for SQL Server 2008 Service Pack 1 (KB970315).

Reference

• KB970315 – Cumulative update package 2 for SQL Server 2008 Service Pack 1

Microsoft has completely removed the BACKUP LOG WITH TRUNCATE_ONLY capability completely from SQL Server 2008. If you try to attempt to execute the following command:

BACKUP LOG AdventureWorks WITH TRUNCATE_ONLY

This is the result:

'TRUNCATE_ONLY' IS not a recognized BACKUP OPTION.

To circumvent this error in a DEVELOPMENT environment (not Production), use the following commands:

USE AdventureWorks
GO
ALTER DATABASE AdventureWorks SET RECOVERY SIMPLE
DBCC SHRINKFILE(N'AdventureWorks_log', 1)
ALTER DATABASE AdventureWorks SET RECOVERY FULL
GO

One should never execute the above commands in a Production environment unless you wish to lose all of your prior transaction log backups and the ability to restore to a given point in time based on those backups.

Reference

• DBCC SHRINKFILE (Technet)