Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

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.

0
votes
1answer
21 views

What rights do you need for Ola's integrity check?

I'm configuring a new server and Ola's integrity check is working for user databases (I have restored a database of around 50 GB for tests) and is failing for system databases. If I look in the logs ...
2
votes
1answer
198 views

Fragmentation Level for Heaps

I am currently using scripts provided by Mr. Ola Hallengren for executing maintenance job and of-late I have been noticing that there are many tables (heaps) fragmentation level is alarmingly high and ...
-4
votes
0answers
24 views

Error: The value for the parameter @Directory is not supported with Ola backup script [closed]

I have just installed Ola Hallengren's backup scripts on a new install of SQL Server 2017 and am getting this error: The value for the parameter @Directory is not supported. The directory I used ...
0
votes
0answers
22 views

Ola Hallengren - Parallel Backup Jobs failing on SINGLE_USER DB - 'Database is in transition' [952]

I'm using Ola's DatabasesInParallel option for "multi-threaded" execution. Last night a db was temporarily placed into SINGLE_USER for an application-based archive process and it caused all 5 threads ...
0
votes
0answers
21 views

Does OLA Scripts support striping for backup to URL?

I am testing backups to blob using OLA scripts. However, I am unable to stripe the backups into multiple files. I tried using 'Numberoffiles' parameter. Please advise. I am using a shared access ...
0
votes
0answers
9 views

Index Optimize with PartitionLevel='N' fails on SQL Express Edition 2017

If I'm running the IndexOptimize SP with @PartitionLevel='N' the SP fails with Error: Msg 4104, Level 16, State 1, Line 1 The multi-part identifier "partitions.partition_number" could not be bound. ...
1
vote
1answer
44 views

DBCC check on Always On Secondary Replica

What is the best way to schedule DBCC check on all the nodes in Always On availability group. Can we just schedule the same job on all the nodes at the same time including all the secondaries. In my ...
0
votes
2answers
92 views

Database Maintenance Job and Backup Scheduling

I would request to have expert advise on scheduling maintenance and backup jobs. Below was the scenario prior to my change: Full backup of database scheduled to run at 12:30AM everyday. Differential ...
-1
votes
1answer
17 views

Running Backup on single DB when scheduled job (USER_DATABASES) has failed

I'm using Ola Hallengren's sp to take backup of database. FULL DIFF and LOG backup is created with respective schedules (agent job) and has been working great. Due to not enough free disk space on ...
1
vote
2answers
43 views

Ola Hallengren IntegrityCheck Excludes TempDB

According to SQL Server Maintenance Solution - SQL Server Integrity Check, the SYSTEM_DATABASES value includes only master, msdb, and model. Why is TempDB excluded, when it too can have hardware ...
4
votes
2answers
201 views

Ola Hallengreen Backup Retry

Is there a way to do an automatic backup re-try utilizing Ola Hallengren's back up scripts for just one database back up if there is a failure? Looking for a way to complete the back up without re-...
1
vote
2answers
89 views

SQL Server Backup failing for just 1 DB (“The system cannot find the path specified.”)

