Thanks for spotting it.

Moreover, do yourself a favor and set up a consistency check.

Options:

1. A maintenance plan

2. Ola Hallengren maintenance solution

3. My checkDB procedure[/url]

4. Code your own

Any chance you're telling us what was wrong?

If IP All is set to No and if the IP addresses tab has some IP addresses that have ‘Enabled’ set to ‘Yes’ but the actual IP is no longer...

This log is older than the previous one. Please post the latest log.

There's no mention of msdb anywhere in your log.

Also, the entry "recovery is complete" is missing, which suggests that SQL Server hasn't finished recovery yet.

Please restart SQL Server, don't try...

Please post SQL Server ERRORLOG.

deleted

From https://msdn.microsoft.com/it-it/library/ms176069.aspx

WITH OVERRIDE

Disables the configuration value checking (for values that are not valid or for nonrecommended values) for the recovery interval advanced configuration option.

Any configuration option can be reconfigured by...

Can you post SQLAGENT.OUT please?

Do you have the SQL Server Agent service in the services applet or is it missing from there as well?

Which edition please?

Good point. I'm afraid that hunting down the reason why the expand/noexpand behaviour changed in all the queries is a daunting task.

My friend Gail Shaw suggested that the msdb data files could be read only in the file system. Make sure you check that as well.

I wrote a blog post on this topic, for a different reason.

I hope you find it useful: http://spaghettidba.com/2015/01/29/installing-multiple-default-instances-on-a-single-server/