Tag Archives: error log

Availability Group Fail Over date/time – TSQL

I have been using this quick script to verify AG Status Change details from error log.

Posted in High Availability, SQL, SQL Query, SQL Server, Uncategorized | Tagged , , , , , | Leave a comment

Easy way to find DBAMP Errors from the Log (sf_replicate, sf_refresh, sf_replicateAll, sf_refreshAll Errors)

Typically sf_replicateAll, sf_refreshAll procedures log all activities in DBAmp_Log table on the same database. Now the challenge is… I see about 1200 records in the table for each execution of sf_refreshAll! It takes long to find the actual error! Simple … Continue reading

Posted in knowledge, Script, SQL, SQL Query | Tagged , , , , , , , | Leave a comment

Knowledge Share 2014-06

• Can I change SQL Server Name/ Instance Name: o Yes, you can change SQL Server name. Especially when you rename your server name, it is good option to change your SQL Server name. o http://msdn.microsoft.com/en-us/library/ms143799.aspx is the article which … Continue reading

Posted in knowledge, SQL | Tagged , , , , | Leave a comment