Skip to content

Transaction Logs vs Error Logs in SQL Server 2012

by on March 24, 2014

Sql Server Transaction Logs

Each DB will have it’s own transaction log. This log will record transactions (ie, adds, deletes, changes) and modification caused by each transaction. You may want to be careful with where you store your logs, as they can grow quickly – so set your size to something reasonable. Do not delete or remove it, as it is necessary for recovering a database to a specific point in time.

SQL Server Error Logs

The Log files are used to record issues and errors for SQL Server. There are both user defined and system defined errors that can be written to the logs and many applications write their own errors. All Server logs are saved to the same log files. Events such as login errors might be logged here.

Sql Server Management Studio > Object Explorer

Expand server_name > expand Management

Expand SQL Server Logs > right click a logimage

Select > View SQL Server Log

image

Advertisements
Leave a Comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: