Some application designers make the decision to put the referential integrity in the stored procedures instead of in the data model.

If that is the case, you will hopefully find the...

You should do the updates in chunks/ranges of 10 to 50 thousand rows.

This way you minimize locking and log reasonable sized transactions to the transaction log.

First do this in dev...

Does the database have stored procedures that contain key relationship logic for insert, update and delete operations?

What is your storage set up?

Internal, direct attached, dedicated SAN, shared SAN.

In my experience, unless your system is completely saturated in terms of reads and writes,

the cause of these errors...

Do you intend to move all objects AND all data?

Do you have constraints on having prod data in DEV? (security etc.)

You may need processes that obfuscate data that cannot be...

I notice you are using BETWEEN.

BETWEEN has a weak inequality (>= and <=) at both the upper and lower bound of the range.

This way, as you traverse the ranges, you...

Looks like you are running into the "double hop" problem.

Suggested readings:

http://msdn.microsoft.com/en-us/library/ms189580(v=sql.105).aspx

http://www.sqlservercentral.com/Forums/Topic1043330-359-1.aspx

I run Merge replication and the Replication agents checkup job has deadlocks occasionally.

Since it runs every ten minutes, I do not worry too much about it.

What are the exact tasks required for the deployments?

What is needed beyond what the combo of db_ddladmin, db_datareader, db_datarwriter, db_securityadmin and db_backupoperator ?

Please note, that I am not sure if...

1. If the transaction log is not backed up after the index rebuild or purge and before the the log shrink,

the shrink will likely fail, because...

Does the purged table have a clustered index?

Was the log backed up after the purge?

How big is your log file and how much of it is in use?

Is the new...

Under what account does the SQL server and SQL agent services run?

Those accounts must have modify access to the path.

What is in the system log before the SQL Server cluster resource became unavailable?

What is in the windows error log?

wolfkillj (5/1/2013)

---

arnipetursson (5/1/2013)

---

It looks like all of the data was read from cache, since you had 203 logical rads and 0 physical reads.

If you do not run CHECKPOINT before running...