Thanks very much

That's great, thanks very much Patrick. I knew there had to be something you could do to handle occasions like this.

That was where I was hoping there was a way of triggering an update on failover to automatically adjust the max memory value(s).

Syed/Perry - surely though it makes more sense to use the bulk of the memory available though, and on fail-over adjust the max memory value to suit otherwise you're just...

Thanks Syed, but how would I solve this when I end up giving greater than 32GB per instance.

No worries at all Grant, thanks for your help 🙂

Thanks Gail, much appreciated.

Thanks Gail.

Is this anything to be concerned about? I don't see it relating to CPU/Memory/Disk usage because that's all low when this Checkpoint Writes gets into the thousands and thousands.

Thanks Grant.

How do I know when a checkpoint occurs? Yes, there is a lot of data getting thrown around on that server, as there's a server monitoring database on there...

Thanks very much, I'll give this all a try tomorrow - http://msdn.microsoft.com/en-us/library/ms176060.aspx 🙂

From Books Online:

"Only members of the sysadmin fixed server role can specify the Auto_Fix option."

Yes that is exactly what is happening upon the restore. His login is becoming orphaned and he loses access to the database he's restored and I don't know how to...

He can restore the database with db_creator role but upon restoring, he loses access to the database because it doesn't re-connect his user with the login (SID). That's what I'm...

No one?

I knew that thanks, but how can I automate that as the user with the restore rights loses all permissions upon completing the restore.