Skip to main content

Resource Database in SQL Server



Resource DB having below properties:

1. Read only DB
2. Contains system objects
3. Does not contain any user objects
4. Physical name of the DB
                              









5. Each SQL Instance having only 1 Resource DB.
6. DB id of Resource DB always 32767
7. DB backup is not possible of Resource DB.



Comments

Post a Comment

Popular posts from this blog

SQL Browser Service

SQL Browser Service SQL browser service runs as a Windows Services on the windows machine. Start and Stop SQL Browser Services It's possible using SSCM or Windows services.. From SSCM From Windows Services Use of SQL Browser Services: It listin all the incoming request which come for server resources and provide information about SQL instances that are installed on the machine. Below are the task of SQL browser:   1. Browsing the available SQL Servers.   2. Connect to the correct SQL instance.   3. Connect to DAC (Dedicated Admin Connection) . By Abhishek Yadav
Post a Comment
Read more

Deadlock and Deadlock Types in SQL Server

Hello All, Deadlock in SQL Server: Deadlock is a situation where two or more transactions wait for completion of each-other for resources but none of them completes. In SQL Server, deadlock-detractor thread monitors the deadlock situation. Once the situation  occurs, SQL Server rollback  the transaction which is less expensive with error message " Aborted Transaction error message 1205 " and roll-forward the transaction which is more expensive compare to the other one. Types of Deadlocks in SQL Server:  In SQL Server, there are 6 types of deadlocks are there... 1. Read-Write Deadlock 2. Write-Write Deadlock 3. Parallelism Deadlock 4. Key Lookup Deadlock 5. Rang-scans and Serializable Deadlock 6. Partition Escalation Deadlock
Post a Comment
Read more

SQL Server 2008 R2 IA64 and x64.

MS has released SQL Server 2008 R2 for 64 bit architecture in two avatar x64 and IA64. x64 is the general 64-bit architecture, but Intel developed an alternative architecture known as IA64 Itanium Processors.   It was designed as a high-end alternative to mainframes, but the platform didn’t have very many production implementations of SQL Server and has subsequently been dropped from SQL Server 2012.  Windows has also dropped support for IA64 with the release of Windows Server 2012, which runs only on x64.
Post a Comment
Read more