Excellent. It was the [sp_delete_log_shipping_secondary_database] sp which I needed.

Thanks

Nick

You can set the isolation level to be serializable at the start of your batch IE-

[SET TRANSACTION ISOLATION LEVEL SERIALIZABLE]

You could try something like this:

DECLARE

@Year INT,

@Month INT,

@Day INT

SET @Day = 3

SET @Month = 5

SET @Year = 2009

SELECT

CAST(@Year AS CHAR(4)) +

RIGHT('00' + CAST(@Month AS VARCHAR(2)),2) +

RIGHT('00'...

Point well made (and taken)...:-)

Have a look in the [MSDB].[dbo].[backupmediafamily] table to see where the last backup was placed for each DB

Partial Restore etc

Try running a SQL Profiler trace and watching what happens when you call the SP from your web application. Include the deadlock graph to see if you're experiencing deadlocks too

If you want SQL to have access to more than 2Gb of RAM on a 32BIT installation, you'll need to configure the 3GB switch in the boot.ini file. Depending on...

This list is not exhuastive, but some reasons you may want to place user tables / data on seperate user created filegroups are:

Admin - you can backup and restore filegroups...

You should still determine the cause to prevent further failure.

Can you post table definitions, sample data, and query?

Have you checked DEFAULT LANGUAGE for the connection/login running this query?

Are you actually experiencing IO bottlenecks etc? A disk queue length of 1.86 doesn't indicate a problem on its own. A disk queue length > 2 (per spindle / indivual...

Check you have the "Shared Memory" protocol enabled for that instance. You can check this by opening SQL Server Config Manager -> SQL Native Client Config -> Client Protocals. May...

If your table is on a seperate filegroup, you can back up the filegroup