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.
Posts
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