Error log Archives - Tomas Lind

Microsoft SQL Server

SQL Server recovery time

Post author:Tomas Lind
Post published:2015/10/27
Post category:Error log Failover Cluster System Stored Procedures
Post comments:0 Comments

SQL Server Recovery time is the time it takes for SQL Server to rollback or roll-forward transaction not yet persisted to the database after a service restart. Transactions that are uncommitted are rolled back, and transactions that are committed but not yet persisted are rolled forward.

Depending on the volume of transactions that needs to be handled during recovery, recovery may take a long time to perform. This affects the time it takes for a SQL Server restart. Another example when recovery times become a factor is when a failover is done in a SQL Server cluster.

So how can we know how long the recovery time will be?

(more…)

Microsoft SQL Server

Reading the SQL Server error log with T-SQL – xp_readerrorlog

Post author:Tomas Lind
Post published:2014/04/22
Post category:Error log
Post comments:0 Comments

SQL Server keeps a configurable number of error log files as text files on disk. So you can’t simply use T-SQL directly to read those text files. Instead you can use the system stored procedure xp_readerrorlog.

(more…)

Microsoft SQL Server

SQL Server error log location

Post author:Tomas Lind
Post published:2014/04/17
Post category:Configuration Error log
Post comments:0 Comments

The SQL Server service keeps its own error logs outside of SQL Server in a number of text files. The location of the SQL Server error log is specified in a startup parameter for the SQL Server service.

(more…)