SQL 2005 Error logs, path change to network drive.

I need to move the error log folder from my local box to a mapped network drive. The error logs are to be reviewed by a seperate department. Allowing access to the mapped drive will spare the SQL box in storing so many logs. Question is how do I change the drive where the logs are saved too, and changing them to allow me setting any network path I choose. I am using SQL 05 SP3.
itnetworksAsked:
Who is Participating?
 
Anthony PerkinsConnect With a Mentor Commented:
I would not move them, as it is too risky.  If they have access to SSMS than they can view it now using the undocumented function xp_readerrorlog, as in:
EXEC master..xp_readerrorlog

If they do not have access to SSmS you can build a quick app with .NET to show the contents using this same Stored Procedure
0
 
itnetworksAuthor Commented:
Will create a Maint Plan for the folder move and clean up
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.