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
4 votes
3 answers
5k views

Ola Hallengren solution, backups not cleaning up

I have about 30 SQL Server 2005-2014 instances, all of which use the excellent Ola Hallengran maintenance script to produce my full/diff/log backups. This has worked for me for years with no issues, ...
Peter's user avatar
  • 1,490
2 votes
1 answer
200 views

Ola's maintenance solution is not processing sysjob* tables

I have used Ola Hallengren's script to back up and maintain databases. However, it does not perform any reindex or reorganize operations against certain tables in msdb, such as sysjobhistory, even ...
Mcol's user avatar
  • 449
7 votes
1 answer
2k views

Ola Hallengren Index Script not Reindexing

First, I realize a similar question was asked and the poster had page count set to 1000 for a 679 page index; not what's going on. I have Ola's script set as @Databases nvarchar(max) ,@...
jbkelly's user avatar
  • 93
5 votes
3 answers
2k views

Backup to local and MIRROR TO Azure Files returns ERROR

I have an Azure VM with SQL Server 2014, with a local drive (X:) for storing backups. Using Ola Hallengren's scripts. I added an Azure Files share and tried to do a mirror backup, but I get the ...
nulldotzero's user avatar
2 votes
1 answer
2k views

How to implement Ola Hallengren backup plan on the server for some databases nightly full backups and for other weekly full backup only

I recently implemented Ola Hallengren Maintenance solution on all of my production servers(SQL server 2005,2008,2008R2 and 2012). It works great. My problem is how to implement Ola Hallengren backup ...
SQL_DBA_Bini's user avatar
2 votes
0 answers
168 views

ola hallengren Index Maintenance script - GUID Index

We been running ola hallengren Index Maintenance script and was ran into a problem with some indexes that have GUID as the Index Key, They are Frag and have a page count of 6,309, but they don’t get ...
Harry's user avatar
  • 21
3 votes
1 answer
895 views

How to update commands in Ola Hallengren's SQL Server jobs?

I am looking for an easy way to update the jobs that get created from Ola's MaintenanceSolution.sql script without having to completely delete and re-create them or having to modify each job ...
Matador1006's user avatar
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
  • 40.8k
5 votes
1 answer
544 views

Why is the lease locked for a some full sql backups to Azure Blob using Ola Hallengren backup scripts?

I'm using SQL Server 2012 and working on backing up to Azure Blob using Ola Hallengren backup scripts. Some backups are lease locked (ex. model) while others are not (ex. msdb). It's inconsistent, it ...
AP1's user avatar
  • 51
6 votes
2 answers
1k views

Ola Hallengren with database mirroring

I am about to setup Ola Hallengrens database maintenance plan. We have our database mirrored and I was just wanting to know if I need to run the script on both my Sql Server instances or only the ...
Peuge's user avatar
  • 209
4 votes
0 answers
830 views

Allow developers to run database maintenance

We use the database solution by Ola Hallengren. We're trying to give our developers a way to run the maintenance stored procedures after they do an ETL. Our developers have locked down permissions. We'...
Elijah W. Gagne's user avatar
4 votes
1 answer
2k views

Will Ola's default IndexOptimizer job update my stats?

I just installed Ola Hallengren's MaintenanceSolution.sql maintenance scripts. After looking at the output of the log generated by the IndexOptimize - USER_DATABASES job, I'm concerned that it's not ...
poke's user avatar
  • 527

1 2 3 4 5
6