locked
Logging to DB and FileSystem RRS feed

  • Question

  • User-1595896116 posted

    Not having an IIS8 setup availble to me at the current time. Can one have logs sent to two places at the same time? Currently I have an SSIS package that picks up the logs, parses them out, then imports them to a DB table for investigation purposes. I was wondering if IIS 8 would allow daily logs to be imported to a DB as well as written to the filesystem.

    Thank you,
    Bill

    Thursday, April 23, 2015 5:29 PM

All replies

  • User258259458 posted

    I see no reason why you couldn't setup IIS to rollover the log daily and run a script to import the previous days log into a DB.  I'm not aware of a capability in IIS to log directly to a DB so a scripted solution to import the previous days log is the only solution I can think of.

    What are you trying to accomplish by importing the log data into a database?  I'll bet log parser or powershell can accomplish the same task.

    Thanks,

    Steve

    Wednesday, April 29, 2015 11:25 PM
  • User-801366587 posted

    Hi,
    I believe, it is not possible to save log files in two different places(Database & File systmem) at same time probably you can move the log file from server file system to the database through script or you can configure IIS to log directly in database using ODBC logging feature of IIS.

    More Information on ODBC: http://www.iis.net/configreference/system.webserver/odbclogging

    Setting up ODBC for IIS 8: http://nirav.extreme-advice.com/2013/07/29/configure-iis-8-0-log-to-sql-server/

    Mark as answer if this helped youSmile

     

    Tuesday, May 5, 2015 7:45 AM