THE SQL Server Blog Spot on the Web

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

Browse by Tags

All Tags » Maintenance » backup » SQL Server Agent   (RSS)
  • Ola Hallengrens Maintenance Solution now supports mirrored backup

    You probably know that you can mirror a backup to several destinations, assuming you are on a supported edition (Enterprise or Developer). This is not the same as striping; you can compare striping to RAID 0, and mirroring to RAID 1. Ola now supports mirroring in his maintenance solution, found here. A couple of examples: EXECUTE ...
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on November 3, 2014
  • Backup and the evil RETAINDAYS option

    ''So what bad has this option done?'', you probably as yourself. Well, not much, but I find it evil because it confuses people, especially those new to SQL Server. I have many times seen people specifying something like 3, and expect SQL Server to keep the three most recent backups in the backup file and overwrite everything which is older than ...
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on July 8, 2012
  • Ola Hallengren's maint procedures now supports exclusions

    Ola has a set of stored procedures to do maint operations, see http://ola.hallengren.com/. Ola has now updated them to support exclusions or inclusions of tables, indexes or even whole schemas from index rebuild/reorg. Check out http://ola.hallengren.com/Documentation.html#SelectingIndexes for info on how to define exclusions and ...
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on August 9, 2010
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement