Search type Search syntax
Tags [tag]
Exact "words here"
Author user:1234
user:me (yours)
Score score:3 (3+)
score:0 (none)
Answers answers:3 (3+)
answers:0 (none)
isaccepted:yes
hasaccepted:no
inquestion:1234
Views views:250
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Favorites infavorites:mine
infavorites:1234
Status closed:yes
duplicate:no
migrated:no
wiki:no
Types is:question
is:answer
Exclude -[tag]
-apples
For more details on advanced search visit our help page
Results tagged with Search options user 35136

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
The parameters have to be identical for all the 4 jobs. Cold you try changing all the jobs like this: @Databases = 'USER_DATABASES'
answered Nov 11 '18 by Ola Hallengren
2
votes
The current design is that the stored procedure will decide if the database should be backed up. Only if the database should be backed up, it will go into the code that does the work (creates sub-dire …
answered May 16 '18 by Ola Hallengren
1
vote
You can check out "How should I configure DatabaseBackup to back up an Availability Group?" on https://ola.hallengren.com/frequently-asked-questions.html
answered Oct 15 '16 by Ola Hallengren
0
votes
I have released a new version that has a check for suspect databases. https://ola.hallengren.com/versions.html
answered Mar 22 '18 by Ola Hallengren
3
votes
I can't see that you are using backup to URL. It looks like a local drive and a file share. If you read about mirrored backups you see that there are some special requirements: "Mirroring applies bo …
answered Apr 22 '15 by Ola Hallengren
2
votes
If you are on SQL Server 2016 SP2 or later, you could use the new smart transaction log functionality. That could trigger frequent log backups, when a lot of transaction log is generated (e.g. during …
answered Jun 6 '18 by Ola Hallengren
5
votes
I have added support for striping of backups to Azure Blob Storage. https://ola.hallengren.com/versions.html Here is how it works: EXECUTE dbo.DatabaseBackup @Databases = 'USER_DATABASES' , @URL = …
answered Mar 28 '18 by Ola Hallengren
27
votes
I recommend that you have the jobs enabled and scheduled on both servers and with the same configurations. Databases that are in a mirror role will automatically be skipped. There are checks for that …
answered Mar 4 '14 by Ola Hallengren
1
vote
I have added support for BLOCKSIZE, and MAXTRANSFERSIZE, when backing up to Azure Blob Storage block blobs (using Shared Access Signature). https://ola.hallengren.com/versions.html
answered Mar 28 '18 by Ola Hallengren