I am thinking about using our MS SQL server as the database for our EventLog Analyzer install. I have a few questions about this:

 

1. What happens if the MS SQL server goes offline? Will the EventLog Analyzer hold the data locally until the database server is back online or will the events be lost until the SQL server comes back online?

 

2. Will Eventlog Analyzer automatically reconnect with the database when the SQL server comes back online?

 

3. Will Eventlog Analyzer still Archive events from a MS SQL database like it does for the MySQL database?

 

4. Are there any downsides to using MS SQL over the local install of MySQL?