Hi Richard,

by repair I'm assuming you mean you are rebuilding your system databases? If so, yes, you need to re-apply the service pack.

HTH 🙂

Hi guys,

backup history is stored in msdb in a set of tables. You can query them with this:

select A.database_name, A.backup_start_date, A.backup_finish_date,

datediff(ss, A.backup_start_date, A.backup_finish_date) as 'Duration',

(case A.[type]...

Hi Usman,

another cause of this could be out of date statistics or badly fragmented indexes. Do you regularly perform maintenance on these databases?

There are various built-in functions in SQL Server...