Tag: MSDB Database

SQL Server 2012 – Get Backup History of the database

SQL, SQL-Advanced, SQL-Backup & Restore, SQL-Server 2012, Varinder Sandhu

The msdb database is system database used by SQL Server Agent for scheduling alerts and jobs. msdb.dbo.backupset – Contain the information concerning the most-granular details of the backup process msdb.dbo.backupmediafamily – Contains the metadata for the physical backup files as they relate to backup sets Using the above mentioned tables,

» Read more
, , ,

SQL Server – Understanding the System Databases of SQL Server

SQL, SQL-Advanced, SQL-General, Varinder Sandhu

We all know there are some system databases available in SQL Server. But we should have understanding about system databases. Here just try to give you understanding of system databases very briefly. There are four system databases available in SQL Server 2008 Master Model msdb tempdb Master Database The master

» Read more
, , , , , , ,