I'm running SQL Server 2008 R2 and have it set to start the service in the background on startup of the machine. When this happens, what is the process that it goes through to startup?
I believe that the master database loads first, but what order do the other databases load in? How is this determined?
EX: I have databases a1,b1,c1. Does a1 load before c1?
How would I go about setting the priority of a database (e.g. load c1 before b1...)?
I'm looking for a behind-the-scenes look into what happens when the program starts, I am not running any queries on it. Thanks.