Resource database in sql server

Resource database is read only database includes all Sql server system objects. Resource database deals with sql server system Meta data whereas master database contains user metadata. It is use for compatibility changes that why it is not accessible to user. Resource database makes sql server version upgrade much faster where as in old version ...

SQL Server – Service did not respond in a timely fashion – Start-up Parameter changed

Every time, Sql server starts it looks for master database that act as heart of sql server engine without master database, Engine will stop working. Lets check whether sql server will come up without master database or not. So for this, we made some changes in log file location of master database using start-up parameter ...