6 votes

Is there any purpose of Ola Hallengren's SQL Server Index and Statistics Maintenance scripts on sql server running on SAN storage?

The "index optimize" job created by Ola's install script focuses on defragmentation, not statistics update. It will do: Nothing if the fragmentation level is below 5% REORG if it is between ...
5 votes

Is there any purpose of Ola Hallengren's SQL Server Index and Statistics Maintenance scripts on sql server running on SAN storage?

It is true that index fragmentation is mostly a thing in the past, if your database is architected properly, making index maintenance mostly moot these days, especially with modern hardware. One ...
  • 28.6k
4 votes
Accepted

Cannot Backup to Network Share using Ola Hallengren's Scripts

The Agent service account is irrelevant. You need to make sure that the database engine has relevant permissions. Either assign relevant permissions on the share to the Computer account in your domain,...
3 votes

Cross-domain backup using Ola Hallengren's scripts

Your best bet is to try and make the file share accessible to the service account that's running SQL Server. This is the easiest and most reliable method. But if you can't do that, this is the only ...
3 votes

Is there dbo for shrinking the Transaction Log?

DBCC SHRINKFILE does what you are looking for, but if you know the log will grow back again in a relatively short time then that probably isn't what you want. If it is going to grow back anyway you ...
3 votes

Is there any purpose of Ola Hallengren's SQL Server Index and Statistics Maintenance scripts on sql server running on SAN storage?

Your point about Statistics Maintenance is down to preference. SQL Does it automatically using its one-size-fits-all t-shirt. But if your statistics get too out-of-date on a small table, then it can ...
  • 1,068
3 votes
Accepted

How do I restore multiple transaction log backups after restoring a full backup SQLSERVER 2019

There are several methods for restoring database backups; the msdb database contains all the details you need. Having said that, since you're using Ola Hallengren's maintenance solution, you could ...
  • 68k
3 votes

Is there any purpose of Ola Hallengren's SQL Server Index and Statistics Maintenance scripts on sql server running on SAN storage?

My initial response to your interesting question was to look at the answer(s) and think: Hey, good answers..... However, after mulling it over for a bit, I came to a slightly different conclusion. ...
  • 15.7k
3 votes

How do I restore multiple transaction log backups after restoring a full backup SQLSERVER 2019

If PowerShell is an option for your script, dbatools' Restore-DbaDatabase cmdlet could be your friend. Restoring a full backup chain up to the latest transaction log can be as simple as: Restore-...
2 votes

Using Ola Hallengren's succeeds to take full backups but fails to take a differential

That error message is thrown when you try to execute a differential backup on a database before a full backup was taken. I tested it creating a new database named MyLab and issuing the following ...
  • 4,852
2 votes

Any possibility that Ola Hallengren could add a job name prefix option to the script that creates all the maintenance jobs?

If you want this to be included as part of the solution, maybe add a request to the GitHub repo for the Maintenance Solution. Alternatively, you can alter the deployment script for your particular ...
  • 9,592
2 votes

How do I restore multiple transaction log backups after restoring a full backup SQLSERVER 2019

As an improvement on the script provided by @HannahVernon, it is possible to do this without dynamic SQL. SET NOCOUNT ON; -- 1 - Initialize user variables DECLARE @dbName sysname = 'Customer'; ...
  • 8,316
2 votes

ola hallengren @databasesinparallel parameter on Azure SQLServer

The relevant code section from the IndexOptimize procedure shows there are two situations that can cause that error: IF @DatabasesInParallel NOT IN('Y','N') OR @DatabasesInParallel IS NULL BEGIN ...
  • 9,592
2 votes

DatabaseBackup backs up the same database twice?

Testing I downloaded the newest version of Ola's Maintenance.sql script and created the objects in my local laptop instance. I had to manually download the Queue.sql file and the QueueDatabase.sql ...
  • 15.7k
2 votes

Order of execution in Ola Index maintenance and Stats collection

These don't need to be done as separate steps. In fact, it would be much harder to do as separate steps, as you would want to filter out any indexes rebuilt in your Step 1, to avoid duplicate work in ...
  • 15.6k
1 vote

ola hallengren on Azure SQL

there are two options that filter the indexes to be rebuilt/reorganized. MinNumberOfPages Set a size, in pages; indexes with fewer number of pages are skipped for index maintenance. The default is ...
  • 3,872

Only top scored, non community-wiki answers of a minimum length are eligible