Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Event viewer errors on server? Expand / Collapse
Author
Message
Posted Thursday, May 21, 2009 10:27 PM


SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, April 20, 2011 6:43 AM
Points: 99, Visits: 243
Hi Everybody,

I am presently new to the SQL DBA role. I had a daily checkup on "Event viewer errors". Can U let me know what are the types of errors recorded during connection and working with Database?

What are the steps have to take to over come these errors and where can i get the solutions for the errors?

Thank U all,


Venu Gopal.K
Software Engineer
INDIA
Post #721826
Posted Friday, May 22, 2009 9:43 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Monday, September 29, 2014 2:44 PM
Points: 3,475, Visits: 583
The best way is to make yourself familiar with the Event Log records (Errors - red, Warnings - yellow, Informational messages - blue) is to run SQL Server and take note what are normal messages when running SQL Server. - startup messages, shut down messages, other messages.
Everything with the Red Dot is an error and has to be looked up in SQL Server Books Online at
http://www.microsoft.com/sql
http://msdn.microsoft.com/en-us/library/ms130214.aspx
just enter the error message into the search box and look what solutions are suggested.



Regards,
Yelena Varshal

Post #722155
Posted Friday, May 22, 2009 10:51 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, June 12, 2009 4:15 AM
Points: 21, Visits: 31
hi,

yes, it's required sometimes checking the event viewer, because event viewer records every movement happed at os level, you need go though the sites first to understand the errors.

Goodluck
KingManjunath
Post #722230
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse