Skip to main content
Share Your Experience: Take the 2024 Developer Survey

Questions tagged [ola-hallengren]

Refers to the set of SQL Server Management Scripts created and maintained by Ola Hallengren. Questions tagged with this tag should be about how to use the scripts or about how to resolve an issue with the script.

Filter by
Sorted by
Tagged with
7 votes
3 answers
3k views

Ola Hallengren index maintenance - long periods of time between commands?

I run the Ola Hallengren scripts on all of my servers for index and statistics maintenance. When I look through the command log table, I notice long periods of time between a command ending, and the ...
Erik Darling's user avatar
  • 41.2k
10 votes
5 answers
5k views

What are pros and cons of Ola’s scripts vs using maintenance plan?

Will you please help me understand pros and cons of using Ola’s solution over maintenance plan? I have prepared a presentation based on SQL Pass (http://www.pass.org/DownloadFile.aspx?File=ebae1b31) ...
Pat's user avatar
  • 337
5 votes
1 answer
4k views

Getting a proxy account to backup to a share using Ola Hallengrens backup script

I have a SQL Server 2012 Standard install where the Engine and Agent are running under the default NT Service accounts Engine - NT Service\MSSQLSERVER Agent - NT Service\SQLSERVERAGENT I am trying ...
Lawrage's user avatar
  • 446
3 votes
1 answer
977 views

Automating DB Restore from network share

We have a network share that uses different credentials from the currently logged in user. Inside this share we have full, differential and log backups that come through from a third party database ...
Asher's user avatar
  • 303
15 votes
3 answers
889 views

Transaction Log Backups Serial or Parallel?

We happen to be using SQL Server 2012 Standard Edition. I also happen to use Ola Hallengren's scripts to provide an easy, more flexible framework for doing backups and maintenance. This question isn'...
Chris Aldrich's user avatar
12 votes
3 answers
18k views

Understanding CleanupTime in Ola Hallengren's SQL Server scripts in relation to FULL backups and LOG backups

I am having trouble understanding what exactly to expect from the CleanupTime option in the Ola Hallengren Server Maintenance Solution. I'm finding some related questions, and elaborate answers, but ...
Wouter's user avatar
  • 821
3 votes
2 answers
465 views

Can a single database be excluded from an AG backup?

I want to backup all the databases in an availability group except one. Using the @AvailabilityGroups option in Ola's Maintenance Solution scripts, can a single database in an Availability Group be ...
Phil Holmes's user avatar
3 votes
1 answer
260 views

Any disadvantage to automatically changing FULL backup on AlwaysON Secondary to COPY_ONLY?

I've been playing around with Ola's maintenance scripts recently, and they are absolutely great. However, I was considering one scenario and was surprised when I found it wasn't catered for. Maybe I'm ...
Kingithy's user avatar
3 votes
1 answer
636 views

Filter Schema In Index Optimize Script

Is it possible to do index optimization with Ola's scripts and have it filter out a specific schema?
MaricopaJoe's user avatar
2 votes
1 answer
702 views

how to integrate ola hallengren solution with log shipping?

I need to set up log-shipping from my SQLPROD2 to server2 but I am facing the following problems: 1) I already use ola hallegren backup solution, and it provides the 15 min log backups for all ...
Marcello Miorelli's user avatar
1 vote
2 answers
4k views

Sqlcmd: Error: Microsoft ODBC Driver 17 for SQL Server : Data source name not found and no default driver specified

I recently upgraded from SQL Server 2017 Express to SQL Server 2019 Express and installed Microsoft SQL Server ODBC Driver 18. However, a sqlcmd script to back up all databases, using Ola Hallengren's ...
Mike Pace's user avatar
1 vote
1 answer
266 views

Questions on updating statistics and index maintenance jobs

Since my question Index and statistics optimization scripts duration and log bloat problem. Looking for good strategy? has been closed because it was not focused enough I've three questions: For ...
user1673665's user avatar
-2 votes
1 answer
293 views

Database Integrity check fails as follows

(I have used the Ola Hallengren scripts for quite a while)....but if there is an open query I end up with the following: Msg 5030, Sev 16, State 12, Line 1 : The database could not be exclusively ...
Ian Cope's user avatar