Browse by Tags

• Rebuilding msdb on SQL Server 2008

  Because of the problems I had removing Data Collector I decided to rebuild msdb. You probably heard about instmsdb.sql, but it was a long time since I actually used it. I asked about rebuilding in the MVP group and Dan Jones (MS) pointed me to a Blog Read More... Posted Wednesday, August 27, 2008 1:10 PM by TiborKaraszi | 0 Comments Filed under: Backup, SQL Server 2008

• Backup compression in SQL Server 2008

  Having a few moments to spare, I decided to give this a spin. Specifying for the backup to be compressed is really simple. Just specify COMPRESSION in the WITH clause of the BACKUP command. For example: BACKUP DATABASE Adventureworks TO DISK = 'C:\Advc.bak' Read More... Posted Wednesday, December 12, 2007 5:52 PM by TiborKaraszi | 22 Comments Filed under: Backup, SQL Server 2008