MikeBennyhoffMar 23, 20236 min readAlerts 19-25In SQL Server, Alerts are used to monitor specific events or errors that occur within the SQL Server engine, and the severity levels 19...
MikeBennyhoffMar 23, 20234 min readLog Backups For Databases Set To Full Mode**If you have a database that is set to full mode but does not have Transaction-log backups you need to create or take Transaction-log...
MikeBennyhoffMar 22, 20235 min readSetting Failure Alerts and Fail safe Operators on SQL Agent JobsSetting up failure emails on jobs can be an important step in ensuring that you are promptly notified of any issues with your jobs. Here...
MikeBennyhoffMar 22, 20234 min readWhat is database ownership ?Database ownership in SQL Server refers to the security principal that has control over a particular database. The database owner is a...
MikeBennyhoffMar 22, 20234 min readSnapshot Backups In SQL ServerIn SQL Server, a snapshot backup is a type of backup that creates a read-only copy of a database at a specific point in time. Unlike...