full backup works, differential fails
When I do a full backup, it completes successfully (in about 10 seconds). See the log file here:
SQL Backup log file 126.96.36.199
-SQL "BACKUP DATABASE [Viewpoint] TO DISK = 'D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\<AUTO>.sqb' WITH COMPRESSION = 1 "
PROCESSES COMPLETED SUCCESSFULLY
9/17/2008 8:58:21 AM: Backing up Viewpoint (full database) to:
9/17/2008 8:58:21 AM: \Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\FULL_(local)_Viewpoint_20080917_085821.sqb
9/17/2008 8:58:21 AM: BACKUP DATABASE [Viewpoint] TO VIRTUAL_DEVICE = 'SQLBACKUP_A403A8D7-2606-4DAD-8BC8-EE101EF47E86' WITH BUFFERCOUNT = 6, BLOCKSIZE = 65536, MAXTRANSFERSIZE = 1048576, NAME = N'Database (Viewpoint), 9/17/2008 8:58:21 AM', DESCRIPTION = N'Backup on 9/17/2008 8:58:21 AM Server: IRONHIDE Database: Viewpoint'
9/17/2008 8:58:31 AM: Database size : 1.426 GB
9/17/2008 8:58:31 AM: Compressed data size: 689.879 MB
9/17/2008 8:58:31 AM: Compression rate : 52.77%
Processed 123920 pages for database 'Viewpoint', file 'VPProd' on file 1.
Processed 4 pages for database 'Viewpoint', file 'VPProd_log' on file 1.
BACKUP DATABASE successfully processed 123924 pages in 8.875 seconds (114.386 MB/sec).
9/17/2008 8:58:31 AM: SQL Backup process ended.
Here is the log for a differential backup that fails(after about 10 minutes of trying):
SQL Backup log file 188.8.131.52
-SQL "BACKUP DATABASE [Viewpoint] TO DISK = 'D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\<AUTO>.sqb' WITH COMPRESSION = 1, DIFFERENTIAL "
ERRORS AND WARNINGS
9/17/2008 10:07:57 AM: Backing up Viewpoint (differential database) to:
9/17/2008 10:07:57 AM: \Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\DIFF_(local)_Viewpoint_20080917_100757.sqb
9/17/2008 10:07:58 AM: BACKUP DATABASE [Viewpoint] TO VIRTUAL_DEVICE = 'SQLBACKUP_E9D0125E-622E-46C5-8D3E-D6AF7F3B7397' WITH BUFFERCOUNT = 6, BLOCKSIZE = 65536, MAXTRANSFERSIZE = 1048576, NAME = N'Database (Viewpoint), 9/17/2008 10:07:57 AM', DESCRIPTION = N'Backup on 9/17/2008 10:07:57 AM Server: IRONHIDE Database: Viewpoint', DIFFERENTIAL
9/17/2008 10:17:34 AM: VDI error 1010: Failed to get the configuration from the server because the timeout interval has elapsed. Check that the SQL Server instance is running and that you have the SQL Server System Administrator server role; or try increasing the value of the VDITimeout registry setting in HKEY_LOCAL_MACHINE\SOFTWARE\Red Gate\SQL Backup\BackupSettingsGlobal\[InstanceName]
9/17/2008 10:17:34 AM: SQL error 3013: BACKUP DATABASE is terminating abnormally.
9/17/2008 10:17:34 AM: SQL error 3035: Cannot perform a differential backup for database "Viewpoint", because a current database backup does not exist. Perform a full database backup by reissuing BACKUP DATABASE, omitting the WITH DIFFERENTIAL option.
I did create/increase the VDITimeout entry to 240 (4 minutes), per some of the other entries in this forum.
Any ideas/solutions for this? What do I need to do to get the differential backup to work? Why does the differential take 10+ minutes to fail, when the full backup completes successfully in 10 seconds??