Solved

SQL Server Error Log - logging period

Posted on 2016-11-28
1
32 Views
Last Modified: 2016-11-29
Hi experts
i am reading about: SQL Server Error Log
what's the mean?
Review all the available log files; a problem may not have started in the current logging period
0
Comment
Question by:enrique_aeo
1 Comment
 
LVL 24

Accepted Solution

by:
Pawan Kumar earned 500 total points
ID: 41905106
SQL Server error log has user-defined events and few system events you may want for troubleshoot.
How to view the logs -- <<https://msdn.microsoft.com/en-us/library/ms187109.aspx>>

Review log files - MS SQL Server <<>>
https://docs.mendix.com/refguide5/review-log-files-ms-sql-server

Review all the available log files; a problem may not have started in the current logging period
It means if your current log file is new then you will also have to view old log file to see if there is any problem mentioned by the SQL Server. That's why we have to review all the SQL Server Error Log files.

Hope it helps !
0

Featured Post

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Params not declared?  T-SQL syntax question 3 38
IN with @variable 5 25
Joining Two Tables In SQL and combining records 6 52
the whoisactive update 12 39
Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
This is a video describing the growing solar energy use in Utah. This is a topic that greatly interests me and so I decided to produce a video about it.
A company’s greatest vulnerability is their email. CEO fraud, ransomware and spear phishing attacks are the no1 threat to a company’s security. Cybercrime is responsible for the largest loss of money to companies today with losses projected to r…

919 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now