from the horses mouth............

http://blogs.msdn.com/b/psssql/archive/2009/09/11/fun-with-locked-pages-awe-task-manager-and-the-working-set.aspx

the backups are only taken just in case you need to back the upgrade out.

backup all of them. (except tempdb - this cannot be backed, it is recreated on each sql restart)

there is no need to restore any databases after an upgrade.

the upgrade process will upgrade your user database as well.

You will be able to restore your RTM backup post the upgrade. As long as its the same version of SQL...

when connecting to a cluster you connect using the virtual sql instance name, not the name of the physical cluster node. The virtual name connects you to whichever node is...

thanks for the feedback. As someone who does not build the servers this is useful to know. And of course the info could make someones day if they have the...

the max value is dynamic for SQL2005 and above. Is something else grabbing the memory? does it increase to 7GB of its own accord over time?

will you be doing any physical archiving as well?

you will have two tasks in your maintenance plan window. Connect them together with a 'on success' flow arrow. i.e. just drag the arrow emanating from the backup task to...

have you given the service account the lock pages in memory right?

Its a separate task from the pane on the left. 'Maintenance cleanup task'

drag this over, set up to delete bak files, and put a dependency on the backup task.

Ok, confused now. change of username or schizophrenic? 🙂

good old windows 2008, check out UACL.

anything extra in the SQL error log? Does it even produce an error log?

does it work if you give the account local admin?

David.Poole (10/18/2010)

---

If you are getting locking/blocking activity on a table and are not bothered by dirty reads then using the READUNCOMMITTED hint in the join may alleviate this.

If you are...

well it's two and a half years ago but I don't think so. I think I meant if he had to buy 2 standard licenses for active\active instead of two...