VDI Error 1010: SQL required 0 bytes of free SQL Memory?
msalas
Posts: 19
We are encountering some sporadic error for our backups.
We have a nightly full backups for multiple databases. Here is the command exerpt:
-SQL "BACKUP DATABASES [DB1,DB2,DB3,DB4,DB4] TO DISK = '\\networklocation\<database>\<AUTO>.sqb' WITH COMPRESSION = 1, MAXTRANSFERSIZE = 1048576, ERASEFILES = 10, MAILTO = 'email@domain.com, THREADCOUNT = 2, VERIFY "
All of the databases do finish backing up, however, one may fail on the VERIFY portion. The report is mailed and the error would show as:
7/7/2010 8:43:35 PM:
7/7/2010 8:43:35 PM: Verifying files:
7/7/2010 8:43:35 PM: \\NetworkLocation\FULL_(local)_DB1_20100707_204334.sqb
7/7/2010 8:43:35 PM:
7/7/2010 8:43:36 PM: VDI error 1010: Failed to get the configuration from the server because the timeout interval has elapsed. SQL Backup required 0 bytes of free SQL Server memory, which was not available. VDI error: An abort request is preventing anything except termination actions.
The memory profile however would show that there is free memory. How can it fail when it only requires 0 bytes of free memory?
Any insight regarding this issue is greatly appreciated.
Thanks a lot!
We have a nightly full backups for multiple databases. Here is the command exerpt:
-SQL "BACKUP DATABASES [DB1,DB2,DB3,DB4,DB4] TO DISK = '\\networklocation\<database>\<AUTO>.sqb' WITH COMPRESSION = 1, MAXTRANSFERSIZE = 1048576, ERASEFILES = 10, MAILTO = 'email@domain.com, THREADCOUNT = 2, VERIFY "
All of the databases do finish backing up, however, one may fail on the VERIFY portion. The report is mailed and the error would show as:
7/7/2010 8:43:35 PM:
7/7/2010 8:43:35 PM: Verifying files:
7/7/2010 8:43:35 PM: \\NetworkLocation\FULL_(local)_DB1_20100707_204334.sqb
7/7/2010 8:43:35 PM:
7/7/2010 8:43:36 PM: VDI error 1010: Failed to get the configuration from the server because the timeout interval has elapsed. SQL Backup required 0 bytes of free SQL Server memory, which was not available. VDI error: An abort request is preventing anything except termination actions.
The memory profile however would show that there is free memory. How can it fail when it only requires 0 bytes of free memory?
Any insight regarding this issue is greatly appreciated.
Thanks a lot!
Comments
Thanks.
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 8
***
-SQL "BACKUP DATABASES [CertifiedPro,Confirm,CPNET,EMAIL,ERR,ERRNET,Gemini,IFW,IVR,JobMonitor,mailpro,MASBillingAndPricing,PostageRates,ReportServer,ReportServerTempDB,RPAM,SYSENG,TrackRight,TrackRight Demo,TrackRightNewDemo,USPSEC,USPSEC - CPNET,USPSElectronic Confirmation,USPSElectronic Confirmation - CPNET,USPSElectronic Confirmation - YA,WalzGroupWeb,WalzImaging,WalzPostal,WSOImaging] TO DISK = '\\sanna02\SQLBACKUPS\REDGATE_SAN-DB-02\<database>\<AUTO>.sqb' WITH COMPRESSION = 1, MAXTRANSFERSIZE = 1048576, ERASEFILES = 10, MAILTO = 'dbalerts@walzgroup.com', THREADCOUNT = 2, VERIFY "
ERRORS AND WARNINGS
7/7/2010 8:43:35 PM:
7/7/2010 8:43:35 PM: Verifying files:
7/7/2010 8:43:35 PM: \\sanna02\SQLBACKUPS\REDGATE_SAN-DB-02\TrackRight Demo\FULL_(local)_TrackRight Demo_20100707_204334.sqb
7/7/2010 8:43:35 PM:
7/7/2010 8:43:36 PM: VDI error 1010: Failed to get the configuration from the server because the timeout interval has elapsed. SQL Backup required 0 bytes of free SQL Server memory, which was not available. VDI error: An abort request is preventing anything except termination actions.
7/7/2010 8:43:36 PM: SQL error 3013: VERIFY DATABASE is terminating abnormally.
7/7/2010 8:43:36 PM: SQL error 18210: BackupVirtualDeviceSet::Initialize: Request large buffers failure on backup device 'SQLBACKUP_A9E551FA-BEEE-4093-96BE-0B60DD99101F'. Operating system error 0x8007000e(Not enough storage is available to complete this operation.).
7/7/2010 8:43:36 PM:
7/7/2010 8:43:36 PM: Memory profile
7/7/2010 8:43:36 PM: Type Maximum Minimum Average Blk count Total
7/7/2010 8:43:36 PM:
7/7/2010 8:43:36 PM: Commit 296353792 4096 106320 7099 754769920
7/7/2010 8:43:36 PM: Reserve 4190208 4096 277074 4898 1357111296
7/7/2010 8:43:36 PM: Free 3932160 4096 98440 361 35536896
7/7/2010 8:43:36 PM: Private 296353792 4096 175970 11218 1974034432
7/7/2010 8:43:36 PM: Mapped 1060864 4096 116336 169 19660800
7/7/2010 8:43:36 PM: Image 24948736 4096 193747 610 118185984
7/7/2010 8:43:36 PM:
PROCESSES COMPLETED SUCCESSFULLY
7/7/2010 7:00:00 PM: Backing up CertifiedPro (full database) to:
7/7/2010 7:00:00 PM: \\sanna02\SQLBACKUPS\REDGATE_SAN-DB-02\CertifiedPro\FULL_(local)_CertifiedPro_20100707_190000.sqb
7/7/2010 7:00:01 PM: BACKUP DATABASE [CertifiedPro] TO VIRTUAL_DEVICE = 'SQLBACKUP_DBB8CFA2-4AB5-4987-90BB-A112D19A123F', VIRTUAL_DEVICE = 'SQLBACKUP_DBB8CFA2-4AB5-4987-90BB-A112D19A123F01' WITH BUFFERCOUNT = 12, BLOCKSIZE = 65536, MAXTRANSFERSIZE = 1048576, NAME = N'Database (CertifiedPro), 7/7/2010 7:00:00 PM', DESCRIPTION = N'Backup on 7/7/2010 7:00:00 PM Server: SAN-DB-02 Database: CertifiedPro', FORMAT
7/7/2010 7:24:44 PM: Database size : 608.529 GB
7/7/2010 7:24:44 PM: Compressed data size: 52.933 GB
7/7/2010 7:24:44 PM: Compression rate : 91.30%
7/7/2010 7:24:44 PM: Processed 40019224 pages for database 'CertifiedPro', file 'CertifiedPro_Data' on file 1.
7/7/2010 7:24:44 PM: Processed 5277 pages for database 'CertifiedPro', file 'CertifiedPro_Log' on file 1.
7/7/2010 7:24:44 PM: BACKUP DATABASE successfully processed 40024501 pages in 1480.401 seconds (221.481 MB/sec).
7/7/2010 7:24:44 PM:
7/7/2010 7:24:44 PM: Verifying files:
7/7/2010 7:24:44 PM: \\sanna02\SQLBACKUPS\REDGATE_SAN-DB-02\CertifiedPro\FULL_(local)_CertifiedPro_20100707_190000.sqb
7/7/2010 7:24:44 PM:
7/7/2010 7:58:02 PM: The backup set on file 1 is valid.
7/7/2010 7:58:02 PM: Deleting old backup file: \\sanna02\SQLBACKUPS\REDGATE_SAN-DB-02\CertifiedPro\FULL_(local)_CertifiedPro_20100627_190000.sqb
7/7/2010 7:58:02 PM: Backing up Confirm (full database) to:
7/7/2010 7:58:02 PM: \\sanna02\SQLBACKUPS\REDGATE_SAN-DB-02\Confirm\FULL_(local)_Confirm_20100707_195802.sqb
7/7/2010 7:58:02 PM: BACKUP DATABASE [Confirm] TO VIRTUAL_DEVICE = 'SQLBACKUP_5BA404D3-B985-40CA-87CB-43F3D7298A07', VIRTUAL_DEVICE = 'SQLBACKUP_5BA404D3-B985-40CA-87CB-43F3D7298A0701' WITH BUFFERCOUNT = 12, BLOCKSIZE = 65536, MAXTRANSFERSIZE = 1048576, NAME = N'Database (Confirm), 7/7/2010 7:58:02 PM', DESCRIPTION = N'Backup on 7/7/2010 7:58:02 PM Server: SAN-DB-02 Database: Confirm', FORMAT
7/7/2010 7:58:14 PM: Database size : 1.314 GB
7/7/2010 7:58:14 PM: Compressed data size: 495.092 MB
7/7/2010 7:58:14 PM: Compression rate : 63.22%
7/7/2010 7:58:14 PM: Processed 105568 pages for database 'Confirm', file 'Confirm' on file 1.
7/7/2010 7:58:14 PM: Processed 1 pages for database 'Confirm', file 'Confirm_log' on file 1.
7/7/2010 7:58:14 PM: BACKUP DATABASE successfully processed 105569 pages in 11.258 seconds (76.818 MB/sec).
7/7/2010 7:58:15 PM:
7/7/2010 7:58:15 PM: Verifying files:
7/7/2010 7:58:15 PM: \\sanna02\SQLBACKUPS\REDGATE_SAN-DB-02\Confirm\FULL_(local)_Confirm_20100707_195802.sqb
7/7/2010 7:58:15 PM:
7/7/2010 7:58:39 PM: The backup set on file 1 is valid.
7/7/2010 7:58:39 PM: Deleting old backup file: \\sanna02\SQLBACKUPS\REDGATE_SAN-DB-02\Confirm\FULL_(local)_Confirm_20100627_195435.sqb
7/7/2010 7:58:39 PM: Backing up CPNET (full database) to:
7/7/2010 7:58:39 PM: \\sanna02\SQLBACKUPS\REDGATE_SAN-DB-02\CPNET\FULL_(local)_CPNET_20100707_195839.sqb
7/7/2010 7:58:39 PM: BACKUP DATABASE [CPNET] TO VIRTUAL_DEVICE = 'SQLBACKUP_6585409E-A48F-4B2C-AC54-EFEC09332865', VIRTUAL_DEVICE = 'SQLBACKUP_6585409E-A48F-4B2C-AC54-EFEC0933286501' WITH BUFFERCOUNT = 12, BLOCKSIZE = 65536, MAXTRANSFERSIZE = 1048576, NAME = N'Database (CPNET), 7/7/2010 7:58:39 PM', DESCRIPTION = N'Backup on 7/7/2010 7:58:39 PM Server: SAN-DB-02 Database: CPNET', FORMAT
7/7/2010 7:58:47 PM: Database size : 1.905 GB
7/7/2010 7:58:47 PM: Compressed data size: 272.946 MB
7/7/2010 7:58:47 PM: Compression rate : 86.01%
7/7/2010 7:58:47 PM: Processed 138496 pages for database 'CPNET', file 'CPNET' on file 1.
7/7/2010 7:58:47 PM: Processed 710 pages for database 'CPNET', file 'CPNET_log' on file 1.
7/7/2010 7:58:47 PM: BACKUP DATABASE successfully processed 139206 pages in 6.714 seconds (169.849 MB/sec).
7/7/2010 7:58:47 PM:
7/7/2010 7:58:47 PM: Verifying files:
7/7/2010 7:58:47 PM: \\sanna02\SQLBACKUPS\REDGATE_SAN-DB-02\CPNET\FULL_(local)_CPNET_20100707_195839.sqb
7/7/2010 7:58:47 PM:
7/7/2010 7:59:02 PM: The backup set on file 1 is valid.
7/7/2010 7:59:02 PM: Deleting old backup file: \\sanna02\SQLBACKUPS\REDGATE_SAN-DB-02\CPNET\FULL_(local)_CPNET_20100627_195510.sqb
7/7/2010 7:59:02 PM: Backing up EMAIL (full database) to:
7/7/2010 7:59:02 PM: \\sanna02\SQLBACKUPS\REDGATE_SAN-DB-02\EMAIL\FULL_(local)_EMAIL_20100707_195902.sqb
7/7/2010 7:59:03 PM: BACKUP DATABASE [EMAIL] TO VIRTUAL_DEVICE = 'SQLBACKUP_A49C982E-86D0-4548-AC44-5EA5C5D26A0C', VIRTUAL_DEVICE = 'SQLBACKUP_A49C982E-86D0-4548-AC44-5EA5C5D26A0C01' WITH BUFFERCOUNT = 12, BLOCKSIZE = 65536, MAXTRANSFERSIZE = 1048576, NAME = N'Database (EMAIL), 7/7/2010 7:59:02 PM', DESCRIPTION = N'Backup on 7/7/2010 7:59:02 PM Server: SAN-DB-02 Database: EMAIL', FORMAT
7/7/2010 7:59:03 PM: Database size : 1.294 GB
7/7/2010 7:59:03 PM: Compressed data size: 4.081 MB
7/7/2010 7:59:03 PM: Compression rate : 99.69%
7/7/2010 7:59:03 PM: Processed 2496 pages for database 'EMAIL', file 'EMAIL' on file 1.
7/7/2010 7:59:03 PM: Processed 2 pages for database 'EMAIL', file 'EMAIL_log' on file 1.
7/7/2010 7:59:03 PM: BACKUP DATABASE successfully processed 2498 pages in 0.276 seconds (74.139 MB/sec).
7/7/2010 7:59:04 PM:
7/7/2010 7:59:04 PM: Verifying files:
7/7/2010 7:59:04 PM: \\sanna02\SQLBACKUPS\REDGATE_SAN-DB-02\EMAIL\FULL_(local)_EMAIL_20100707_195902.sqb
7/7/2010 7:59:04 PM:
7/7/2010 7:59:04 PM: The backup set on file 1 is valid.
[/email]
7/7/2010 7:59:04 PM: Deleting old backup file: \\sanna02\SQLBACKUPS\REDGATE_SAN-DB-02\EMAIL\FULL_(local)_EMAIL_20100627_195531.sqb
7/7/2010 7:59:04 PM: Backing up ERR (full database) to:
7/7/2010 7:59:04 PM: \\sanna02\SQLBACKUPS\REDGATE_SAN-DB-02\ERR\FULL_(local)_ERR_20100707_195904.sqb
7/7/2010 7:59:05 PM: BACKUP DATABASE [ERR] TO VIRTUAL_DEVICE = 'SQLBACKUP_941AF881-8B64-465B-9101-23C372486098', VIRTUAL_DEVICE = 'SQLBACKUP_941AF881-8B64-465B-9101-23C37248609801' WITH BUFFERCOUNT = 12, BLOCKSIZE = 65536, MAXTRANSFERSIZE = 1048576, NAME = N'Database (ERR), 7/7/2010 7:59:04 PM', DESCRIPTION = N'Backup on 7/7/2010 7:59:04 PM Server: SAN-DB-02 Database: ERR', FORMAT
7/7/2010 7:59:06 PM: Database size : 1.167 GB
7/7/2010 7:59:06 PM: Compressed data size: 22.166 MB
7/7/2010 7:59:06 PM: Compression rate : 98.15%
7/7/2010 7:59:06 PM: Processed 14104 pages for database 'ERR', file 'ERR' on file 1.
7/7/2010 7:59:06 PM: Processed 1 pages for database 'ERR', file 'ERR_log' on file 1.
7/7/2010 7:59:06 PM: BACKUP DATABASE successfully processed 14105 pages in 0.598 seconds (193.224 MB/sec).
7/7/2010 7:59:06 PM:
7/7/2010 7:59:06 PM: Verifying files:
7/7/2010 7:59:06 PM: \\sanna02\SQLBACKUPS\REDGATE_SAN-DB-02\ERR\FULL_(local)_ERR_20100707_195904.sqb
7/7/2010 7:59:06 PM:
7/7/2010 7:59:07 PM: The backup set on file 1 is valid.
7/7/2010 7:59:07 PM: Deleting old backup file: \\sanna02\SQLBACKUPS\REDGATE_SAN-DB-02\ERR\FULL_(local)_ERR_20100627_195533.sqb
7/7/2010 7:59:07 PM: Backing up ERRNET (full database) to:
7/7/2010 7:59:07 PM: \\sanna02\SQLBACKUPS\REDGATE_SAN-DB-02\ERRNET\FULL_(local)_ERRNET_20100707_195907.sqb
7/7/2010 7:59:08 PM: BACKUP DATABASE [ERRNET] TO VIRTUAL_DEVICE = 'SQLBACKUP_ED955D6F-04C9-4AD7-8EFA-C5C9C0796736', VIRTUAL_DEVICE = 'SQLBACKUP_ED955D6F-04C9-4AD7-8EFA-C5C9C079673601' WITH BUFFERCOUNT = 12, BLOCKSIZE = 65536, MAXTRANSFERSIZE = 1048576, NAME = N'Database (ERRNET), 7/7/2010 7:59:07 PM', DESCRIPTION = N'Backup on 7/7/2010 7:59:07 PM Server: SAN-DB-02 Database: ERRNET', FORMAT
7/7/2010 7:59:09 PM: Database size : 1.060 GB
7/7/2010 7:59:09 PM: Compressed data size: 9.443 MB
7/7/2010 7:59:09 PM: Compression rate : 99.13%
7/7/2010 7:59:09 PM: Processed 5880 pages for database 'ERRNET', file 'ERRNET' on file 1.
7/7/2010 7:59:09 PM: Processed 1 pages for database 'ERRNET', file 'ERRNET_log' on file 1.
7/7/2010 7:59:09 PM: BACKUP DATABASE successfully processed 5881 pages in 0.790 seconds (60.983 MB/sec).
7/7/2010 7:59:10 PM:
7/7/2010 7:59:10 PM: Verifying files:
7/7/2010 7:59:10 PM: \\sanna02\SQLBACKUPS\REDGATE_SAN-DB-02\ERRNET\FULL_(local)_ERRNET_20100707_195907.sqb
7/7/2010 7:59:10 PM:
7/7/2010 7:59:10 PM: The backup set on file 1 is valid.
7/7/2010 7:59:10 PM: Deleting old backup file: \\sanna02\SQLBACKUPS\REDGATE_SAN-DB-02\ERRNET\FULL_(local)_ERRNET_20100627_195536.sqb
7/7/2010 7:59:10 PM: Backing up Gemini (full database) to:
7/7/2010 7:59:10 PM: \\sanna02\SQLBACKUPS\REDGATE_SAN-DB-02\Gemini\FULL_(local)_Gemini_20100707_195910.sqb
7/7/2010 7:59:11 PM: BACKUP DATABASE [Gemini] TO VIRTUAL_DEVICE = 'SQLBACKUP_C87C718B-FE6D-42C9-B32A-09692F69BF4F', VIRTUAL_DEVICE = 'SQLBACKUP_C87C718B-FE6D-42C9-B32A-09692F69BF4F01' WITH BUFFERCOUNT = 12, BLOCKSIZE = 65536, MAXTRANSFERSIZE = 1048576, NAME = N'Database (Gemini), 7/7/2010 7:59:10 PM', DESCRIPTION = N'Backup on 7/7/2010 7:59:10 PM Server: SAN-DB-02 Database: Gemini', FORMAT
7/7/2010 7:59:15 PM: Database size : 1.745 GB
7/7/2010 7:59:15 PM: Compressed data size: 148.808 MB
7/7/2010 7:59:15 PM: Compression rate : 91.67%
7/7/2010 7:59:15 PM: Processed 65464 pages for database 'Gemini', file 'Gemini' on file 1.
7/7/2010 7:59:15 PM: Processed 8 pages for database 'Gemini', file 'Gemini_log' on file 1.
7/7/2010 7:59:15 PM: BACKUP DATABASE successfully processed 65472 pages in 3.412 seconds (157.192 MB/sec).
7/7/2010 7:59:15 PM:
7/7/2010 7:59:15 PM: Verifying files:
7/7/2010 7:59:15 PM: \\sanna02\SQLBACKUPS\REDGATE_SAN-DB-02\Gemini\FULL_(local)_Gemini_20100707_195910.sqb
7/7/2010 7:59:15 PM:
7/7/2010 7:59:23 PM: The backup set on file 1 is valid.
7/7/2010 7:59:23 PM: Deleting old backup file: \\sanna02\SQLBACKUPS\REDGATE_SAN-DB-02\Gemini\FULL_(local)_Gemini_20100627_195539.sqb
7/7/2010 7:59:23 PM: Backing up IFW (full database) to:
7/7/2010 7:59:23 PM: \\sanna02\SQLBACKUPS\REDGATE_SAN-DB-02\IFW\FULL_(local)_IFW_20100707_195923.sqb
7/7/2010 7:59:23 PM: BACKUP DATABASE [IFW] TO VIRTUAL_DEVICE = 'SQLBACKUP_918A1114-702B-42E2-913A-8619CE703DEB', VIRTUAL_DEVICE = 'SQLBACKUP_918A1114-702B-42E2-913A-8619CE703DEB01' WITH BUFFERCOUNT = 12, BLOCKSIZE = 65536, MAXTRANSFERSIZE = 1048576, NAME = N'Database (IFW), 7/7/2010 7:59:23 PM', DESCRIPTION = N'Backup on 7/7/2010 7:59:23 PM Server: SAN-DB-02 Database: IFW', FORMAT
7/7/2010 7:59:24 PM: Database size : 1.416 GB
7/7/2010 7:59:24 PM: Compressed data size: 6.055 MB
7/7/2010 7:59:24 PM: Compression rate : 99.58%
7/7/2010 7:59:24 PM: Processed 4232 pages for database 'IFW', file 'IFW' on file 1.
7/7/2010 7:59:24 PM: Processed 121 pages for database 'IFW', file 'IFW_log' on file 1.
7/7/2010 7:59:24 PM: BACKUP DATABASE successfully processed 4353 pages in 0.322 seconds (110.725 MB/sec).
7/7/2010 7:59:24 PM:
7/7/2010 7:59:24 PM: Verifying files:
7/7/2010 7:59:24 PM: \\sanna02\SQLBACKUPS\REDGATE_SAN-DB-02\IFW\FULL_(local)_IFW_20100707_195923.sqb
7/7/2010 7:59:24 PM:
7/7/2010 7:59:25 PM: The backup set on file 1 is valid.
7/7/2010 7:59:25 PM: Deleting old backup file: \\sanna02\SQLBACKUPS\REDGATE_SAN-DB-02\IFW\FULL_(local)_IFW_20100627_195550.sqb
7/7/2010 7:59:25 PM: Backing up IVR (full database) to:
7/7/2010 7:59:25 PM: \\sanna02\SQLBACKUPS\REDGATE_SAN-DB-02\IVR\FULL_(local)_IVR_20100707_195925.sqb
7/7/2010 7:59:26 PM: BACKUP DATABASE [IVR] TO VIRTUAL_DEVICE = 'SQLBACKUP_BD9C2AE9-FC0B-4940-A4E8-292C656226D5', VIRTUAL_DEVICE = 'SQLBACKUP_BD9C2AE9-FC0B-4940-A4E8-292C656226D501' WITH BUFFERCOUNT = 12, BLOCKSIZE = 65536, MAXTRANSFERSIZE = 1048576, NAME = N'Database (IVR), 7/7/2010 7:59:25 PM', DESCRIPTION = N'Backup on 7/7/2010 7:59:25 PM Server: SAN-DB-02 Database: IVR', FORMAT
7/7/2010 7:59:27 PM: Database size : 768.938 MB
7/7/2010 7:59:27 PM: Compressed data size: 28.435 MB
7/7/2010 7:59:27 PM: Compression rate : 96.30%
7/7/2010 7:59:27 PM: Processed 22848 pages for database 'IVR', file 'IVR' on file 1.
7/7/2010 7:59:27 PM: Processed 1 pages for database 'IVR', file 'IVR_log' on file 1.
7/7/2010 7:59:27 PM: BACKUP DATABASE successfully processed 22849 pages in 0.934 seconds (200.405 MB/sec).
7/7/2010 7:59:28 PM:
7/7/2010 7:59:28 PM: Verifying files:
7/7/2010 7:59:28 PM: \\sanna02\SQLBACKUPS\REDGATE_SAN-DB-02\IVR\FULL_(local)_IVR_20100707_195925.sqb
7/7/2010 7:59:28 PM:
7/7/2010 7:59:29 PM: The backup set on file 1 is valid.
7/7/2010 7:59:29 PM: Deleting old backup file: \\sanna02\SQLBACKUPS\REDGATE_SAN-DB-02\IVR\FULL_(local)_IVR_20100627_195552.sqb
7/7/2010 7:59:29 PM: Backing up JobMonitor (full database) to:
7/7/2010 7:59:29 PM: \\sanna02\SQLBACKUPS\REDGATE_SAN-DB-02\JobMonitor\FULL_(local)_JobMonitor_20100707_195929.sqb
7/7/2010 7:59:30 PM: BACKUP DATABASE [JobMonitor] TO VIRTUAL_DEVICE = 'SQLBACKUP_C1FFE824-0E49-40BD-A51D-AE8A0456D835', VIRTUAL_DEVICE = 'SQLBACKUP_C1FFE824-0E49-40BD-A51D-AE8A0456D83501' WITH BUFFERCOUNT = 12, BLOCKSIZE = 65536, MAXTRANSFERSIZE = 1048576, NAME = N'Database (JobMonitor), 7/7/2010 7:59:29 PM', DESCRIPTION = N'Backup on 7/7/2010 7:59:29 PM Server: SAN-DB-02 Database: JobMonitor', FORMAT
7/7/2010 7:59:34 PM: Database size : 1.795 GB
7/7/2010 7:59:34 PM: Compressed data size: 162.947 MB
7/7/2010 7:59:34 PM: Compression rate : 91.13%
7/7/2010 7:59:34 PM: Processed 95320 pages for database 'JobMonitor', file 'JobMonitor' on file 1.
7/7/2010 7:59:34 PM: Processed 32 pages for database 'JobMonitor', file 'JobMonitor_log' on file 1.
7/7/2010 7:59:34 PM: BACKUP DATABASE successfully processed 95352 pages in 3.800 seconds (205.557 MB/sec).
7/7/2010 7:59:34 PM:
7/7/2010 7:59:34 PM: Verifying files:
7/7/2010 7:59:34 PM: \\sanna02\SQLBACKUPS\REDGATE_SAN-DB-02\JobMonitor\FULL_(local)_JobMonitor_20100707_195929.sqb
7/7/2010 7:59:34 PM:
7/7/2010 7:59:42 PM: The backup set on file 1 is valid.
7/7/2010 7:59:42 PM: Deleting old backup file: \\sanna02\SQLBACKUPS\REDGATE_SAN-DB-02\JobMonitor\FULL_(local)_JobMonitor_20100627_195556.sqb
7/7/2010 7:59:42 PM: Backing up mailpro (full database) to:
7/7/2010 7:59:42 PM: \\sanna02\SQLBACKUPS\REDGATE_SAN-DB-02\mailpro\FULL_(local)_mailpro_20100707_195942.sqb
7/7/2010 7:59:43 PM: BACKUP DATABASE [mailpro] TO VIRTUAL_DEVICE = 'SQLBACKUP_A240A648-2F3A-4861-9530-CC9FD6CDD035', VIRTUAL_DEVICE = 'SQLBACKUP_A240A648-2F3A-4861-9530-CC9FD6CDD03501' WITH BUFFERCOUNT = 12, BLOCKSIZE = 65536, MAXTRANSFERSIZE = 1048576, NAME = N'Database (mailpro), 7/7/2010 7:59:42 PM', DESCRIPTION = N'Backup on 7/7/2010 7:59:42 PM Server: SAN-DB-02 Database: mailpro', FORMAT
7/7/2010 8:03:40 PM: Database size : 37.859 GB
7/7/2010 8:03:40 PM: Compressed data size: 9.828 GB
7/7/2010 8:03:40 PM: Compression rate : 74.04%
7/7/2010 8:03:40 PM: Processed 3692840 pages for database 'mailpro', file 'WPS_Data' on file 1.
7/7/2010 8:03:40 PM: Processed 2 pages for database 'mailpro', file 'WPS_Log' on file 1.
7/7/2010 8:03:40 PM: BACKUP DATABASE successfully processed 3692842 pages in 236.619 seconds (127.850 MB/sec).
7/7/2010 8:03:40 PM:
7/7/2010 8:03:40 PM: Verifying files:
7/7/2010 8:03:40 PM: \\sanna02\SQLBACKUPS\REDGATE_SAN-DB-02\mailpro\FULL_(local)_mailpro_20100707_195942.sqb
7/7/2010 8:03:40 PM:
7/7/2010 8:09:23 PM: The backup set on file 1 is valid.
7/7/2010 8:09:23 PM: Deleting old backup file: \\sanna02\SQLBACKUPS\REDGATE_SAN-DB-02\mailpro\FULL_(local)_mailpro_20100627_195609.sqb
7/7/2010 8:09:23 PM: Backing up MASBillingAndPricing (full database) to:
7/7/2010 8:09:23 PM: \\sanna02\SQLBACKUPS\REDGATE_SAN-DB-02\MASBillingAndPricing\FULL_(local)_MASBillingAndPricing_20100707_200923.sqb
7/7/2010 8:09:24 PM: BACKUP DATABASE [MASBillingAndPricing] TO VIRTUAL_DEVICE = 'SQLBACKUP_329B5791-2865-4DBA-B966-7043C9F20605', VIRTUAL_DEVICE = 'SQLBACKUP_329B5791-2865-4DBA-B966-7043C9F2060501' WITH BUFFERCOUNT = 12, BLOCKSIZE = 65536, MAXTRANSFERSIZE = 1048576, NAME = N'Database (MASBillingAndPricing), 7/7/2010 8:09:23 PM', DESCRIPTION = N'Backup on 7/7/2010 8:09:23 PM Server: SAN-DB-02 Database: MASBillingAndPricing', FORMAT
7/7/2010 8:09:25 PM: Database size : 516.000 MB
7/7/2010 8:09:25 PM: Compressed data size: 222.000 KB
7/7/2010 8:09:25 PM: Compression rate : 99.96%
7/7/2010 8:09:25 PM: Processed 184 pages for database 'MASBillingAndPricing', file 'MASBillingAndPricing' on file 1.
7/7/2010 8:09:25 PM: Processed 1 pages for database 'MASBillingAndPricing', file 'MASBillingAndPricing_log' on file 1.
7/7/2010 8:09:25 PM: BACKUP DATABASE successfully processed 185 pages in 0.339 seconds (4.470 MB/sec).
7/7/2010 8:09:25 PM:
7/7/2010 8:09:25 PM: Verifying files:
7/7/2010 8:09:25 PM: \\sanna02\SQLBACKUPS\REDGATE_SAN-DB-02\MASBillingAndPricing\FULL_(local)_MASBillingAndPricing_20100707_200923.sqb
7/7/2010 8:09:25 PM:
7/7/2010 8:09:26 PM: The backup set on file 1 is valid.
7/7/2010 8:09:26 PM: Deleting old backup file: \\sanna02\SQLBACKUPS\REDGATE_SAN-DB-02\MASBillingAndPricing\FULL_(local)_MASBillingAndPricing_20100627_200519.sqb
7/7/2010 8:09:26 PM: Backing up PostageRates (full database) to:
7/7/2010 8:09:26 PM: \\sanna02\SQLBACKUPS\REDGATE_SAN-DB-02\PostageRates\FULL_(local)_PostageRates_20100707_200926.sqb
7/7/2010 8:09:26 PM: BACKUP DATABASE [PostageRates] TO VIRTUAL_DEVICE = 'SQLBACKUP_6DDBDE1F-066F-4914-91FF-28CEE46B4738', VIRTUAL_DEVICE = 'SQLBACKUP_6DDBDE1F-066F-4914-91FF-28CEE46B473801' WITH BUFFERCOUNT = 12, BLOCKSIZE = 65536, MAXTRANSFERSIZE = 1048576, NAME = N'Database (PostageRates), 7/7/2010 8:09:26 PM', DESCRIPTION = N'Backup on 7/7/2010 8:09:26 PM Server: SAN-DB-02 Database: PostageRates', FORMAT
7/7/2010 8:09:27 PM: Database size : 3.000 MB
7/7/2010 8:09:27 PM: Compressed data size: 202.000 KB
7/7/2010 8:09:27 PM: Compression rate : 93.42%
7/7/2010 8:09:27 PM: Processed 168 pages for database 'PostageRates', file 'PostageRates' on file 1.
7/7/2010 8:09:27 PM: Processed 1 pages for database 'PostageRates', file 'PostageRates_log' on file 1.
7/7/2010 8:09:27 PM: BACKUP DATABASE successfully processed 169 pages in 0.334 seconds (4.131 MB/sec).
7/7/2010 8:09:27 PM:
7/7/2010 8:09:27 PM: Verifying files:
7/7/2010 8:09:27 PM: \\sanna02\SQLBACKUPS\REDGATE_SAN-DB-02\PostageRates\FULL_(local)_PostageRates_20100707_200926.sqb
7/7/2010 8:09:27 PM:
7/7/2010 8:09:28 PM: The backup set on file 1 is valid.
7/7/2010 8:09:28 PM: Deleting old backup file: \\sanna02\SQLBACKUPS\REDGATE_SAN-DB-02\PostageRates\FULL_(local)_PostageRates_20100627_200521.sqb
7/7/2010 8:09:28 PM: Backing up ReportServer (full database) to:
7/7/2010 8:09:28 PM: \\sanna02\SQLBACKUPS\REDGATE_SAN-DB-02\ReportServer\FULL_(local)_ReportServer_20100707_200928.sqb
7/7/2010 8:09:28 PM: BACKUP DATABASE [ReportServer] TO VIRTUAL_DEVICE = 'SQLBACKUP_1B85C632-8C26-453B-B195-EA9120C69EED', VIRTUAL_DEVICE = 'SQLBACKUP_1B85C632-8C26-453B-B195-EA9120C69EED01' WITH BUFFERCOUNT = 12, BLOCKSIZE = 65536, MAXTRANSFERSIZE = 1048576, NAME = N'Database (ReportServer), 7/7/2010 8:09:28 PM', DESCRIPTION = N'Backup on 7/7/2010 8:09:28 PM Server: SAN-DB-02 Database: ReportServer', FORMAT
7/7/2010 8:09:29 PM: Database size : 40.688 MB
7/7/2010 8:09:29 PM: Compressed data size: 5.468 MB
7/7/2010 8:09:29 PM: Compression rate : 86.56%
7/7/2010 8:09:29 PM: Processed 2832 pages for database 'ReportServer', file 'ReportServer' on file 1.
7/7/2010 8:09:29 PM: Processed 5 pages for database 'ReportServer', file 'ReportServer_log' on file 1.
7/7/2010 8:09:29 PM: BACKUP DATABASE successfully processed 2837 pages in 0.292 seconds (79.580 MB/sec).
7/7/2010 8:09:29 PM:
7/7/2010 8:09:29 PM: Verifying files:
7/7/2010 8:09:29 PM: \\sanna02\SQLBACKUPS\REDGATE_SAN-DB-02\ReportServer\FULL_(local)_ReportServer_20100707_200928.sqb
7/7/2010 8:09:29 PM:
7/7/2010 8:09:30 PM: The backup set on file 1 is valid.
7/7/2010 8:09:30 PM: Deleting old backup file: \\sanna02\SQLBACKUPS\REDGATE_SAN-DB-02\ReportServer\FULL_(local)_ReportServer_20100627_200523.sqb
7/7/2010 8:09:30 PM: Backing up ReportServerTempDB (full database) to:
7/7/2010 8:09:30 PM: \\sanna02\SQLBACKUPS\REDGATE_SAN-DB-02\ReportServerTempDB\FULL_(local)_ReportServerTempDB_20100707_200930.sqb
7/7/2010 8:09:30 PM: BACKUP DATABASE [ReportServerTempDB] TO VIRTUAL_DEVICE = 'SQLBACKUP_6321AA62-27D7-44D2-ADCB-819849EBABF8', VIRTUAL_DEVICE = 'SQLBACKUP_6321AA62-27D7-44D2-ADCB-819849EBABF801' WITH BUFFERCOUNT = 12, BLOCKSIZE = 65536, MAXTRANSFERSIZE = 1048576, NAME = N'Database (ReportServerTempDB), 7/7/2010 8:09:30 PM', DESCRIPTION = N'Backup on 7/7/2010 8:09:30 PM Server: SAN-DB-02 Database: ReportServerTempDB', FORMAT
7/7/2010 8:09:31 PM: Database size : 28.250 MB
7/7/2010 8:09:31 PM: Compressed data size: 1.993 MB
7/7/2010 8:09:31 PM: Compression rate : 92.95%
7/7/2010 8:09:31 PM: Processed 632 pages for database 'ReportServerTempDB', file 'ReportServerTempDB' on file 1.
7/7/2010 8:09:31 PM: Processed 3 pages for database 'ReportServerTempDB', file 'ReportServerTempDB_log' on file 1.
7/7/2010 8:09:31 PM: BACKUP DATABASE successfully processed 635 pages in 0.487 seconds (10.680 MB/sec).
7/7/2010 8:09:32 PM:
7/7/2010 8:09:32 PM: Verifying files:
7/7/2010 8:09:32 PM: \\sanna02\SQLBACKUPS\REDGATE_SAN-DB-02\ReportServerTempDB\FULL_(local)_ReportServerTempDB_20100707_200930.sqb
7/7/2010 8:09:32 PM:
7/7/2010 8:09:32 PM: The backup set on file 1 is valid.
7/7/2010 8:09:33 PM: Deleting old backup file: \\sanna02\SQLBACKUPS\REDGATE_SAN-DB-02\ReportServerTempDB\FULL_(local)_ReportServerTempDB_20100627_200525.sqb
7/7/2010 8:09:33 PM: Backing up RPAM (full database) to:
7/7/2010 8:09:33 PM: \\sanna02\SQLBACKUPS\REDGATE_SAN-DB-02\RPAM\FULL_(local)_RPAM_20100707_200933.sqb
7/7/2010 8:09:33 PM: BACKUP DATABASE [RPAM] TO VIRTUAL_DEVICE = 'SQLBACKUP_CCBEFA64-8DD4-4A5E-B276-8536D71D4CA0', VIRTUAL_DEVICE = 'SQLBACKUP_CCBEFA64-8DD4-4A5E-B276-8536D71D4CA001' WITH BUFFERCOUNT = 12, BLOCKSIZE = 65536, MAXTRANSFERSIZE = 1048576, NAME = N'Database (RPAM), 7/7/2010 8:09:33 PM', DESCRIPTION = N'Backup on 7/7/2010 8:09:33 PM Server: SAN-DB-02 Database: RPAM', FORMAT
7/7/2010 8:10:36 PM: Database size : 35.000 GB
7/7/2010 8:10:36 PM: Compressed data size: 2.635 GB
7/7/2010 8:10:36 PM: Compression rate : 92.47%
7/7/2010 8:10:36 PM: Processed 1950248 pages for database 'RPAM', file 'RPAM' on file 1.
7/7/2010 8:10:36 PM: Processed 4 pages for database 'RPAM', file 'RPAM_log' on file 1.
7/7/2010 8:10:36 PM: BACKUP DATABASE successfully processed 1950252 pages in 62.746 seconds (254.621 MB/sec).
7/7/2010 8:10:37 PM:
7/7/2010 8:10:37 PM: Verifying files:
7/7/2010 8:10:37 PM: \\sanna02\SQLBACKUPS\REDGATE_SAN-DB-02\RPAM\FULL_(local)_RPAM_20100707_200933.sqb
7/7/2010 8:10:37 PM:
7/7/2010 8:12:16 PM: The backup set on file 1 is valid.
7/7/2010 8:12:16 PM: Deleting old backup file: \\sanna02\SQLBACKUPS\REDGATE_SAN-DB-02\RPAM\FULL_(local)_RPAM_20100627_200527.sqb
7/7/2010 8:12:16 PM: Backing up SYSENG (full database) to:
7/7/2010 8:12:16 PM: \\sanna02\SQLBACKUPS\REDGATE_SAN-DB-02\SYSENG\FULL_(local)_SYSENG_20100707_201216.sqb
7/7/2010 8:12:16 PM: BACKUP DATABASE [SYSENG] TO VIRTUAL_DEVICE = 'SQLBACKUP_84826644-C51F-4592-A87A-F5F1CB0CEAA2', VIRTUAL_DEVICE = 'SQLBACKUP_84826644-C51F-4592-A87A-F5F1CB0CEAA201' WITH BUFFERCOUNT = 12, BLOCKSIZE = 65536, MAXTRANSFERSIZE = 1048576, NAME = N'Database (SYSENG), 7/7/2010 8:12:16 PM', DESCRIPTION = N'Backup on 7/7/2010 8:12:16 PM Server: SAN-DB-02 Database: SYSENG', FORMAT
7/7/2010 8:12:18 PM: Database size : 37.125 MB
7/7/2010 8:12:18 PM: Compressed data size: 4.163 MB
7/7/2010 8:12:18 PM: Compression rate : 88.79%
7/7/2010 8:12:18 PM: Processed 2720 pages for database 'SYSENG', file 'SYSENG' on file 1.
7/7/2010 8:12:18 PM: Processed 2 pages for database 'SYSENG', file 'SYSENG_log' on file 1.
7/7/2010 8:12:18 PM: BACKUP DATABASE successfully processed 2722 pages in 0.465 seconds (47.941 MB/sec).
7/7/2010 8:12:18 PM:
7/7/2010 8:12:18 PM: Verifying files:
7/7/2010 8:12:18 PM: \\sanna02\SQLBACKUPS\REDGATE_SAN-DB-02\SYSENG\FULL_(local)_SYSENG_20100707_201216.sqb
7/7/2010 8:12:18 PM:
7/7/2010 8:12:19 PM: The backup set on file 1 is valid.
7/7/2010 8:12:19 PM: Deleting old backup file: \\sanna02\SQLBACKUPS\REDGATE_SAN-DB-02\SYSENG\FULL_(local)_SYSENG_20100627_200803.sqb
7/7/2010 8:12:19 PM: Backing up TrackRight (full database) to:
7/7/2010 8:12:19 PM: \\sanna02\SQLBACKUPS\REDGATE_SAN-DB-02\TrackRight\FULL_(local)_TrackRight_20100707_201219.sqb
7/7/2010 8:12:19 PM: BACKUP DATABASE [TrackRight] TO VIRTUAL_DEVICE = 'SQLBACKUP_103123CA-CD18-4AB4-8255-AB3FFF261E6D', VIRTUAL_DEVICE = 'SQLBACKUP_103123CA-CD18-4AB4-8255-AB3FFF261E6D01' WITH BUFFERCOUNT = 12, BLOCKSIZE = 65536, MAXTRANSFERSIZE = 1048576, NAME = N'Database (TrackRight), 7/7/2010 8:12:19 PM', DESCRIPTION = N'Backup on 7/7/2010 8:12:19 PM Server: SAN-DB-02 Database: TrackRight', FORMAT
7/7/2010 8:24:54 PM: Database size : 131.322 GB
7/7/2010 8:24:54 PM: Compressed data size: 31.575 GB
7/7/2010 8:24:54 PM: Compression rate : 75.96%
7/7/2010 8:24:54 PM: Processed 14346592 pages for database 'TrackRight', file 'TrackRight_Data' on file 1.
7/7/2010 8:24:54 PM: Processed 374157 pages for database 'TrackRight', file 'sysft_TrackRight_tblTransaction' on file 1.
7/7/2010 8:24:54 PM: Processed 391565 pages for database 'TrackRight', file 'sysft_TrackRight_tblRecipient' on file 1.
7/7/2010 8:24:54 PM: Processed 8 pages for database 'TrackRight', file 'TrackRight_Log' on file 1.
7/7/2010 8:24:54 PM: BACKUP DATABASE successfully processed 15112321 pages in 753.825 seconds (164.229 MB/sec).
7/7/2010 8:24:54 PM:
7/7/2010 8:24:54 PM: Verifying files:
7/7/2010 8:24:54 PM: \\sanna02\SQLBACKUPS\REDGATE_SAN-DB-02\TrackRight\FULL_(local)_TrackRight_20100707_201219.sqb
7/7/2010 8:24:54 PM:
7/7/2010 8:43:34 PM: The backup set on file 1 is valid.
7/7/2010 8:43:34 PM: Deleting old backup file: \\sanna02\SQLBACKUPS\REDGATE_SAN-DB-02\TrackRight\FULL_(local)_TrackRight_20100626_200848.sqb
7/7/2010 8:43:34 PM: Deleting old backup file: \\sanna02\SQLBACKUPS\REDGATE_SAN-DB-02\TrackRight\FULL_(local)_TrackRight_20100627_200805.sqb
7/7/2010 8:43:34 PM: Backing up TrackRight Demo (full database) to:
7/7/2010 8:43:34 PM: \\sanna02\SQLBACKUPS\REDGATE_SAN-DB-02\TrackRight Demo\FULL_(local)_TrackRight Demo_20100707_204334.sqb
7/7/2010 8:43:34 PM: BACKUP DATABASE [TrackRight Demo] TO VIRTUAL_DEVICE = 'SQLBACKUP_55ABD5AB-2BE3-4E5C-A167-FEBE27EC089F', VIRTUAL_DEVICE = 'SQLBACKUP_55ABD5AB-2BE3-4E5C-A167-FEBE27EC089F01' WITH BUFFERCOUNT = 12, BLOCKSIZE = 65536, MAXTRANSFERSIZE = 1048576, NAME = N'Database (TrackRight Demo), 7/7/2010 8:43:34 PM', DESCRIPTION = N'Backup on 7/7/2010 8:43:34 PM Server: SAN-DB-02 Database: TrackRight Demo', FORMAT
7/7/2010 8:43:35 PM: Database size : 30.313 MB
7/7/2010 8:43:35 PM: Compressed data size: 512.000 KB
7/7/2010 8:43:35 PM: Compression rate : 98.35%
7/7/2010 8:43:35 PM: Processed 312 pages for database 'TrackRight Demo', file 'TrackRight_Data' on file 1.
7/7/2010 8:43:35 PM: Processed 1 pages for database 'TrackRight Demo', file 'TrackRight_Log' on file 1.
7/7/2010 8:43:35 PM: BACKUP DATABASE successfully processed 313 pages in 0.200 seconds (12.820 MB/sec).
7/7/2010 8:43:36 PM: Validation of all backup files failed.
7/7/2010 8:43:36 PM: Backing up TrackRightNewDemo (full database) to:
7/7/2010 8:43:36 PM: \\sanna02\SQLBACKUPS\REDGATE_SAN-DB-02\TrackRightNewDemo\FULL_(local)_TrackRightNewDemo_20100707_204336.sqb
7/7/2010 8:43:36 PM: BACKUP DATABASE [TrackRightNewDemo] TO VIRTUAL_DEVICE = 'SQLBACKUP_DB8AEE83-46DD-41D9-8122-B64AEA49660D', VIRTUAL_DEVICE = 'SQLBACKUP_DB8AEE83-46DD-41D9-8122-B64AEA49660D01' WITH BUFFERCOUNT = 12, BLOCKSIZE = 65536, MAXTRANSFERSIZE = 1048576, NAME = N'Database (TrackRightNewDemo), 7/7/2010 8:43:36 PM', DESCRIPTION = N'Backup on 7/7/2010 8:43:36 PM Server: SAN-DB-02 Database: TrackRightNewDemo', FORMAT
7/7/2010 8:43:47 PM: Database size : 8.520 GB
7/7/2010 8:43:47 PM: Compressed data size: 395.500 MB
7/7/2010 8:43:47 PM: Compression rate : 95.47%
7/7/2010 8:43:47 PM: Processed 242272 pages for database 'TrackRightNewDemo', file 'TrackRight_Data' on file 1.
7/7/2010 8:43:47 PM: Processed 2511 pages for database 'TrackRightNewDemo', file 'sysft_TrackRight_tblRecipient' on file 1.
7/7/2010 8:43:47 PM: Processed 4887 pages for database 'TrackRightNewDemo', file 'sysft_TrackRightNewDemo_tblTransaction' on file 1.
7/7/2010 8:43:47 PM: Processed 4 pages for database 'TrackRightNewDemo', file 'TrackRight_Log' on file 1.
7/7/2010 8:43:47 PM: BACKUP DATABASE successfully processed 249673 pages in 10.507 seconds (194.662 MB/sec).
7/7/2010 8:43:48 PM:
7/7/2010 8:43:48 PM: Verifying files:
7/7/2010 8:43:48 PM: \\sanna02\SQLBACKUPS\REDGATE_SAN-DB-02\TrackRightNewDemo\FULL_(local)_TrackRightNewDemo_20100707_204336.sqb
7/7/2010 8:43:48 PM:
7/7/2010 8:44:10 PM: The backup set on file 1 is valid.
7/7/2010 8:44:10 PM: Deleting old backup file: \\sanna02\SQLBACKUPS\REDGATE_SAN-DB-02\TrackRightNewDemo\FULL_(local)_TrackRightNewDemo_20100626_203829.sqb
7/7/2010 8:44:10 PM: Deleting old backup file: \\sanna02\SQLBACKUPS\REDGATE_SAN-DB-02\TrackRightNewDemo\FULL_(local)_TrackRightNewDemo_20100627_203928.sqb
7/7/2010 8:44:10 PM: Backing up USPSEC (full database) to:
7/7/2010 8:44:10 PM: \\sanna02\SQLBACKUPS\REDGATE_SAN-DB-02\USPSEC\FULL_(local)_USPSEC_20100707_204410.sqb
7/7/2010 8:44:10 PM: BACKUP DATABASE [USPSEC] TO VIRTUAL_DEVICE = 'SQLBACKUP_DBDA2E38-AF4A-4049-9830-52305901A890', VIRTUAL_DEVICE = 'SQLBACKUP_DBDA2E38-AF4A-4049-9830-52305901A89001' WITH BUFFERCOUNT = 12, BLOCKSIZE = 65536, MAXTRANSFERSIZE = 1048576, NAME = N'Database (USPSEC), 7/7/2010 8:44:10 PM', DESCRIPTION = N'Backup on 7/7/2010 8:44:10 PM Server: SAN-DB-02 Database: USPSEC', FORMAT
7/7/2010 8:44:18 PM: Database size : 2.403 GB
7/7/2010 8:44:18 PM: Compressed data size: 263.859 MB
7/7/2010 8:44:18 PM: Compression rate : 89.28%
7/7/2010 8:44:18 PM: Processed 266208 pages for database 'USPSEC', file 'USPSEC' on file 1.
7/7/2010 8:44:18 PM: Processed 2 pages for database 'USPSEC', file 'USPSEC_log' on file 1.
7/7/2010 8:44:18 PM: BACKUP DATABASE successfully processed 266210 pages in 6.848 seconds (318.456 MB/sec).
7/7/2010 8:44:18 PM:
7/7/2010 8:44:18 PM: Verifying files:
7/7/2010 8:44:18 PM: \\sanna02\SQLBACKUPS\REDGATE_SAN-DB-02\USPSEC\FULL_(local)_USPSEC_20100707_204410.sqb
7/7/2010 8:44:18 PM:
7/7/2010 8:44:33 PM: The backup set on file 1 is valid.
7/7/2010 8:44:33 PM: Deleting old backup file: \\sanna02\SQLBACKUPS\REDGATE_SAN-DB-02\USPSEC\FULL_(local)_USPSEC_20100626_203900.sqb
7/7/2010 8:44:33 PM: Deleting old backup file: \\sanna02\SQLBACKUPS\REDGATE_SAN-DB-02\USPSEC\FULL_(local)_USPSEC_20100627_203956.sqb
7/7/2010 8:44:33 PM: Backing up USPSEC - CPNET (full database) to:
7/7/2010 8:44:33 PM: \\sanna02\SQLBACKUPS\REDGATE_SAN-DB-02\USPSEC - CPNET\FULL_(local)_USPSEC - CPNET_20100707_204433.sqb
7/7/2010 8:44:34 PM: BACKUP DATABASE [USPSEC - CPNET] TO VIRTUAL_DEVICE = 'SQLBACKUP_69240010-7559-45A0-B1AA-D9521E0E4154', VIRTUAL_DEVICE = 'SQLBACKUP_69240010-7559-45A0-B1AA-D9521E0E415401' WITH BUFFERCOUNT = 12, BLOCKSIZE = 65536, MAXTRANSFERSIZE = 1048576, NAME = N'Database (USPSEC - CPNET), 7/7/2010 8:44:33 PM', DESCRIPTION = N'Backup on 7/7/2010 8:44:33 PM Server: SAN-DB-02 Database: USPSEC - CPNET', FORMAT
7/7/2010 8:44:35 PM: Database size : 1.666 GB
7/7/2010 8:44:35 PM: Compressed data size: 14.854 MB
7/7/2010 8:44:35 PM: Compression rate : 99.13%
7/7/2010 8:44:35 PM: Processed 13696 pages for database 'USPSEC - CPNET', file 'USPSEC - CPNET' on file 1.
7/7/2010 8:44:35 PM: Processed 1 pages for database 'USPSEC - CPNET', file 'USPSEC - CPNET_log' on file 1.
7/7/2010 8:44:35 PM: BACKUP DATABASE successfully processed 13697 pages in 0.498 seconds (225.312 MB/sec).
7/7/2010 8:44:35 PM:
7/7/2010 8:44:35 PM: Verifying files:
7/7/2010 8:44:35 PM: \\sanna02\SQLBACKUPS\REDGATE_SAN-DB-02\USPSEC - CPNET\FULL_(local)_USPSEC - CPNET_20100707_204433.sqb
7/7/2010 8:44:35 PM:
7/7/2010 8:44:36 PM: The backup set on file 1 is valid.
7/7/2010 8:44:36 PM: Deleting old backup file: \\sanna02\SQLBACKUPS\REDGATE_SAN-DB-02\USPSEC - CPNET\FULL_(local)_USPSEC - CPNET_20100626_203923.sqb 7/7/2010 8:44:36 PM: Deleting old backup file: \\sanna02\SQLBACKUPS\REDGATE_SAN-DB-02\USPSEC - CPNET\FULL_(local)_USPSEC - CPNET_20100627_204015.sqb
7/7/2010 8:44:36 PM: Backing up USPSElectronic Confirmation (full database) to:
7/7/2010 8:44:36 PM: \\sanna02\SQLBACKUPS\REDGATE_SAN-DB-02\USPSElectronic Confirmation\FULL_(local)_USPSElectronic Confirmation_20100707_204436.sqb
7/7/2010 8:44:37 PM: BACKUP DATABASE [USPSElectronic Confirmation] TO VIRTUAL_DEVICE = 'SQLBACKUP_E64D9129-671A-497B-9AF7-F79BA7DBA114', VIRTUAL_DEVICE = 'SQLBACKUP_E64D9129-671A-497B-9AF7-F79BA7DBA11401' WITH BUFFERCOUNT = 12, BLOCKSIZE = 65536, MAXTRANSFERSIZE = 1048576, NAME = N'Database (USPSElectronic Confirmation), 7/7/2010 8:44:36 PM', DESCRIPTION = N'Backup on 7/7/2010 8:44:36 PM Server: SAN-DB-02 Database: USPSElectronic Confirmation', FORMAT
7/7/2010 8:44:38 PM: Database size : 771.625 MB
7/7/2010 8:44:38 PM: Compressed data size: 42.013 MB
7/7/2010 8:44:38 PM: Compression rate : 94.56%
7/7/2010 8:44:38 PM: Processed 44960 pages for database 'USPSElectronic Confirmation', file 'USPSElectronicConfirmation_Data' on file 1.
7/7/2010 8:44:38 PM: Processed 2 pages for database 'USPSElectronic Confirmation', file 'USPSElectronicConfirmation_Log' on file 1.
7/7/2010 8:44:38 PM: BACKUP DATABASE successfully processed 44962 pages in 1.132 seconds (325.372 MB/sec).
7/7/2010 8:44:39 PM:
7/7/2010 8:44:39 PM: Verifying files:
7/7/2010 8:44:39 PM: \\sanna02\SQLBACKUPS\REDGATE_SAN-DB-02\USPSElectronic Confirmation\FULL_(local)_USPSElectronic Confirmation_20100707_204436.sqb
7/7/2010 8:44:39 PM:
7/7/2010 8:44:41 PM: The backup set on file 1 is valid.
7/7/2010 8:44:41 PM: Deleting old backup file: \\sanna02\SQLBACKUPS\REDGATE_SAN-DB-02\USPSElectronic Confirmation\FULL_(local)_USPSElectronic Confirmation_20100626_203926.sqb 7/7/2010 8:44:41 PM: Deleting old backup file: \\sanna02\SQLBACKUPS\REDGATE_SAN-DB-02\USPSElectronic Confirmation\FULL_(local)_USPSElectronic Confirmation_20100627_204018.sqb
7/7/2010 8:44:41 PM: Backing up USPSElectronic Confirmation - CPNET (full database) to:
7/7/2010 8:44:41 PM: \\sanna02\SQLBACKUPS\REDGATE_SAN-DB-02\USPSElectronic Confirmation - CPNET\FULL_(local)_USPSElectronic Confirmation - CPNET_20100707_204441.sqb
7/7/2010 8:44:42 PM: BACKUP DATABASE [USPSElectronic Confirmation - CPNET] TO VIRTUAL_DEVICE = 'SQLBACKUP_9A97B3ED-8ACA-43B1-930A-3569D4AA41AC', VIRTUAL_DEVICE = 'SQLBACKUP_9A97B3ED-8ACA-43B1-930A-3569D4AA41AC01' WITH BUFFERCOUNT = 12, BLOCKSIZE = 65536, MAXTRANSFERSIZE = 1048576, NAME = N'Database (USPSElectronic Confirmation - CPNET), 7/7/2010 8:44:41 PM', DESCRIPTION = N'Backup on 7/7/2010 8:44:41 PM Server: SAN-DB-02 Database: USPSElectronic Confirmation - CPNET', FORMAT
7/7/2010 8:44:42 PM: Database size : 16.500 MB
7/7/2010 8:44:42 PM: Compressed data size: 1.011 MB
7/7/2010 8:44:42 PM: Compression rate : 93.87%
7/7/2010 8:44:42 PM: Processed 864 pages for database 'USPSElectronic Confirmation - CPNET', file 'USPSElectronic Confirmation - CPNET' on file 1.
7/7/2010 8:44:42 PM: Processed 1 pages for database 'USPSElectronic Confirmation - CPNET', file 'USPSElectronic Confirmation - CPNET_log' on file 1.
7/7/2010 8:44:42 PM: BACKUP DATABASE successfully processed 865 pages in 0.188 seconds (37.691 MB/sec).
7/7/2010 8:44:43 PM:
7/7/2010 8:44:43 PM: Verifying files:
7/7/2010 8:44:43 PM: \\sanna02\SQLBACKUPS\REDGATE_SAN-DB-02\USPSElectronic Confirmation - CPNET\FULL_(local)_USPSElectronic Confirmation - CPNET_20100707_204441.sqb
7/7/2010 8:44:43 PM:
7/7/2010 8:44:43 PM: The backup set on file 1 is valid.
7/7/2010 8:44:43 PM: Deleting old backup file: \\sanna02\SQLBACKUPS\REDGATE_SAN-DB-02\USPSElectronic Confirmation - CPNET\FULL_(local)_USPSElectronic Confirmation - CPNET_20100627_204023.sqb 7/7/2010 8:44:43 PM: Deleting old backup file: \\sanna02\SQLBACKUPS\REDGATE_SAN-DB-02\USPSElectronic Confirmation - CPNET\FULL_(local)_USPSElectronic Confirmation - CPNET_20100626_203931.sqb
7/7/2010 8:44:43 PM: Backing up USPSElectronic Confirmation - YA (full database) to:
7/7/2010 8:44:43 PM: \\sanna02\SQLBACKUPS\REDGATE_SAN-DB-02\USPSElectronic Confirmation - YA\FULL_(local)_USPSElectronic Confirmation - YA_20100707_204443.sqb
7/7/2010 8:44:44 PM: BACKUP DATABASE [USPSElectronic Confirmation - YA] TO VIRTUAL_DEVICE = 'SQLBACKUP_673FF532-9FF6-45C8-8065-DF019D9319D0', VIRTUAL_DEVICE = 'SQLBACKUP_673FF532-9FF6-45C8-8065-DF019D9319D001' WITH BUFFERCOUNT = 12, BLOCKSIZE = 65536, MAXTRANSFERSIZE = 1048576, NAME = N'Database (USPSElectronic Confirmation - YA), 7/7/2010 8:44:43 PM', DESCRIPTION = N'Backup on 7/7/2010 8:44:43 PM Server: SAN-DB-02 Database: USPSElectronic Confirmation - YA', FORMAT
7/7/2010 8:44:44 PM: Database size : 240.563 MB
7/7/2010 8:44:44 PM: Compressed data size: 2.933 MB
7/7/2010 8:44:44 PM: Compression rate : 98.78%
7/7/2010 8:44:44 PM: Processed 2720 pages for database 'USPSElectronic Confirmation - YA', file 'USPSElectronicConfirmation_Data' on file 1.
7/7/2010 8:44:44 PM: Processed 1 pages for database 'USPSElectronic Confirmation - YA', file 'USPSElectronicConfirmation_Log' on file 1.
7/7/2010 8:44:44 PM: BACKUP DATABASE successfully processed 2721 pages in 0.245 seconds (90.981 MB/sec).
7/7/2010 8:44:45 PM:
7/7/2010 8:44:45 PM: Verifying files:
7/7/2010 8:44:45 PM: \\sanna02\SQLBACKUPS\REDGATE_SAN-DB-02\USPSElectronic Confirmation - YA\FULL_(local)_USPSElectronic Confirmation - YA_20100707_204443.sqb
7/7/2010 8:44:45 PM:
7/7/2010 8:44:45 PM: The backup set on file 1 is valid.
7/7/2010 8:44:45 PM: Deleting old backup file: \\sanna02\SQLBACKUPS\REDGATE_SAN-DB-02\USPSElectronic Confirmation - YA\FULL_(local)_USPSElectronic Confirmation - YA_20100627_204026.sqb 7/7/2010 8:44:45 PM: Deleting old backup file: \\sanna02\SQLBACKUPS\REDGATE_SAN-DB-02\USPSElectronic Confirmation - YA\FULL_(local)_USPSElectronic Confirmation - YA_20100626_203933.sqb
7/7/2010 8:44:45 PM: Backing up WalzGroupWeb (full database) to:
7/7/2010 8:44:45 PM: \\sanna02\SQLBACKUPS\REDGATE_SAN-DB-02\WalzGroupWeb\FULL_(local)_WalzGroupWeb_20100707_204445.sqb
7/7/2010 8:44:46 PM: BACKUP DATABASE [WalzGroupWeb] TO VIRTUAL_DEVICE = 'SQLBACKUP_A7CF6643-03C3-4494-9507-0D4BCCF43FA6', VIRTUAL_DEVICE = 'SQLBACKUP_A7CF6643-03C3-4494-9507-0D4BCCF43FA601' WITH BUFFERCOUNT = 12, BLOCKSIZE = 65536, MAXTRANSFERSIZE = 1048576, NAME = N'Database (WalzGroupWeb), 7/7/2010 8:44:45 PM', DESCRIPTION = N'Backup on 7/7/2010 8:44:45 PM Server: SAN-DB-02 Database: WalzGroupWeb', FORMAT
7/7/2010 8:44:47 PM: Database size : 11.000 MB
7/7/2010 8:44:47 PM: Compressed data size: 352.500 KB
7/7/2010 8:44:47 PM: Compression rate : 96.87%
7/7/2010 8:44:47 PM: Processed 288 pages for database 'WalzGroupWeb', file 'WalzGroupWeb' on file 1.
7/7/2010 8:44:47 PM: Processed 1 pages for database 'WalzGroupWeb', file 'WalzGroupWeb_log' on file 1.
7/7/2010 8:44:47 PM: BACKUP DATABASE successfully processed 289 pages in 0.174 seconds (13.606 MB/sec).
7/7/2010 8:44:47 PM:
7/7/2010 8:44:47 PM: Verifying files:
7/7/2010 8:44:47 PM: \\sanna02\SQLBACKUPS\REDGATE_SAN-DB-02\WalzGroupWeb\FULL_(local)_WalzGroupWeb_20100707_204445.sqb
7/7/2010 8:44:47 PM:
7/7/2010 8:44:48 PM: The backup set on file 1 is valid.
7/7/2010 8:44:48 PM: Deleting old backup file: \\sanna02\SQLBACKUPS\REDGATE_SAN-DB-02\WalzGroupWeb\FULL_(local)_WalzGroupWeb_20100626_203935.sqb
7/7/2010 8:44:48 PM: Deleting old backup file: \\sanna02\SQLBACKUPS\REDGATE_SAN-DB-02\WalzGroupWeb\FULL_(local)_WalzGroupWeb_20100627_204028.sqb
7/7/2010 8:44:48 PM: Backing up WalzImaging (full database) to:
7/7/2010 8:44:48 PM: \\sanna02\SQLBACKUPS\REDGATE_SAN-DB-02\WalzImaging\FULL_(local)_WalzImaging_20100707_204448.sqb
7/7/2010 8:44:49 PM: BACKUP DATABASE [WalzImaging] TO VIRTUAL_DEVICE = 'SQLBACKUP_D5B4F9B7-99BC-428B-830E-BFD5EA549FA0', VIRTUAL_DEVICE = 'SQLBACKUP_D5B4F9B7-99BC-428B-830E-BFD5EA549FA001' WITH BUFFERCOUNT = 12, BLOCKSIZE = 65536, MAXTRANSFERSIZE = 1048576, NAME = N'Database (WalzImaging), 7/7/2010 8:44:48 PM', DESCRIPTION = N'Backup on 7/7/2010 8:44:48 PM Server: SAN-DB-02 Database: WalzImaging', FORMAT
7/7/2010 8:44:55 PM: Database size : 1.409 GB
7/7/2010 8:44:55 PM: Compressed data size: 241.447 MB
7/7/2010 8:44:55 PM: Compression rate : 83.26%
7/7/2010 8:44:55 PM: Processed 118904 pages for database 'WalzImaging', file 'Imaging_Data' on file 1.
7/7/2010 8:44:55 PM: Processed 1 pages for database 'WalzImaging', file 'Imaging_Log' on file 1.
7/7/2010 8:44:55 PM: BACKUP DATABASE successfully processed 118905 pages in 6.131 seconds (158.876 MB/sec).
7/7/2010 8:44:56 PM:
7/7/2010 8:44:56 PM: Verifying files:
7/7/2010 8:44:56 PM: \\sanna02\SQLBACKUPS\REDGATE_SAN-DB-02\WalzImaging\FULL_(local)_WalzImaging_20100707_204448.sqb
7/7/2010 8:44:56 PM:
7/7/2010 8:45:09 PM: The backup set on file 1 is valid.
7/7/2010 8:45:09 PM: Deleting old backup file: \\sanna02\SQLBACKUPS\REDGATE_SAN-DB-02\WalzImaging\FULL_(local)_WalzImaging_20100626_203937.sqb
7/7/2010 8:45:09 PM: Deleting old backup file: \\sanna02\SQLBACKUPS\REDGATE_SAN-DB-02\WalzImaging\FULL_(local)_WalzImaging_20100627_204029.sqb
7/7/2010 8:45:09 PM: Backing up WalzPostal (full database) to:
7/7/2010 8:45:09 PM: \\sanna02\SQLBACKUPS\REDGATE_SAN-DB-02\WalzPostal\FULL_(local)_WalzPostal_20100707_204509.sqb
7/7/2010 8:45:10 PM: BACKUP DATABASE [WalzPostal] TO VIRTUAL_DEVICE = 'SQLBACKUP_713DD93A-62CD-438E-AD87-4518E0DDF256', VIRTUAL_DEVICE = 'SQLBACKUP_713DD93A-62CD-438E-AD87-4518E0DDF25601' WITH BUFFERCOUNT = 12, BLOCKSIZE = 65536, MAXTRANSFERSIZE = 1048576, NAME = N'Database (WalzPostal), 7/7/2010 8:45:09 PM', DESCRIPTION = N'Backup on 7/7/2010 8:45:09 PM Server: SAN-DB-02 Database: WalzPostal', FORMAT
7/7/2010 8:45:12 PM: Database size : 165.867 MB
7/7/2010 8:45:12 PM: Compressed data size: 39.646 MB
7/7/2010 8:45:12 PM: Compression rate : 76.10%
7/7/2010 8:45:12 PM: Processed 15600 pages for database 'WalzPostal', file 'Walz_Data' on file 1.
7/7/2010 8:45:12 PM: Processed 1348 pages for database 'WalzPostal', file 'Walz_Log' on file 1.
7/7/2010 8:45:12 PM: BACKUP DATABASE successfully processed 16948 pages in 1.073 seconds (129.386 MB/sec).
7/7/2010 8:45:12 PM:
7/7/2010 8:45:12 PM: Verifying files:
7/7/2010 8:45:12 PM: \\sanna02\SQLBACKUPS\REDGATE_SAN-DB-02\WalzPostal\FULL_(local)_WalzPostal_20100707_204509.sqb
7/7/2010 8:45:12 PM:
7/7/2010 8:45:14 PM: The backup set on file 1 is valid.
7/7/2010 8:45:14 PM: Deleting old backup file: \\sanna02\SQLBACKUPS\REDGATE_SAN-DB-02\WalzPostal\FULL_(local)_WalzPostal_20100626_203955.sqb
7/7/2010 8:45:14 PM: Deleting old backup file: \\sanna02\SQLBACKUPS\REDGATE_SAN-DB-02\WalzPostal\FULL_(local)_WalzPostal_20100627_204047.sqb
7/7/2010 8:45:14 PM: Backing up WSOImaging (full database) to:
7/7/2010 8:45:14 PM: \\sanna02\SQLBACKUPS\REDGATE_SAN-DB-02\WSOImaging\FULL_(local)_WSOImaging_20100707_204514.sqb
7/7/2010 8:45:15 PM: BACKUP DATABASE [WSOImaging] TO VIRTUAL_DEVICE = 'SQLBACKUP_087CDB37-27B8-46DF-A3F5-3A1BFC339072', VIRTUAL_DEVICE = 'SQLBACKUP_087CDB37-27B8-46DF-A3F5-3A1BFC33907201' WITH BUFFERCOUNT = 12, BLOCKSIZE = 65536, MAXTRANSFERSIZE = 1048576, NAME = N'Database (WSOImaging), 7/7/2010 8:45:14 PM', DESCRIPTION = N'Backup on 7/7/2010 8:45:14 PM Server: SAN-DB-02 Database: WSOImaging', FORMAT
7/7/2010 8:46:22 PM: Database size : 17.267 GB
7/7/2010 8:46:22 PM: Compressed data size: 2.561 GB
7/7/2010 8:46:22 PM: Compression rate : 85.17%
7/7/2010 8:46:22 PM: Processed 1535632 pages for database 'WSOImaging', file 'WSOImaging_Data' on file 1.
7/7/2010 8:46:22 PM: Processed 4 pages for database 'WSOImaging', file 'WSOImaging_Log' on file 1.
7/7/2010 8:46:22 PM: BACKUP DATABASE successfully processed 1535636 pages in 66.374 seconds (189.530 MB/sec).
7/7/2010 8:46:23 PM:
7/7/2010 8:46:23 PM: Verifying files:
7/7/2010 8:46:23 PM: \\sanna02\SQLBACKUPS\REDGATE_SAN-DB-02\WSOImaging\FULL_(local)_WSOImaging_20100707_204514.sqb
7/7/2010 8:46:23 PM:
7/7/2010 8:48:05 PM: The backup set on file 1 is valid.
7/7/2010 8:48:05 PM: Deleting old backup file: \\sanna02\SQLBACKUPS\REDGATE_SAN-DB-02\WSOImaging\FULL_(local)_WSOImaging_20100626_204000.sqb
7/7/2010 8:48:05 PM: Deleting old backup file: \\sanna02\SQLBACKUPS\REDGATE_SAN-DB-02\WSOImaging\FULL_(local)_WSOImaging_20100627_204051.sqb
This problem continues to happen where the log would show as:
Main: SQL Backup required 0 bytes of free SQL Server memory, which was not available.
This is normally during verification. When I do a manual verify of the file that was created, it shows that the backup file is valid. However, this is an additional manual process and resolving the issue about requiring 0 bytes of free SQL Server memory can probably help out a lot.
Email notification:
7/18/2010 8:41:04 PM: VDI error 1010: Failed to get the configuration from the server because the timeout interval has elapsed. SQL Backup required 0 bytes of free SQL Server memory, which was not available. VDI error: An abort request is preventing anything except termination actions.
7/18/2010 8:41:04 PM: SQL error 3013: VERIFY DATABASE is terminating abnormally.
7/18/2010 8:41:04 PM: SQL error 18210: BackupVirtualDeviceSet::Initialize: Request large buffers failure on backup device 'SQLBACKUP_BF059D37-01AF-4A5A-8D75-E91CC6ACAF21'. Operating system error 0x8007000e(Not enough storage is available to complete this operation.).
7/18/2010 8:41:04 PM:
7/18/2010 8:41:04 PM: Memory profile
7/18/2010 8:41:04 PM: Type Maximum Minimum Average Blk count Total
7/18/2010 8:41:04 PM:
7/18/2010 8:41:04 PM: Commit 296353792 4096 158056 7608 1202491392
7/18/2010 8:41:04 PM: Reserve 4190208 4096 182621 5066 925159424
7/18/2010 8:41:04 PM: Free 458752 4096 55062 359 19767296
7/18/2010 8:41:04 PM: Private 296353792 4096 167533 11874 1989296128
7/18/2010 8:41:04 PM: Mapped 1060864 4096 112364 171 19214336
7/18/2010 8:41:04 PM: Image 24948736 4096 189412 629 119140352
7/18/2010 8:41:04 PM:
SQL Backup requires SQL Server to have a certain amount of free memory in order to perform backup, restore, and verification operations. In your case, SQL Server could not service the verification request due to the lack of free memory and raised the following error:
From the log, we can see that the largest contiguous free memory block was only 458,752 bytes. Total free memory was 19,767,296 bytes, spread over 359 blocks, which indicates a very fragmented memory space.
Interestingly, subsequent backups succeeded. Do you happen to be running two or more backups simultaneously, or are you running some memory intensive SQL Server maintenance tasks at the same time?
Thanks.
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 8
On this server, we have log-backup occuring every 15 minutes, and there are 5 databases that is also mirrored (high-safety mirroring) to another DB server. Aside from those activities, there's really not much going on at that time-frame.
Would you recommend a different set of steps for the FULL backup and the VERIFY backup? I'm not sure if that would help, but my goal for that is to isolate the result of those two. It's kind of alarming to see that the FULL backup fails everyday although it was actually the VERIFY that did error out.
Thanks a lot!