Home Menu
  • Home
  • About – Tomas Lind
  • Contact
  • Blog Series
    • Technical Analysis (TA)
  • T-SQL
    • T-SQL Scripts
    • Templates
  • Consulting Services
  • Software
Tomas Lind

Posts in Category ‘Error log’

  • 2015/10/27
  • 0 comments

SQL Server recovery time

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 … Read more →

  • Posted in: Error log, Failover Cluster, System Stored Procedures
  • 2014/04/22
  • 0 comments

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

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.

  • Posted in: Error log
  • 2014/04/17
  • 0 comments

SQL Server error log location

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.

  • Posted in: Configuration, Error log

confided data manager

Get compliant with the GDPR!


High Coast Database Solutions

High Coast Database Solutions

sql server consulting services


Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Top Posts & Pages

  • How to align columns in Notepad++
  • Export data from Excel to SQL Server
  • Manual failover in a SQL Server cluster
  • Sending HTML tables in mail from SQL Server
  • List SQL server roles by users

Recent Posts

  • Get element max value from folder with XML files
  • Dynamic Data Masking (DDM) – Mask query results
  • The T-SQL Merge statement
  • From SQL Server to MSMQ using PowerShell
  • Identity columns that are about to overflow

Archives

Categories

Meta

  • Log in
  • Entries RSS
  • Comments RSS
  • WordPress.org

Instagram

Load More...
Follow on Instagram

  • © 2019 Tomas Lind
  • Proudly powered by WordPress
  • Theme: Waipoua by Elmastudio
Top ↑