msdb

SQL Server MSDB Database Tutorial

  • Article

In this tutorial we will cover common questions related to the SQL Server msdb database. This is one of the standard system databases that are part of every SQL Server installation. This tutorial will give you a better idea of what the msdb database.

2020-07-23

The Importance of Maintenance on MSDB

  • Article

MSDB is a system database used by SQL Server. MSDB stores all sorts of data, such as backup history, log shipping monitor history, SSIS packages and Service Broker queue data to name a few. Just like user databases, MSDB needs regular maintenance, including index optimizations and, more importantly, regular purging. In this article, Tim Radney looks at how neglecting your MSDB can negatively impact on your environment.

2015-07-28

6,714 reads

Controlling Growth of an msdb Database

  • Article

I recently encountered a situation where the drive hosting Sharepoint Databases in a Staging environment ran out of space. I logged onto the server and found that the msdb database has itself occupied 38 GB of the total disk space. Msdb database generally contain maintenance information for the database such as backups, log shipping and so on.

2012-01-25

2,711 reads

SQL Server user defined function to convert MSDB integer value to time value

  • Article

In a recent tip I outlined a process for converting a date, stored as an integer into a datetime data type. Date and time information for run history of SQL Server Agent jobs is stored within the msdb..sysjobshistory table as an integer data type, not as a datetime as one would expect. As promised, this tip picks up where we left off. On converting the integer-typed run_time into a format that is more user friendly for presentation purposes.

2009-05-20

2,522 reads

Blogs

Last Week Reading (2020-08-02)

By

Press ADF Release Notes 07/31/2020 I believe this is the first Release Notes from...

Online certification exams are definitely different

By

As you can tell from previous posts, I’ve taken a few Microsoft Certification exams...

Office Upgrade – A Secret Lab Chair

By

Last year I wandered over to Glenn Berry’s house for some lunch and a...

Read the latest Blogs

Forums

Offline Files

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Offline Files

Confidential VMs

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Confidential VMs

Change the Instance Collation by Rebuilding Databases in SQL Server 2017

By iLearnSQL

Comments posted to this topic are about the item Change the Instance Collation by...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Offline Files

See possible answers