Question : I am using Ola’s scripts for our database backups, I am trying to come up with a way […]
Tag: ola-hallengren
Running Backup on single DB when scheduled job (USER_DATABASES) has failed
Question : I’m using Ola Hallengren’s sp to take backup of database. FULL DIFF and LOG backup is created with […]
DBCC CHECKDB running longer
Question : We are using Ola’s Maintenance solution and part of that we have job DatabaseIntegrityCheck – User Database and […]
Index Reorganize/ Rebuild Time
Question : I have maintenance job on SQL Server 2012 Enterprise Edition that runs daily to check index fragmentation and […]
Questions on updating statistics and index maintenance jobs
Question : Since my question Index and statistics optimization scripts duration and log bloat problem. Looking for good strategy? has […]
Long running index rebuild
Question : I’m running an index rebuild using Ola Hallengren’s script below. EXECUTE dbo.IndexOptimize @Databases = ‘insight’, @FragmentationLow = NULL, […]
Modify Backup Directory Path Ola Maintenance Script
Question : I have configured backup using SQL Server Maintenance Solution by Ola (https://ola.hallengren.com). In the backup job, I specified […]
Simple and Full recovery models
Question : Not an SQL admin and new to ola-hallengren great scripts. Just wondering if people are mostly doing a […]
Ola Hallengren DatabaseBackup error on locating Windows directory
Question : Need help in resolving the issue with backing up a DB using Ola Hallengren’s stored procedure to a […]
How to control reindexing that results in high log send queue
Question : During reindexing using Ola’s IndexOptimize stored procedure, the log send queues for remote asynchronous replicas can grow quite […]