322 - AccountServer database backup fails due to timeout

Symptom

The AccountServer database backup fails with the following error, as seen in the ASLog:

Warn: ASManager: Could not backup StoragePlatform database: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding

Cause

This typically occurs on a AccountServer with a very large database. The backup of the large database takes longer than 60 seconds resulting in the connection between the AS and SQL timing out.

Solution

1. Reduce the history of the TracePerformance table (this will not affect the Storage Platform).
    
   1. In Microsoft SQL Server Management Studio, edit the the Stored Procedure called TrimData.
      In Object Explorer select, <SQLServer>\Databases\StoragePlatform\Programmability\Stored Procedures, then right-click on dbo.TrimData and select Modify.
   2. Change:
      Delete TracePerformance where LogDateTime < @date
      to
      Delete TracePerformance where LogDateTime < getdate() - 1

      This will ensure performance data older than 1 day is deleted.

   3. Select (highlight) this modified line and select Execute on the toolbar (or press F5).
       
2. Compact the database
    
   1. Select New Query from the toolbar.
   2. Copy and paste the following into the new query:
      DBCC SHRINKDATABASE(N'StoragePlatform' )
   3. Select Execute (or F5).