Feroz DBA'S Blog

DBCC CHECKDB Generally in a very large database it's no feasible to run the check for complete database because it's a resource intensive, so we different option to check the health. Command-1: DBCC CHECKDB ('AdventureWorks2012') Output: DBCC results for 'AdventureWorks2012'. Service Broker Msg 9675, State 1: Message Types analyzed: 14. Service Broker Msg 9676, State 1: Service Contracts analyzed: 6. Service Broker Msg 9667, State 1: Services analyzed: 3. Service Broker Msg 9668, State 1: Service Queues analyzed: 3. Service Broker Msg 9669, State 1: Conversation Endpoints analyzed: 0. Service Broker Msg 9674, State 1: Conversation Groups analyzed: 0. Service Broker Msg 9670, State 1: Remote Service Bindings analyzed: 0. Service Broker Msg 9605, State 1: Conversation Priorities analyzed: 0. DBCC results for 'sys.sysrscols'. There are 1754 rows in 21 pages for object "sys.sysrscols". DBCC results for 'sys.sysrowsets'. There are 324 rows i...

  Types of system databases Introduction Each time you install any SQL Server instance on a server, by default/automatically 4 primary system databases are created. m aster model msdb tempdb     Master database It is a critical database, because SQL Server uses this database to store all the information about SQL Server instance, like ·         File location of the user database -> If you create any user database all the information and configuration details ·         Login accounts ·         Server configuration setting ·         Link Servers information ·         Start-up stored procedures If for any reason, master database is not accessible or doesn’t exist or can not be read then the SQL Server instance can not start. It’s important to backup the master database w...