SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


location for the error log in MS SQL Server 2000


location for the error log in MS SQL Server 2000

Author
Message
nivedita.kathal
nivedita.kathal
Mr or Mrs. 500
Mr or Mrs. 500 (570 reputation)Mr or Mrs. 500 (570 reputation)Mr or Mrs. 500 (570 reputation)Mr or Mrs. 500 (570 reputation)Mr or Mrs. 500 (570 reputation)Mr or Mrs. 500 (570 reputation)Mr or Mrs. 500 (570 reputation)Mr or Mrs. 500 (570 reputation)

Group: General Forum Members
Points: 570 Visits: 51
Hi,

I am working in MS SQL server 2000, I run the DBCC command in the server first time. Can any one please suggest me where the error log can be generated(except the default location i.e. C:\Program Files\Microsoft SQL Server\instance of SQL\MSSQL\LOG......) .
nitinpatel31
nitinpatel31
Hall of Fame
Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)

Group: General Forum Members
Points: 3533 Visits: 295
There is no other place then default log location.

Regards,
Nitin
nivedita.kathal
nivedita.kathal
Mr or Mrs. 500
Mr or Mrs. 500 (570 reputation)Mr or Mrs. 500 (570 reputation)Mr or Mrs. 500 (570 reputation)Mr or Mrs. 500 (570 reputation)Mr or Mrs. 500 (570 reputation)Mr or Mrs. 500 (570 reputation)Mr or Mrs. 500 (570 reputation)Mr or Mrs. 500 (570 reputation)

Group: General Forum Members
Points: 570 Visits: 51
But while searching for the LOG directory in the C:\Program Files\Microsoft SQL Server\MSSQL(where the error logs gets save) i didn't got any LOG folder.
Since the server is production database server ,there may be a possibility that the errorlog files gets stored in some other drive.
So could you please suggest me what is the way to get the path for the error log.
Steve Jones
Steve Jones
SSC Guru
SSC Guru (688K reputation)SSC Guru (688K reputation)SSC Guru (688K reputation)SSC Guru (688K reputation)SSC Guru (688K reputation)SSC Guru (688K reputation)SSC Guru (688K reputation)SSC Guru (688K reputation)

Group: Administrators
Points: 688770 Visits: 21594
The startup parameter (-e) for the service determines the log location.

Please post in the correct forum. Not just anywhere.

Moved to the 2000 forum.

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
gary.proctor
gary.proctor
SSC-Addicted
SSC-Addicted (406 reputation)SSC-Addicted (406 reputation)SSC-Addicted (406 reputation)SSC-Addicted (406 reputation)SSC-Addicted (406 reputation)SSC-Addicted (406 reputation)SSC-Addicted (406 reputation)SSC-Addicted (406 reputation)

Group: General Forum Members
Points: 406 Visits: 96
Howdy,

In SS05 you can get SSIS to log to a table instead of a text file if that would be easier. It logs information to a NON-sys table in the database. The table is automatically named dbo.sysdtslog90. Would that be easier to work with?
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum









































































































































































SQLServerCentral


Search