Then I would recommend, not doing differential backups for this database.

One common cause of this issue, is that you have some VSS based backup that is backing up the...

This looks strange. Which version of SQL Server is this?

Could you send me the complete output - file and error log?
https://ola.hallengren.com/contact.html

I have released a new version of the script with support for striping of backups to Azure Blob Storage, MAXTRANSFERSIZE, and BLOCKSIZE.
https://ola.hallengren.com/versions.html

Could you please download...

When I developed the scripts I was looking at how Microsoft was doing in the Maintenance Plans. They are not doing checkdb for tempdb, so I did also not do...

In the latest version you can do like this:

EXECUTE dbo.DatabaseIntegrityCheck @databases = 'SYSTEM_DATABASES,tempdb', @CheckCommands = 'CHECKDB'

Please send me a mail for more details.

Ola Hallengren

https://ola.hallengren.com

This is by design. DatabaseIntegrityCheck is not doing checkdb on tempdb.

Ola Hallengren

http://ola.hallengren.com

If you would like the full backups to be performed on the secondary server as well, you can add the option @CopyOnly = 'Y' to the full backup jobs.

(I don't...

I calculate the cleanup time before I start backing up the database. The reason for that is to protect against a scenario where you delete a backup that you have...

Here is an interesting blog post about sys.system_internals_partition_columns.

http://www.sqlskills.com/blogs/paul/how-are-per-column-modification-counts-tracked/[/url]

Regarding sys.sysindexes that contains information not only about indexes, but also about column-statistics.

Ola Hallengren

http://ola.hallengren.com

Have a look at sys.dm_db_stats_properties

http://msdn.microsoft.com/en-us/library/jj553546.aspx

Ola Hallengren

http://ola.hallengren.com

I do not recommend changing this for the reasons that I have described, but you are free to change the script as you like.

Ola Hallengren

http://ola.hallengren.com

Default the parameter for high fragmentation is set like this:

@FragmentationHigh = 'INDEX_REBUILD_ONLINE,INDEX_REBUILD_OFFLINE'

This means that it will rebuild an index online if that is possible. If that is not possible, it...

What version and edition are you running? (Do a SELECT @@VERSION.)

Could you script out the table and post that?

In my script I am using Continue just as a column alias.

For more general questions about T-SQL I think that it is better if you start a new thread.

Ola Hallengren

http://ola.hallengren.com