For the last few mornings, I have had a backup of our ReportServerTempDB fail. We are not using SSRS on this server yet, but will in the next month, so the DB is the default 8mb .mdf and 8mb .ldf (i.e....
-2
votes
1answer
31 views

Database Backup to URL fails with Device I/O Error [closed]

I'm using Ola's Maintenance Solution to backup my databases to a URL. Most of my databases backup just fine but I have one 2 TB database that continues to fail with a device I/O error. Has anyone ...
2
votes
1answer
67 views

Hallengren @DatabasesInParallel sql_message_id 50000 in sysjobhistory table

Just implemented Ola's Parallel execution for backups, integrity checks and index maintenance. Everything appears to be running great but I am seeing sql_message_id 50000 in the sysjobhistory table ...
1
vote
1answer
51 views

Exclude database form AG Backup

Is it possible to exclude a database from an availability group backup? My backup jobs looks like this: EXECUTE [dbo].[DatabaseBackup] @Databases = 'AVAILABILITY_GROUP_DATABASES' @URL= xxx, @...
0
votes
1answer
43 views

Ola scripts = log shipping and transaction logs

We use the Ola Hallengren scripts for full/diff/tran log backups. Ola's site indicates that log shipping is compatible unless we are using transaction logs. Why is that?
0
votes
1answer
105 views

sp_DatabaseRestore msg 50000

I used Ola's script to backup my database (SQL Server 2017) and now I'm trying to restore it using Brent's sp_DatabaseRestore. Currently trying to do a Full restore only. Here is my code, written ...
0
votes
1answer
49 views

DatabaseIntegrityCheck fails intermittently

Have been running the Ola Hallengren scripts on our new SQL Server 2016 Enterprise server for about 6 weeks or so now. The database Integrity script only works intermittently on some instances. ...
1
vote
1answer
65 views

Ola Hallengren - Backupdatabase Task

When running Ola's full SQL Server Maintenance Solution or the individual databasebackup script I get the following error: MSG 207, Level 16, State 1, Procedure DatabaseBackup, Line 1545 Invalid ...
0
votes
1answer
41 views

Reason for @@TRANCOUNT check?

we're using the SQL functions from Ola Hallengren since many years. Sometime between 2015 and 2018 the check for open transactions was added in IndexOptimize. So now, after upgrade to the current ...
1
vote
1answer
46 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 ...
0
votes
1answer
29 views

Custom Deletion for Ola Hallengren Scripts

I am trying to find a way to delete backups being taken by Ola's native SQL backups. I am trying to keep only 2 weeks of transaction logs, 5 weeks of diffs, ,14 weeks of full backups, 13 monthly full ...
1
vote
1answer
38 views

Custom backup deletion Ola Scripts

I am trying to find a way to delete backups being taken by Ola's native SQL backups. I am trying to keep only 14 days of transaction logs, 1 month of diffs, and 12 months of full weekend backups. Is ...
0
votes
1answer
20 views

Index Maintenance with Ola starting from day x (7 or 9) till the end of month

I want to run the index maintenance from Ola daily, but in my company the firsts business days every month I can't, cause heavy application usage during the night. So I want to run Ola's script only ...
0
votes
1answer
87 views

The value for the parameter @MirrorDirectory is not supported error with Ola Hallengren Backup script

I am using Ola Hallengren's Maintenance Solution, and it's been working great for our environment. Quick question regarding the User Database backups s proc. Currently, when I'm taking backups, the ...
1
vote
2answers
150 views

Trouble with Ola Hallengren's @DatabasesInParallel parameter

I am testing out this new parameter @DatabasesInParallel and it seems to only back up 1 databases at a time but it doesn't specificy this as a limitation in the documentation so I am wondering if I ...
0
votes
1answer
70 views

SQL Server hangs on index rebuild, works well after SQL service restart

We have a SQL Server 2014 enterprise cluster. Server 1 and Server 2. SQL Server is limited to 64GB of memory. We are using Ola Hallengren scripts for index rebuilding and optimizations once per week ...
1
vote
0answers
69 views

OLA Output File Cleanup - Better Options

Does anyone have a way to change the Ola Hallengren "Output File Cleanup" job that doesn't require CmdExec? My company is trying to eliminate CmdExec where ever possible. I was thinking a PowerShell ...
1
vote
2answers
85 views

SQL Maintenance Tasks on Azure [Ola Hallengren Scripts]

I am trying to implement the SQL maintenance scripts from Ola on my Azure elastic pool databases. I did the steps as provided in this link. I could create the job, but I always get this error after ...
0
votes
1answer
35 views

Excluding Read only Log backups using ola-hallengren script

I know that Full backups are excluded from readable secondaries, but how do I exclude log backups from read-only secondaries? The is_read_only column in sys.databases does not get set on ...
1
vote
2answers
287 views

DBCC CheckDb on Secondary Aynchronous Replica

Can I run Ola Hallengren CheckDb job on a Secondary Asynchronous Replica (DR) that is readable during business hours? Currently the Asynchronous Replica is not readable... First question is if it is ...
-1
votes
1answer
65 views

ola-hallengren cleanup will not remove AOAG old DB backups if server fails over

ola-hallengren cleanup will not remove AOAG old DB backups if server fails over anyone else experience this?
0
votes
1answer
100 views

Can not backup multiple (not all) databases Ola Hallengren [closed]

This error is quite easy to replicate. So before I send a bug to Ola, I'd like to check if maybe I'm doing it wrong. Version is 2018-06-27 20:44:12 I created 3 databases. DB1, DB2 and DB3. I'd like ...
3
votes
1answer
149 views

How Ola Hallengrens Index maintenance scripts handles columnstore indexes?

I'd like to know how Ola's script handles columnstore indexes. Couln't find any information about that, only in the version history it was mentioned that script does have a support. My experience is ...
0
votes
1answer
71 views

Index Maintenance - Reorganize After BIG SQL Server Shrink

I'm planning to execute the below index maintenance created by Ola Hallengren in a 1TB Database. EXECUTE [dbo].[IndexOptimize] @Databases = 'USER_DATABASES', @FragmentationLow = NULL, @...
3
votes
2answers
616 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 ...
0
votes
1answer
138 views

Ola Hallengren Index Maintenance with compressed indexes

If the Ola Hallengren index maintenance solution is installed onto a server which already has compression applied to several of the indexes, will the script respect the current compression level when ...
0
votes
2answers
78 views

Optionally exclude certain partitions using OLA's scripts

One scenario. I have been using OLA's scripts for a long time and love them. I have a very large database - 20+ TB with hundreds of partitioned tables. I purge old data by dropping (merging the old ...
1
vote
1answer
121 views

Index Maintenance for DW- DB ( ETL process )

I'm planning to set up a t-sql job to perform index maintenance in a DW DB (Stores data through an ETL process) currently overnight and eventually will need to be run more frequently as the business ...
0
votes
2answers
93 views

Rebuild Index Causing Data File Growth Issue

I have a database which is 200 GB in size and I have scheduled a Rebuild Index maintenance plan for all databases every Saturday at 2:00 AM. The job ran for 8 hours and then it failed. I knew while ...
1
vote
1answer
64 views

Log size is different between primary and secondary node with log_since_last_log_backup_mb

We get log backups from the secondary node. But now I see that log_since_last_log_backup_mb in sys.dm_db_log_stats returns null for databases which are in Availability groups, so Ola Hallengren's log ...
3
votes
1answer
204 views

Ola Hallengren Index Optimize - Skip “unused” Indexes

Is there a way to skip "unused" indexes based on the total reads of that index during an index maintenance w/ Ola's scripts? I understand that Index stats are only since the last restart, so ...
3
votes
3answers
356 views

Does Index Rebuild Reduces physical read from disk

Recently I have rebuild indexes uisng Ola Hallengreen script which were 99% fragmented. After rebuilt i have noticed the physical reads have reduced a lot. Does this has anything to do with Index ...
1
vote
2answers
140 views

Database Space Used Decreased after Index Rebuild (Ola Script)

I have rebuilt some indexes which were highly fragmented. After the index rebuild I am seeing my database space used reduced by almost 50% (from 77gb to 33 gb) Is that normal behavior? I dont have ...
1
vote
1answer
77 views

Ola Hallengren maintenance script - how can I tell a backup file is still being written to?

My question is whether there is a way to identify a backup file that is still being written to.​ I want to copy the completed backup files to another place. By reading the backup extension, I can't ...
0
votes
1answer
458 views

Ola Hallengren backup systax when excluding a database [closed]

I would like to backup most of the databases except the database DBA. I use below syntax in the job step: EXECUTE [dbo].[DatabaseBackup] @Databases = 'USER_DATABASES', '-DBA' @Directory = N'G:...
1
vote
1answer
96 views

Find outlier statistic in SQL server?

I have a stored proc which searches "bad" data in our application database (sql server 2016 enterprise, ~500gb data). "bad" in a business/process sense. It normally takes 10-30s to execute. After ...
0
votes
0answers
31 views

Does Change Tracking affect IndexOptimize?

For the past couple years we have had IndexOptimize run every Sunday morning without a problem, but now that we have turned on Change Tracking (for our new data warehouse) the utility seems to get ...
5
votes
1answer
97 views

Ola Hallengren: encrypt, but verify?

I've been using Ola Hallengren's scripts for a few years now, and a recent upgrade to MSSQL2017 has allowed me to start testing encrypted back-ups. Before anyone asks: yes, master keys and encryption ...
4
votes
2answers
246 views

Is it good practice to rebuild index on FileTable?

We are using Ola Hallengren scripts, both to backup our databases and for index maintenance. We have a FileTable in our database and from time to time, REBUILDING its PK index takes close to three (3) ...