THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » Backup » SQL Server 2008   (RSS)
Sorry, but there are no more tags available to filter with.
  • 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 post from Paul Randal on how to do this on SQL Server 2005. Here's Paul's blog ...
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on August 27, 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'  WITH INIT, COMPRESSION For fun, I ...
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on December 12, 2007
Privacy Statement