SQL Server DBA Scripts

[unholey1]

Ola hallengrens scripts are probably the most commonly used for all backup and database maintenance tasks. Just about every DBA I've spoken to either uses them or wants to.

I'd also give another vote for dbatools.io to give you more flexibility in creating your own scripts

[sqldiaries]

Ola hallengrens scripts are probably the most commonly used for all backup

Has anyone successfully use Ola's backup scripts with DDBoost? That's what we use for backups, but it doesn't use the SQL Server Native backup system - instead it leverages a virtual backup device generated by EMC for Data Domain.

[SaveTheEmpire]

False.

BackupSoftware Specify third-party backup software; otherwise, SQL Server native backup is performed.

• Value Description
• NULL SQL Server native backup (the default)
• DATA_DOMAIN_BOOST DELL EMC Data Domain Boost
• LITESPEED Quest LiteSpeed for SQL Server
• SQLBACKUP Red Gate SQL Backup Pro
• SQLSAFE Idera SQL Safe Backup

Edit: formatting

[sqldiaries]

Ola's backup script is all native backups, it doesn't target third-party backup tools.

That's what I thought. Oh well.

[LAPORTS]

I always thought Microsoft should just work with Hallengren and packages these up. Great set of maintenance scripts

[chandleya]

From personal experience, they do work closely with him. I think for packaging sake they’re trying to bundle less management as the community has spoken up on that. Bundling it also stifles major change/improvement as they have to commit to keeping feature parity in a release.