Having a check on database owners is very important. You might hit a service broker problem and then realize that the root cause was a windows login of an ex-employee and it was set as the database owner. If you proactively track database owners, you will never meet such issues in your work environment.
Not DBO
In this article, we are dealing with database owner and not do or db_owner. DBO is a user, it’s a database concept and db_owner is a fixed database role.
Log it
From your central...
Read more »
SQL Server error log is the first place we search to identify and troubleshoot SQL Server issues. Whenever you call Microsoft SQL Server for any SQL Server issues you would be asked to share your SQL Server's Error log. In this article, we would learn how to centralize the monitoring of all SQL Server's Error log
The location
Before learning how to automate the Error Log monitoring, it is necessary to know the location of the log file. The first and easy approach is to identify the file...
Read more »
In this article we take a close look at several processes and phases that are typically encountered while performing a SQL Server recovery.
Sometimes, you may require to recover or restore data from a failure, and this has to be done in a sequential and logically correct form. Through the SQL Server recovery, you can recover an entire database, a data file, or just one date page. However, no matter in what way you restore it, you cannot recover it unless you roll it forward enough so that...
Read more »