Does that mean that if one replaces resource db files of 2008R2 server with 2008, SQL would be rolled back to 2008 server? Or the roll back using resource database...

Undoubtedly an excellent post!

However, if one wants to learn about indexes from the scratch, what would you suggest?

Thanks Bhuvnesh.

So it seems, alert job directly writes to msdb.

Thank Bhuvanesh.

My exact question is whenever an alert job fails, where it stores the information. Does it directly writes to msdb?

Hello All,

I am also facing the similar issue.

Please let e know if the issue was resolved and share the resolution.

Regards,

Vandy