Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rohitmathur11
Yak Posting Veteran
77 Posts |
 Posted - 2009-11-29 : 23:21:37
|
| Hi,I just start working on sql server 2008.I want to that is there any log file it maintain where we can find errors ..what is happening in database ..type log file. Like in oralce we have alert_log file..every error ..database activity is recoderd in this file.. So ..where is this file in sql server 2008 ...name ..location.. can any one tell me ..? |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2009-11-30 : 02:09:48
|
| That'll be the error log. May not be completely equivalent to the Oracle one.In management studio you can access it via Object Explorer, Management-> SQL Server LogsIn the filesystem, it'll be called ERRORLOG (and the older ones ERRORLOG.1, ERRORLOG.2, etc). Where they are depends on the settings at install, but a search will find them.--Gail ShawSQL Server MVP |
 |
|
|
|
|
|
Log files