top of page

Backup & Restore

Ola Hallengren's scripts

  • Rename IndexOptimize to DatabaseIndexOptimize - USER_DATABASES

  • Databases greater 1T, use weekly FULL with daily DIFF

  • Databases less than 1T, use daily FULL with hourly LOG

  • @MirrorDirectory allows to copy to a remote server for safe keeping or reporting purpose

  • Database Integrity and Index Optimize Check on every weekend

Azure Blod Backup

Always On Availability

© 2017 by DBADude

  • w-facebook
  • Twitter Clean
bottom of page