Ola Hallengren comments

Results 144 comments of


                                            Ola Hallengren

SP DatabaseBackup: compress not accepted

Is this issue still happening?

SP DatabaseBackup: compress not accepted

I am not able to reproduce it, with the version and edition that you have. Could you try to enable the check again? If you get the error, please post...

CHECKTABLE integrity check fails if there is a single quote mark (') in table/schema name

I have tested this, but I am not able to reproduce it. Could you post the complete output?

AG Group Backups Log Failures - File being used by another process.

Could you send me the full output from dbo.DatabaseBackup from both servers? Could you run this on both replicas? ```SELECT sys.fn_hadr_backup_is_preferred_replica ('DatabaseName')```

AG Group Backups Log Failures - File being used by another process.

Could you also try updating to the latest CU? Do you still have the issue?

AG Group Backups Log Failures - File being used by another process.

I was looking at this again. DatabaseBackup is using sys.fn_hadr_backup_is_preferred_replica, to only do the backup on the preferred backup replica. In your case that should be the secondary replica. I...

AG Group Backups Log Failures - File being used by another process.

Are you still having this issue?

SQL DB maintenance on SQL server 2019 Big Data Cluster

I have not tested the scripts on Big Data Cluster.

"Could not read the drive '\\.\NUL\'" when using Litespeed to backup to NUL

Could you attach the output - file? You can also send it to me in a mail.

"Could not read the drive '\\.\NUL\'" when using Litespeed to backup to NUL

@johntrollope, thank you. Do you know what the correct syntax is to perform a backup to NUL in LiteSpeed?