Transfer IIS log setting from SQL Server Logs to Custom Logs

Transfer IIS log setting from SQL Server Logs to Custom Logs.

In my last blog i have configured IIS Logs to SQL Server but what should happen when SQL Server Service is down or Database is not available?

SQL Server DownTime
It can be happen that your SQL Server goes down or somebody stopped SQL Server service.
At this time application works fine but we can’t get a log for IIS, we have to change Log file format to directory

Change Log File Setting

→ Go to run and write inetmgr and click ok.

→ Select server and drill down to site → Default Web Site.

→ Double click on Logging function.

→ Select format to “W3C”.

→ Assign proper path to Directory textbox and close window by saving the settings.

Regards,

Nirav Gajjar