Seems ok as long as you take into account that the original primary database will not be in a recovered state after you break mirroring.

Currently this code is randomising the Accrualdate as there is no ORDER BY when populating the cursor:

Can you explain the purpose of this code?

DECLARE @Counter INT = 0

DECLARE @VirtualID INT

DECLARE...

The DROP procedure statement refers to a different procedure:

DROP PROCEDURE [dbo].[NIC_OA_GetPatientXRayReportsOut]

create PROCEDURE [dbo].[NIC_OA_GetPhysicianXRayReportsOut]

One is PatientXray, the other is PhysicianXray, change DROP statement to:

IF EXISTS (SELECT * FROM sys.objects WHERE object_id...

If you mean the OS free physical RAM, then

SELECT total_physical_memory_kb, available_physical_memory_kb,

total_page_file_kb, available_page_file_kb,

system_memory_state_desc

FROM sys.dm_os_sys_memory WITH...

Is there any reason you cant just update the whole table in one statement? No problem with the composite primary key that way.

update tablename

set startdate= dateadd(d,-1,startdate)

from tablename

You don't need to fail-over at all, just break mirroring, then RESTORE WITH RECOVERY on the mirror to make it useable. Then recreate the mirror after the testing.

Make sure...

Run this to see what's been using Tempdb and how much space is allocated to that session

-- how much was allocated and by what user

SELECT

sys.dm_exec_sessions.session_id as [Session ID],

DB_NAME(database_id) as [Database...

I think you shoud first check the vm host, not the client.

Open vSphere and make sure the memory is not overprovisioned.

If you look at the default performance graphs for the...

Equality and inequality columns are explained in the Microsoft documentation for sys.dm_db_missing_index_details

http://msdn.microsoft.com/query/dev10.query?appId=Dev10IDEF1&l=EN-US&k=k%28SYS.DM_DB_MISSING_INDEX_DETAILS_TSQL%29;k%28SQL11.SWB.TSQLRESULTS.F1%29;k%28SQL11.SWB.TSQLQUERY.F1%29;k%28MISCELLANEOUSFILESPROJECT%29;k%28DevLang-TSQL%29&rd=true

equality_columns

nvarchar(4000)

Comma-separated list of columns that contribute to equality predicates of the form:

table.column =constant_value

inequality_columns

nvarchar(4000)

Comma-separated list of columns that contribute...

There is someone reporting a MSSQL crash with the MySQL 5.2.2 ODBC driver here: http://bugs.mysql.com/bug.php?id=63386

What are the differences between the 2 MSSQL servers? Is one 32bit vs 64bit?

Any errors...

http://support.microsoft.com/kb/918992 Method 3

What happens if you script out the changes and try it without the gui?

Any error messages in the mysql.err log?

From Paul Randal's blog: http://www.sqlskills.com/blogs/paul/most-common-latch-classes-and-what-they-mean/

72: LOG_MANAGER

If you see this latch it is almost certainly because a transaction log is growing because it could not clear/truncate for...

Is there any reason you can't just reattach the testdb from the location where you moved it?

You need to test network connectivity to the endpoint.

Follow the troubleshooting steps under Endpoints heading here: http://msdn.microsoft.com/en-us/library/ms189127%28v=sql.105%29.aspx

If that's all fine, then use Telnet (it's a Windows 2008 feature, so install...