Backup, Integrity Check and Index Optimization

Ola Hallengren and his ongoing work of his SQL Server 2005 and 2008 - Backup, Integrity Check and Index Optimization scripts - makes me happy :-)

He made some updates to the maintenance scripts:

  • Changed behaviour in the job that deletes old output files. The old version returned an error if there was no files to delete. This has been changed not to return an error.
  • Bug fix: Collation conflict when creating the objects in a database with a collation other than the collation in tempdb.
  • Changed default for backup compression. In the new version the backup compression default in sys.configurations is used in SQL Server 2008 Enterprise Edition and in SQL Server 2008 R2 Standard, Enterprise and Datacenter Edition. In SQL Server versions and editions where backup compression is not supported the default is 'N'.
  • New job for purging job history. It's using the stored procedure sp_purge_jobhistory
  • New job for purging backup history. It's using the stored procedure sp_delete_backuphistory
  • New job for deleting output files
  • If you have an index with page locking disabled and you rebuild it online using multiple CPUs, the fragmentation will in some cases not go away. This is a bug in SQL Server 2005, SQL Server 2008 and SQL Server 2008 R2. I have made a workaround in IndexOptimize setting MAXDOP = 1, when you rebuild an index online that has page locking disabled
  • Now backup compression is supported also in Standard Edition

CU
tosc

Glorf-IT: SQL-PASS-Wunschliste für Franken

Rebuilding system databases in 2008 R2

Treffen der Regionalgruppe Franken 09.06.2010

#CU package 1 for SQL Server 2008 R2

The Cumulative update package 1 for SQL Server 2008 R2 (Build 10.50.1702.0) is available:

http://support.microsoft.com/kb/981355/

And here you can get the whole information of builds that were released after SQL Server 2008 R2 was released:

http://support.microsoft.com/kb/981356/

CU
tosc

#CU 8 for SQL Server 2008 Service Pack 1

The Cumulative update package 8 for SQL Server 2008 Service Pack 1 (Build 10.00.2775) is available:

http://support.microsoft.com/kb/981702/

And here you can get the whole information of builds that were released after SQL Server 2008 Service Pack 1 was released:

http://support.microsoft.com/kb/970365/en-us

CU
tosc

The Exceptional DBA Awards are back in 2010!

What do you think?

Quidquid agis, prudenter agas et respice finem!

CU
tosc

SQL PASS Franken: DBA Best Practices

Mladen Prajdić - New SSMS Tools Pack!

SSMS Tools Pack 1.8 is out!

This is a release that fixes all known major bugs and most of the minor ones.

The main feature list hasn’t changed.

You can download the new version here.

So, take a look - and feel free :-)

http://www.ssmstoolspack.com

CU
tosc

R2 Express Limit Increased to 10GB

The maximum database size in SQL Server 2008 R2 Express increased from 4GB to 10GB.

Here you can get more information on features supported by the editions of SQL Server 2008 R2:
http://msdn.microsoft.com/en-us/library/cc645993(v=SQL.105).aspx

I wish you a nice day,
tosc