Contents
What happens when you do a full backup in Ola?
When you execute a new full backup or full copy_only backup or even differential backup, All your previous log backups will be deleted after you run another log backup (Ola’s log backup script with @CleanupTime = 0 param). Tested using Ola’s script version: October 7]
What’s the cleanup time parameter for Ola Hallengren?
When I deploy Ola Hallengren’s backup script into my servers, I always set the @CleanupTime parameter for log backups to zero. This way, every time the log backup job runs, it checks for log backup files older than the last full backup and deletes them.
How to install Ola Hallengren’s utility scripts on all of the replicas?
Install Ola Hallengren’s utility scripts on all of the replicas. During the install, it creates a laundry list of SQL Agent jobs, but doesn’t set up schedules for any of them. More on that in a couple of steps. 2. Set your backup preferences. In SSMS, right-click on your Availability Group, click Properties, and click the Backup Preferences pane.
How to delete the transaction log in Ola?
Ola designed his script to check for the last BACKUP DATABASE… (Full Backup) and then to delete the transaction logs backups ( BACKUP LOG …) which have occurred before that backup and only if the @CleanupTime is lower than when the FULL Backup occurred. This is a fail-safe mechanism and not meant to be used as a general feature.
How to automate restores for Ola Hallengren backup solution?
While going through Brent Ozar’s 6-Month DBA Training Plan, I got myself a good challenge quite fast, after reading “Automating Restores” – to automate restores on backups taken using Ola Hallengren Backup Solution. Before anything, these scripts use xp_cmdshell procedure, so it needs to be enabled:
How long does it take to restore database in Ola?
Processed 0 pages for database ‘StackExchange’, file ‘StackExchange’ on file 1. Processed 2 pages for database ‘StackExchange’, file ‘StackExchange_log’ on file 1. RESTORE LOG successfully processed 2 pages in 0.005 seconds (2.441 MB/sec). Ola’s script works as designed. We have verified that a BACKUP DATABASE