I was supposed to have a second blog post up this week for SQL University, however I haven’t been feeling well and have been focusing my energy on my day job. Unfortunately, I’ve had to drop the ball on a few other things. My second SQL University post for the internals week is what got [...]
SQL Server 2008 (and 2005) contain five special databases: master, model, tempdb, msdb, and mssqlsystemresource (aka Resource). These databases are used by SQL Server for its own maintenance and management.
master
The master database contains all of the system level information for SQL Server – all of the logins, linked servers, endpoints, and other system-wide configuration [...]
What is the Error Log?
SQL Server maintains its own error logs that contain messages describing informational and error events.
These are simple text files stored on disk, but it’s best to view them using the facilities provided by SQL Server to prevent any SQL operations from being blocked by opening one of these files in [...]