Question : Have a server with regular db backups but strangely sp_delete_backuphistory has never been scheduled so msdb is bigger […]
Tag: msdb
Fixing a query that returns failed job information
Question : I’ using a SQL Server 2008 Sp3 environment. I have a query that returns information about failed jobs […]
sysschedules datatype choices
Question : I am curious, why does SQL Server save the values in msdb.dbo.sysschedules for date and times as int […]
Why does msdb.dbo.backupset have entries for each database every 15 minutes?
Question : I have 134 separate databases on a SQL Server. Every 15 minutes an entry appears in the msdb.dbo.backupset […]
SQL Server Installer appears to be resetting MSDB Recovery Mode to Simple
Question : Everytime we upgrade a SQL Server installation (service pack or cumulative update), msdb is changed from FULL recovery […]
Log Shipping: Bulk Remove Alerts of already deleted primary and secondary databases
Question : I’m facing a rather strange issue with Transaction Log Shipping reports in SSMS which is showing multiple red […]
MS SQL Server Incremental(differential) backup interrupted due to Full backup
Question : I have a manual full backup happening every night, post which I am taking differential backup after every […]
Analyst MSDB Access SQL Server 2017
Question : i’m an accidental DBA for a company and having trouble figuring out this permissions situation. We have a […]
What does “_localserver_view” mean after an MSDB Database table
Question : What is equal to the database table [msdb]. [dbo]. [sysschedules_localserver_view], which contains the suffix _localserver_view? I am having […]
Recovery_model for backupset table null sqlserver
Question : Going through https://www.sqlshack.com/understanding-database-recovery-models/ I see that there are three types of recovery models: SIMPLE FULL BULK_Logged But for […]