• To update this toublesome distribution DB, the differential backup that ran this morning also failed:

    Microsoft(R) Server Maintenance Utility (Unicode) Version 10.0.4064

    Report was generated on "MYSERVER".

    Maintenance Plan: MAINT - Distribution

    Duration: 00:06:07

    Status: Warning: One or more tasks failed.

    Details:

    Back Up Database Task (MYSERVER)

    Backup Database on Local server connection

    Databases: distribution

    Type: Differential

    Append existing

    Task start: 2012-02-20T03:45:00.

    Task end: 2012-02-20T03:51:08.

    Failed:(-1073548784) Executing the query "BACKUP DATABASE [distribution] TO DISK = N'\\\\MYS..." failed with the following error: "Time-out occurred while waiting for buffer latch type 3 for page (1:5019346), database ID 25.

    BACKUP DATABASE is terminating abnormally.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

    Command:EXECUTE master.dbo.xp_create_subdir N''\\NETWORKLOCATION\MYSERVER\distribution''

    GO

    BACKUP DATABASE [distribution] TO DISK = N''\\NETWORKLOCATION\MYSERVER\distribution\distribution_backup_2012_02_20_034500_7672884.bak'' WITH DIFFERENTIAL , NOFORMAT, NOINIT, NAME = N''distribution_backup_2012_02_20_034500_7672884'', SKIP, REWIND, NOUNLOAD, NO_COMPRESSION, STATS = 10

    GO

    declare @backupSetId as int

    select @backupSetId = position from msdb..backupset where database_name=N''distribution'' and backup_set_id=(select max(backup_set_id) from msdb..backupset where database_name=N''distribution'' )

    if @backupSetId is null begin raiserror(N''Verify failed. Backup information for database ''''distribution'''' not found.'', 16, 1) end

    RESTORE VERIFYONLY FROM DISK = N''\\NETWORKLOCATION\MYSERVER\distribution\distribution_backup_2012_02_20_034500_7672884.bak'' WITH FILE = @backupSetId, NOUNLOAD, NOREWIND

    GO

    ______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience