Category Archives: Database Administration

Restore history

For MSDB Restorehistory column restore_date, the SQL documentation claims that this means “Date and time of the completion of the restore operation.”  However, this doesn’t appear to be the case.  It shows the start time. This is bad, because I’m … Continue reading

Posted in Database Administration | Tagged , , , | Leave a comment

Easy error Log checking

At first at my current job as a DBA, I was not checking SQL Server error logs every day.   Then I started checking production daily to crack down on deadlock issues.  But I was not checking all of the … Continue reading

Posted in Business Intelligence, Database Administration | Tagged , , | Leave a comment

Cluster resource sql server agent failed

The SQL Server Agent service would not come up on the 2nd node. The reason ended up being that the SQL Agent Resource was set up as a Generic Resource.  A Generic Resource is setup as a single server Resource. … Continue reading

Posted in Database Administration | Tagged | Leave a comment

Large sys_mailitems fix

I have a customer with an MSDB database that had grown to 40 GB.  After looking into it, I found that the table sys_mailitems was large. There are some “fixes” out there to look at the sent_date and delete data … Continue reading

Posted in Database Administration | Tagged | Leave a comment

SQL Server error 3417

I have a customer who could not start their SQL Server. It was showing error 3417 on startup. There is not much info out there about 3417, and what I saw wasn’t very helpful in our situation.  The folder and … Continue reading

Posted in Database Administration | Tagged | Leave a comment

Change what is returned by @@SERVERNAME on cluster

I have not tested this, but I believe to change what is returned by @@SERVERNAME, you go to 1) Failover Cluster Manager 2) Expand Services and applications on the left pane 3) Click on SQL Server on the left pane … Continue reading

Posted in Database Administration | Tagged | Leave a comment

Remove Data Collection objects

In SQL Server, I tried out the Management Data Warehouse, and didn’t need it anymore.  There isn’t any provided way to remove the objects that were created. This is the most helpful article I’ve found to help me to remove … Continue reading

Posted in Database Administration | Leave a comment