January 5, 2009 at 6:00 am
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......) .
January 5, 2009 at 6:16 am
There is no other place then default log location.
Regards,
Nitin
January 5, 2009 at 6:24 am
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.
January 5, 2009 at 11:04 am
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.
January 6, 2009 at 7:05 am
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?
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply