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.

34 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
2
votes
2answers
89 views

dbcc checkdb runs for interminably long time, 50% of the time

I've got a nightly maintenance job (largely taken from the ola hallengren maintenance package) that runs database backups and runs an an integrity check on every database. The integrity check part ...
2
votes
1answer
53 views

ola-hallengren backup solution with encryption is not encrypting

Installed OH's scripts and they run great. sqlserver 2017 standard edition in a testing/dev environment. testing before rolling out to production. I did a test of a restoration of an encrypted, or so ...
2
votes
0answers
174 views

Index rebuild blocks itself and runs in serializable isolation level

I’ve implemented Ola Hallengren maintenance solution in one database, and I’m noticing that it’s getting blocked by itself, I don’t know why honestly. What I have noticed, is that it seems to be run ...
2
votes
0answers
767 views

Log Shipping and Ola's Hallengren's Scripts - Can they work in unison?

I have a single instance database server with several databases. Some do not require log shipping and some do require log shipping. Is there a way to edit Ola's LOG backup job to ignore the ...
2
votes
0answers
144 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 ...
2
votes
0answers
750 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'...
1
vote
1answer
104 views

How can I capture error thrown by SET_LOCKTIMEOUT in ola Hallengren

A stats only job for Ola Hallengren was blocked for the 180 seconds as specified below. The job threw an error and emailed me and the other DBA. However, upon review of the CommandLog table and the ...
1
vote
0answers
235 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
0answers
1k views

Ola Hallengren Backup - stuck at 100% complete

Full Backup started on 4/21 12 AM. While backing up one of the database, it is stuck. sp_WhoIsActive shows following information wait_info: (1208ms)PREEMPTIVE_OS_WAITFORSINGLEOBJEC CPU - 188,528,...
1
vote
0answers
363 views

HowTo: [Output File Cleanup] workaround for UNC targets

Hallengren job [Output File Cleanup] silently fails when the output file directory is a network file share. Question: Is there a better, cleaner way to resolve the issue detailed below when the job ...
1
vote
0answers
145 views

Customize - Ola Hallengren script

Trying to incorporate Date wise folder in the script. Following is the original code INSERT INTO @CurrentDirectories (ID, DirectoryPath, Mirror, DirectoryNumber, CreateCompleted, CleanupCompleted) ...
0
votes
1answer
24 views

ola-hallengren running full backups and log backups at the same time— restore issues?

I recently ran across an issue trying to restore a db and log files. DB restored without issues. About 10 log files in, I received a message stating the LSN was out of sync and could not finish. I ...
0
votes
1answer
24 views

Ola Hallengren's SQL Server Maintenance Solution & CMD Syntax

I'm using the free version of SQL Server Management Studio so I have to use CMD to call the SQL scripts. The official page gives an example of the CMD syntax used to call the "DatabaseBackup&...
0
votes
1answer
24 views

Error log folder location and OLA's SQL maintenance solution

Looking at one of our dev sql servers, it has a -e startup parameter to define the error log folder at this location : E:\DATA\MSSQL13.MSSQLSERVER\MSSQL\Log\ERRORLOG. However, only E:\DATA\MSSQL13....
0
votes
0answers
15 views

Create a backup daily and incremental every hour

How can I create a full backup every day, using Ola Hallengren's solution, suppose at 8AM and, after that, an incremental backup every hour. This processe should be repeat the process ever day. I what ...
0
votes
0answers
13 views

Ola Backup script is picking up the cluster as the host

I have a SQL server that has local databases and some databases in an AG group and getting an error "Unknown host " when I run the following Ola backup script. EXECUTE [dbo].[DatabaseBackup] ...
0
votes
0answers
28 views

Ola Backup scripts, How do you specify a different filename for the mirrored set?

I'm using the backup script below as a test. I want to use a different file name for the mirror. The format should be @FileName = '{ServerName}-DEFAULT-{DatabaseName}-{BackupType}-MIRROR_{FileNumber}....
0
votes
1answer
85 views

Ola Hallengren's backups scripts, cleanup only mode

Is it possible to run Ola Hallengren's backup scripts in cleanup only mode? I have a couple of servers where the cleanup time was set too long, and I now have to clean up hundreds of databases worth ...
0
votes
0answers
34 views

update stats on specific statistic not working?

I am using Ola Hallengren's maintenance solution and have come across something really strange. I grabbed the command from the log table as below: UPDATE STATISTICS [dbo].[APIActivityLog] [...
0
votes
0answers
101 views

Ola Hallengren’s SQL Server Maintenance Solution using a different user

I am looking at using Ola Hallengren’s SQL Server Maintenance Solution to create a backup plan. However, I cannot figure out how to run the Agent Job (T-SQL script) as a different user as the ...
0
votes
0answers
120 views

Differential backup failing - Ola Hallengren Script

So I have installed Ola Hallengren's maintenance solution on our SQL 2016 servers. I have set the differential backups to take place every evening 7pm and full backup is scheduled for once a week. ...
0
votes
0answers
298 views

RESTORE VERIFYONLY FROM DISK is failing

We are having WSFC(Windows Server Failover Cluster) configuration for one of database server and from last few days, backup of one of the database is failing. Sometime backup itself fails whereas on ...
0
votes
0answers
48 views

IndexMaintenance fails on error

We are using the Index Maintenance of Ola Hallengren (https://ola.hallengren.com) solution for a couple of years now. While setting up some new SQL servers we are seeing some strange behaviour in the ...
0
votes
0answers
412 views

I can not Ola Hallengren database backup script to Data Domain make works

Ola Hallengren has a nice SQL Maintenance scripts that I installed to our dev SQL server. The backup script works very well to a local drive, however it does not work to Data Domain. At all. Here is ...
0
votes
0answers
109 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
145 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
1answer
77 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 ...
0
votes
0answers
628 views

Backupthread Wait backup with ola.hallengren solution

I am running SQL 2014 Enterprise. It’s about a 6 TB db. It is mirrored and not clustered. It is a 48 core physical server with a 3par SSD storage. When I run the backup job manually, it sometimes ...
0
votes
0answers
245 views

Deadlock on SQL Agent job running IndexOptimize job from Ola Hallengren's script but still says job succeeded

Deadlock message from Idera SQLdm: 7/7/2017 4:24:02 AM, Deadlock on ServerName is Warning. A deadlock occurred on server ServerName. Full details are available in the SQLdm Desktop Client. The ...
0
votes
0answers
113 views

Folder permissions changing when running Ola Hallengren maintenance scripts

We use a centralized backup location on a network share. Each instance uses the Ola Hallengren scripts to perform nightly backups. I have a team that requires folder permissions to the same location ...
-1
votes
1answer
101 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
votes
1answer
151 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?
-1
votes
1answer
335 views

SQL Maintenance script not running with SQL Server Express

Hello and thank you for making such a well-designed script available to the public. I have client with some heavy db fragmentation and performance issues. I would like to use your scripts to help ...
-2
votes
1answer
336 views

DBCC CHECKDB last good date

SQL Server 2014 Standard. Using Ola's (blessings be upon him) scripts to perform database integrity checks: Job command: sqlcmd -E -S $(ESCAPE_SQUOTE(SRVR)) -d master -Q "EXECUTE [dbo].[...