Thank's for the info.

SQL does not dictate if SCOM is used or not for my customers, I see the 3rd party tools as a compliment to SCOM and not as...

Thanks for the input!

You are correct 2720425 is for SQL 2008 R2 SP2, click on the resolution link in the article, there you have all the info about which patch for which edition...

Ok, check out this link:

http://support.microsoft.com/kb/2543687/EN-US

Check out this solution, might give you some ideas.

http://stackoverflow.com/questions/13069084/how-to-configure-alert-and-kill-longrunning-queries-in-sql-profiler

1. Share the backup folder on your source server - \\sourceservername\backupfolder$

2. Set read permissions on that share for database engine service account (destination server).

3. Run restore, select from device,...

There is info on connect about this issue.

http://connect.microsoft.com/SQLServer/feedback/details/468478/sql-server-2008-periodically-does-not-accept-connections

Problem solved in SQL 2008 SP2 CU1: http://support.microsoft.com/kb/2289254

Removed post.

Not sure if I replied on your post Jeff.

It was meant for the creator of the thread.

You can easily check for duplicate SPN's.

Setspn

-F = perform the duplicate checking on forestwide level

And when you add SPN's use -S instead of -A, -S checks for duplicate...

If you end up upgrading server B you could create a SSIS package that automates this process for you.

It would contain a couple of tasks and I will try do...

I misread the topic.

Forget this reply.

Yes it is supported.

Check the link for details.

http://msdn.microsoft.com/en-us/library/ms345408.aspx

This thread might give you an idea on how:

http://social.msdn.microsoft.com/Forums/en-US/sqlsecurity/thread/2d3ba502-b8e3-4270-b592-27ec2ed1140b/

Looks like Aaron Bertrand's script from:

http://sqlblog.com/blogs/aaron_bertrand/archive/2008/05/06/when-was-my-database-table-last-accessed.aspx

Credit where credit is due.