manual backup works, but scheduled gives error
clinford
Posts: 8
Hi, I am using SQL Backup version 5.2.0.2825 and am running into a problem with scheduling backups.
I can do a manual backup without problems, but when I try to schedule the backup, I get an error, and it refuses to run.
The jobs tab says "Your SQL Server Agent does not appear to be running", with a link to "Start SQL Server Agent"
When I click that, the error I get is this:
StartService() returned error 5, 'Access is denied.'
Why would the manual backup work fine, when the scheduled backup won't even try?? Is the scheduled backup losing the credentials it needs?
I don't see any log files for the scheduled log--but here is the log for the manual one:
I can do a manual backup without problems, but when I try to schedule the backup, I get an error, and it refuses to run.
The jobs tab says "Your SQL Server Agent does not appear to be running", with a link to "Start SQL Server Agent"
When I click that, the error I get is this:
StartService() returned error 5, 'Access is denied.'
Why would the manual backup work fine, when the scheduled backup won't even try?? Is the scheduled backup losing the credentials it needs?
I don't see any log files for the scheduled log--but here is the log for the manual one:
SQL Backup log file 5.2.0.2825
11/6/2008 8:49:04 AM: Backing up ITAssist (full database) to:
11/6/2008 8:49:04 AM: C:\Documents and Settings\Administrator.212RESOURCES\Desktop\sharepoint_backup\FULL_(local)_ITAssist_20081106_084904.sqb
11/6/2008 8:49:04 AM: BACKUP DATABASE [ITAssist] TO DISK = 'C:\Documents and Settings\Administrator.212RESOURCES\Desktop\sharepoint_backup\<AUTO>.sqb' WITH NAME = '<AUTO>', DESCRIPTION = '<AUTO>', COMPRESSION = 1
11/6/2008 8:49:05 AM: Database size : 9.188 MB
11/6/2008 8:49:05 AM: Compressed data size: 1.343 MB
11/6/2008 8:49:05 AM: Compression rate : 85.38%
Processed 1000 pages for database 'ITAssist', file 'ITAssist' on file 1.
Processed 3 pages for database 'ITAssist', file 'ITAssist_Log' on file 1.
BACKUP DATABASE successfully processed 1003 pages in 0.130 seconds (63.153 MB/sec).
11/6/2008 8:49:05 AM: Backing up master (full database) to:
11/6/2008 8:49:05 AM: C:\Documents and Settings\Administrator.212RESOURCES\Desktop\sharepoint_backup\FULL_(local)_master_20081106_084905.sqb
11/6/2008 8:49:05 AM: BACKUP DATABASE [master] TO DISK = 'C:\Documents and Settings\Administrator.212RESOURCES\Desktop\sharepoint_backup\<AUTO>.sqb' WITH NAME = '<AUTO>', DESCRIPTION = '<AUTO>', COMPRESSION = 1
11/6/2008 8:49:06 AM: Database size : 4.750 MB
11/6/2008 8:49:06 AM: Compressed data size: 638.500 KB
11/6/2008 8:49:06 AM: Compression rate : 86.87%
Processed 360 pages for database 'master', file 'master' on file 1.
Processed 2 pages for database 'master', file 'mastlog' on file 1.
BACKUP DATABASE successfully processed 362 pages in 0.040 seconds (74.035 MB/sec).
11/6/2008 8:49:06 AM: Backing up model (full database) to:
11/6/2008 8:49:06 AM: C:\Documents and Settings\Administrator.212RESOURCES\Desktop\sharepoint_backup\FULL_(local)_model_20081106_084906.sqb
11/6/2008 8:49:06 AM: BACKUP DATABASE [model] TO DISK = 'C:\Documents and Settings\Administrator.212RESOURCES\Desktop\sharepoint_backup\<AUTO>.sqb' WITH NAME = '<AUTO>', DESCRIPTION = '<AUTO>', COMPRESSION = 1
11/6/2008 8:49:07 AM: Database size : 10.188 MB
11/6/2008 8:49:07 AM: Compressed data size: 164.500 KB
11/6/2008 8:49:07 AM: Compression rate : 98.42%
Processed 152 pages for database 'model', file 'modeldev' on file 1.
Processed 2 pages for database 'model', file 'modellog' on file 1.
BACKUP DATABASE successfully processed 154 pages in 0.034 seconds (36.984 MB/sec).
11/6/2008 8:49:07 AM: Backing up project_Content (full database) to:
11/6/2008 8:49:07 AM: C:\Documents and Settings\Administrator.212RESOURCES\Desktop\sharepoint_backup\FULL_(local)_project_Content_20081106_084907.sqb
11/6/2008 8:49:07 AM: BACKUP DATABASE [project_Content] TO DISK = 'C:\Documents and Settings\Administrator.212RESOURCES\Desktop\sharepoint_backup\<AUTO>.sqb' WITH NAME = '<AUTO>', DESCRIPTION = '<AUTO>', COMPRESSION = 1
11/6/2008 8:49:08 AM: Database size : 11.688 MB
11/6/2008 8:49:08 AM: Compressed data size: 2.229 MB
11/6/2008 8:49:08 AM: Compression rate : 80.92%
Processed 1080 pages for database 'project_Content', file 'project_Content' on file 1.
Processed 1 pages for database 'project_Content', file 'project_Content_log' on file 1.
BACKUP DATABASE successfully processed 1081 pages in 0.109 seconds (81.243 MB/sec).
11/6/2008 8:49:08 AM: Backing up PWA_Archive_92C688B4_B110_48C8_938A_B3D0F6C8C823 (full database) to:
11/6/2008 8:49:08 AM: C:\Documents and Settings\Administrator.212RESOURCES\Desktop\sharepoint_backup\FULL_(local)_PWA_Archive_92C688B4_B110_48C8_938A_B3D0F6C8C823_20081106_084908.sqb
11/6/2008 8:49:08 AM: BACKUP DATABASE [PWA_Archive_92C688B4_B110_48C8_938A_B3D0F6C8C823] TO DISK = 'C:\Documents and Settings\Administrator.212RESOURCES\Desktop\sharepoint_backup\<AUTO>.sqb' WITH NAME = '<AUTO>', DESCRIPTION = '<AUTO>', COMPRESSION = 1
11/6/2008 8:49:09 AM: Database size : 7.438 MB
11/6/2008 8:49:09 AM: Compressed data size: 1.154 MB
11/6/2008 8:49:09 AM: Compression rate : 84.48%
Processed 768 pages for database 'PWA_Archive_92C688B4_B110_48C8_938A_B3D0F6C8C823', file 'PWA_Archive_92C688B4_B110_48C8_938A_B3D0F6C8C823' on file 1.
Processed 1 pages for database 'PWA_Archive_92C688B4_B110_48C8_938A_B3D0F6C8C823', file 'PWA_Archive_92C688B4_B110_48C8_938A_B3D0F6C8C823_log' on file 1.
BACKUP DATABASE successfully processed 769 pages in 0.083 seconds (75.899 MB/sec).
11/6/2008 8:49:09 AM: Backing up PWA_Archive_C29A8919_7044_4035_B6CF_64B5D047C98D (full database) to:
11/6/2008 8:49:09 AM: C:\Documents and Settings\Administrator.212RESOURCES\Desktop\sharepoint_backup\FULL_(local)_PWA_Archive_C29A8919_7044_4035_B6CF_64B5D047C98D_20081106_084909.sqb
11/6/2008 8:49:09 AM: BACKUP DATABASE [PWA_Archive_C29A8919_7044_4035_B6CF_64B5D047C98D] TO DISK = 'C:\Documents and Settings\Administrator.212RESOURCES\Desktop\sharepoint_backup\<AUTO>.sqb' WITH NAME = '<AUTO>', DESCRIPTION = '<AUTO>', COMPRESSION = 1
11/6/2008 8:49:10 AM: Database size : 8.438 MB
11/6/2008 8:49:10 AM: Compressed data size: 1.425 MB
11/6/2008 8:49:10 AM: Compression rate : 83.11%
Processed 896 pages for database 'PWA_Archive_C29A8919_7044_4035_B6CF_64B5D047C98D', file 'PWA_Archive_C29A8919_7044_4035_B6CF_64B5D047C98D' on file 1.
Processed 1 pages for database 'PWA_Archive_C29A8919_7044_4035_B6CF_64B5D047C98D', file 'PWA_Archive_C29A8919_7044_4035_B6CF_64B5D047C98D_log' on file 1.
BACKUP DATABASE successfully processed 897 pages in 0.086 seconds (85.444 MB/sec).
11/6/2008 8:49:10 AM: Backing up PWA_Draft_92C688B4_B110_48C8_938A_B3D0F6C8C823 (full database) to:
11/6/2008 8:49:10 AM: C:\Documents and Settings\Administrator.212RESOURCES\Desktop\sharepoint_backup\FULL_(local)_PWA_Draft_92C688B4_B110_48C8_938A_B3D0F6C8C823_20081106_084910.sqb
11/6/2008 8:49:10 AM: BACKUP DATABASE [PWA_Draft_92C688B4_B110_48C8_938A_B3D0F6C8C823] TO DISK = 'C:\Documents and Settings\Administrator.212RESOURCES\Desktop\sharepoint_backup\<AUTO>.sqb' WITH NAME = '<AUTO>', DESCRIPTION = '<AUTO>', COMPRESSION = 1
11/6/2008 8:49:11 AM: Database size : 9.938 MB
11/6/2008 8:49:11 AM: Compressed data size: 2.068 MB
11/6/2008 8:49:11 AM: Compression rate : 79.19%
Processed 1040 pages for database 'PWA_Draft_92C688B4_B110_48C8_938A_B3D0F6C8C823', file 'PWA_Draft_92C688B4_B110_48C8_938A_B3D0F6C8C823' on file 1.
Processed 1 pages for database 'PWA_Draft_92C688B4_B110_48C8_938A_B3D0F6C8C823', file 'PWA_Draft_92C688B4_B110_48C8_938A_B3D0F6C8C823_log' on file 1.
BACKUP DATABASE successfully processed 1041 pages in 0.107 seconds (79.699 MB/sec).
11/6/2008 8:49:11 AM: Backing up PWA_Draft_C29A8919_7044_4035_B6CF_64B5D047C98D (full database) to:
11/6/2008 8:49:11 AM: C:\Documents and Settings\Administrator.212RESOURCES\Desktop\sharepoint_backup\FULL_(local)_PWA_Draft_C29A8919_7044_4035_B6CF_64B5D047C98D_20081106_084911.sqb
11/6/2008 8:49:11 AM: BACKUP DATABASE [PWA_Draft_C29A8919_7044_4035_B6CF_64B5D047C98D] TO DISK = 'C:\Documents and Settings\Administrator.212RESOURCES\Desktop\sharepoint_backup\<AUTO>.sqb' WITH NAME = '<AUTO>', DESCRIPTION = '<AUTO>', COMPRESSION = 1
11/6/2008 8:49:12 AM: Database size : 12.688 MB
11/6/2008 8:49:12 AM: Compressed data size: 2.425 MB
11/6/2008 8:49:12 AM: Compression rate : 80.88%
Processed 1328 pages for database 'PWA_Draft_C29A8919_7044_4035_B6CF_64B5D047C98D', file 'PWA_Draft_C29A8919_7044_4035_B6CF_64B5D047C98D' on file 1.
Processed 1 pages for database 'PWA_Draft_C29A8919_7044_4035_B6CF_64B5D047C98D', file 'PWA_Draft_C29A8919_7044_4035_B6CF_64B5D047C98D_log' on file 1.
BACKUP DATABASE successfully processed 1329 pages in 0.123 seconds (88.513 MB/sec).
11/6/2008 8:49:12 AM: Backing up PWA_Published_92C688B4_B110_48C8_938A_B3D0F6C8C823 (full database) to:
11/6/2008 8:49:12 AM: C:\Documents and Settings\Administrator.212RESOURCES\Desktop\sharepoint_backup\FULL_(local)_PWA_Published_92C688B4_B110_48C8_938A_B3D0F6C8C823_20081106_084912.sqb
11/6/2008 8:49:12 AM: BACKUP DATABASE [PWA_Published_92C688B4_B110_48C8_938A_B3D0F6C8C823] TO DISK = 'C:\Documents and Settings\Administrator.212RESOURCES\Desktop\sharepoint_backup\<AUTO>.sqb' WITH NAME = '<AUTO>', DESCRIPTION = '<AUTO>', COMPRESSION = 1
11/6/2008 8:49:13 AM: Database size : 16.438 MB
11/6/2008 8:49:13 AM: Compressed data size: 3.451 MB
11/6/2008 8:49:13 AM: Compression rate : 79.01%
Processed 1912 pages for database 'PWA_Published_92C688B4_B110_48C8_938A_B3D0F6C8C823', file 'PWA_Published_92C688B4_B110_48C8_938A_B3D0F6C8C823' on file 1.
Processed 1 pages for database 'PWA_Published_92C688B4_B110_48C8_938A_B3D0F6C8C823', file 'PWA_Published_92C688B4_B110_48C8_938A_B3D0F6C8C823_log' on file 1.
BACKUP DATABASE successfully processed 1913 pages in 0.149 seconds (105.176 MB/sec).
11/6/2008 8:49:13 AM: Backing up PWA_Published_C29A8919_7044_4035_B6CF_64B5D047C98D (full database) to:
11/6/2008 8:49:13 AM: C:\Documents and Settings\Administrator.212RESOURCES\Desktop\sharepoint_backup\FULL_(local)_PWA_Published_C29A8919_7044_4035_B6CF_64B5D047C98D_20081106_084913.sqb
11/6/2008 8:49:13 AM: BACKUP DATABASE [PWA_Published_C29A8919_7044_4035_B6CF_64B5D047C98D] TO DISK = 'C:\Documents and Settings\Administrator.212RESOURCES\Desktop\sharepoint_backup\<AUTO>.sqb' WITH NAME = '<AUTO>', DESCRIPTION = '<AUTO>', COMPRESSION = 1
11/6/2008 8:49:14 AM: Database size : 21.688 MB
11/6/2008 8:49:14 AM: Compressed data size: 4.223 MB
11/6/2008 8:49:14 AM: Compression rate : 80.53%
Processed 2336 pages for database 'PWA_Published_C29A8919_7044_4035_B6CF_64B5D047C98D', file 'PWA_Published_C29A8919_7044_4035_B6CF_64B5D047C98D' on file 1.
Processed 1 pages for database 'PWA_Published_C29A8919_7044_4035_B6CF_64B5D047C98D', file 'PWA_Published_C29A8919_7044_4035_B6CF_64B5D047C98D_log' on file 1.
BACKUP DATABASE successfully processed 2337 pages in 0.189 seconds (101.294 MB/sec).
11/6/2008 8:49:14 AM: Backing up PWA_Reporting_92C688B4_B110_48C8_938A_B3D0F6C8C823 (full database) to:
11/6/2008 8:49:14 AM: C:\Documents and Settings\Administrator.212RESOURCES\Desktop\sharepoint_backup\FULL_(local)_PWA_Reporting_92C688B4_B110_48C8_938A_B3D0F6C8C823_20081106_084914.sqb
11/6/2008 8:49:14 AM: BACKUP DATABASE [PWA_Reporting_92C688B4_B110_48C8_938A_B3D0F6C8C823] TO DISK = 'C:\Documents and Settings\Administrator.212RESOURCES\Desktop\sharepoint_backup\<AUTO>.sqb' WITH NAME = '<AUTO>', DESCRIPTION = '<AUTO>', COMPRESSION = 1
11/6/2008 8:49:15 AM: Database size : 11.313 MB
11/6/2008 8:49:15 AM: Compressed data size: 1.353 MB
11/6/2008 8:49:15 AM: Compression rate : 88.04%
Processed 888 pages for database 'PWA_Reporting_92C688B4_B110_48C8_938A_B3D0F6C8C823', file 'PWA_Reporting_92C688B4_B110_48C8_938A_B3D0F6C8C823' on file 1.
Processed 1 pages for database 'PWA_Reporting_92C688B4_B110_48C8_938A_B3D0F6C8C823', file 'PWA_Reporting_92C688B4_B110_48C8_938A_B3D0F6C8C823_log' on file 1.
BACKUP DATABASE successfully processed 889 pages in 0.085 seconds (85.678 MB/sec).
11/6/2008 8:49:15 AM: Backing up PWA_Reporting_C29A8919_7044_4035_B6CF_64B5D047C98D (full database) to:
11/6/2008 8:49:15 AM: C:\Documents and Settings\Administrator.212RESOURCES\Desktop\sharepoint_backup\FULL_(local)_PWA_Reporting_C29A8919_7044_4035_B6CF_64B5D047C98D_20081106_084915.sqb
11/6/2008 8:49:15 AM: BACKUP DATABASE [PWA_Reporting_C29A8919_7044_4035_B6CF_64B5D047C98D] TO DISK = 'C:\Documents and Settings\Administrator.212RESOURCES\Desktop\sharepoint_backup\<AUTO>.sqb' WITH NAME = '<AUTO>', DESCRIPTION = '<AUTO>', COMPRESSION = 1
11/6/2008 8:49:16 AM: Database size : 11.938 MB
11/6/2008 8:49:16 AM: Compressed data size: 1.569 MB
11/6/2008 8:49:16 AM: Compression rate : 86.85%
Processed 976 pages for database 'PWA_Reporting_C29A8919_7044_4035_B6CF_64B5D047C98D', file 'PWA_Reporting_C29A8919_7044_4035_B6CF_64B5D047C98D' on file 1.
Processed 1 pages for database 'PWA_Reporting_C29A8919_7044_4035_B6CF_64B5D047C98D', file 'PWA_Reporting_C29A8919_7044_4035_B6CF_64B5D047C98D_log' on file 1.
BACKUP DATABASE successfully processed 977 pages in 0.088 seconds (90.949 MB/sec).
11/6/2008 8:49:16 AM: Backing up ReportServer (full database) to:
11/6/2008 8:49:16 AM: C:\Documents and Settings\Administrator.212RESOURCES\Desktop\sharepoint_backup\FULL_(local)_ReportServer_20081106_084916.sqb
11/6/2008 8:49:16 AM: BACKUP DATABASE [ReportServer] TO DISK = 'C:\Documents and Settings\Administrator.212RESOURCES\Desktop\sharepoint_backup\<AUTO>.sqb' WITH NAME = '<AUTO>', DESCRIPTION = '<AUTO>', COMPRESSION = 1
11/6/2008 8:49:17 AM: Database size : 3.938 MB
11/6/2008 8:49:17 AM: Compressed data size: 476.500 KB
11/6/2008 8:49:17 AM: Compression rate : 88.18%
Processed 328 pages for database 'ReportServer', file 'ReportServer' on file 1.
Processed 1 pages for database 'ReportServer', file 'ReportServer_log' on file 1.
BACKUP DATABASE successfully processed 329 pages in 0.051 seconds (52.846 MB/sec).
11/6/2008 8:49:17 AM: Backing up ReportServerTempDB (full database) to:
11/6/2008 8:49:17 AM: C:\Documents and Settings\Administrator.212RESOURCES\Desktop\sharepoint_backup\FULL_(local)_ReportServerTempDB_20081106_084917.sqb
11/6/2008 8:49:17 AM: BACKUP DATABASE [ReportServerTempDB] TO DISK = 'C:\Documents and Settings\Administrator.212RESOURCES\Desktop\sharepoint_backup\<AUTO>.sqb' WITH NAME = '<AUTO>', DESCRIPTION = '<AUTO>', COMPRESSION = 1
11/6/2008 8:49:18 AM: Database size : 2.938 MB
11/6/2008 8:49:18 AM: Compressed data size: 198.000 KB
11/6/2008 8:49:18 AM: Compression rate : 93.42%
Processed 176 pages for database 'ReportServerTempDB', file 'ReportServerTempDB' on file 1.
Processed 1 pages for database 'ReportServerTempDB', file 'ReportServerTempDB_log' on file 1.
BACKUP DATABASE successfully processed 177 pages in 0.024 seconds (60.416 MB/sec).
11/6/2008 8:49:18 AM: Backing up SharedServices1_DB_4e3606a8-ddc9-4b96-955b-c4ab6c1da1fb (full database) to:
11/6/2008 8:49:18 AM: C:\Documents and Settings\Administrator.212RESOURCES\Desktop\sharepoint_backup\FULL_(local)_SharedServices1_DB_4e3606a8-ddc9-4b96-955b-c4ab6c1da1fb_20081106_084918.sqb
11/6/2008 8:49:18 AM: BACKUP DATABASE [SharedServices1_DB_4e3606a8-ddc9-4b96-955b-c4ab6c1da1fb] TO DISK = 'C:\Documents and Settings\Administrator.212RESOURCES\Desktop\sharepoint_backup\<AUTO>.sqb' WITH NAME = '<AUTO>', DESCRIPTION = '<AUTO>', COMPRESSION = 1
11/6/2008 8:49:19 AM: Database size : 13.938 MB
11/6/2008 8:49:19 AM: Compressed data size: 1.539 MB
11/6/2008 8:49:19 AM: Compression rate : 88.96%
Processed 1000 pages for database 'SharedServices1_DB_4e3606a8-ddc9-4b96-955b-c4ab6c1da1fb', file 'SharedServices1_DB_4e3606a8-ddc9-4b96-955b-c4ab6c1da1fb' on file 1.
Processed 1 pages for database 'SharedServices1_DB_4e3606a8-ddc9-4b96-955b-c4ab6c1da1fb', file 'SharedServices1_DB_4e3606a8-ddc9-4b96-955b-c4ab6c1da1fb_log' on file 1.
BACKUP DATABASE successfully processed 1001 pages in 0.095 seconds (86.317 MB/sec).
11/6/2008 8:49:19 AM: Backing up SharedServices1_DB_e404010e-30ee-4ad9-8ec1-0b3bdd69628c (full database) to:
11/6/2008 8:49:19 AM: C:\Documents and Settings\Administrator.212RESOURCES\Desktop\sharepoint_backup\FULL_(local)_SharedServices1_DB_e404010e-30ee-4ad9-8ec1-0b3bdd69628c_20081106_084919.sqb
11/6/2008 8:49:19 AM: BACKUP DATABASE [SharedServices1_DB_e404010e-30ee-4ad9-8ec1-0b3bdd69628c] TO DISK = 'C:\Documents and Settings\Administrator.212RESOURCES\Desktop\sharepoint_backup\<AUTO>.sqb' WITH NAME = '<AUTO>', DESCRIPTION = '<AUTO>', COMPRESSION = 1
11/6/2008 8:49:19 AM: Database size : 12.688 MB
11/6/2008 8:49:19 AM: Compressed data size: 1.322 MB
11/6/2008 8:49:19 AM: Compression rate : 89.58%
Processed 896 pages for database 'SharedServices1_DB_e404010e-30ee-4ad9-8ec1-0b3bdd69628c', file 'SharedServices1_DB_e404010e-30ee-4ad9-8ec1-0b3bdd69628c' on file 1.
Processed 1 pages for database 'SharedServices1_DB_e404010e-30ee-4ad9-8ec1-0b3bdd69628c', file 'SharedServices1_DB_e404010e-30ee-4ad9-8ec1-0b3bdd69628c_log' on file 1.
BACKUP DATABASE successfully processed 897 pages in 0.057 seconds (128.916 MB/sec).
11/6/2008 8:49:19 AM: Backing up SharedServices1_Search_DB_3fd916ce-dbe2-41fb-b67f-16756b2a409e (full database) to:
11/6/2008 8:49:19 AM: C:\Documents and Settings\Administrator.212RESOURCES\Desktop\sharepoint_backup\FULL_(local)_SharedServices1_Search_DB_3fd916ce-dbe2-41fb-b67f-16756b2a409e_20081106_084919.sqb
11/6/2008 8:49:19 AM: BACKUP DATABASE [SharedServices1_Search_DB_3fd916ce-dbe2-41fb-b67f-16756b2a409e] TO DISK = 'C:\Documents and Settings\Administrator.212RESOURCES\Desktop\sharepoint_backup\<AUTO>.sqb' WITH NAME = '<AUTO>', DESCRIPTION = '<AUTO>', COMPRESSION = 1
11/6/2008 8:49:21 AM: Database size : 116.125 MB
11/6/2008 8:49:21 AM: Compressed data size: 15.235 MB
11/6/2008 8:49:21 AM: Compression rate : 86.88%
Processed 6664 pages for database 'SharedServices1_Search_DB_3fd916ce-dbe2-41fb-b67f-16756b2a409e', file 'SharedServices1_Search_DB_3fd916ce-dbe2-41fb-b67f-16756b2a409e' on file 1.
Processed 1 pages for database 'SharedServices1_Search_DB_3fd916ce-dbe2-41fb-b67f-16756b2a409e', file 'SharedServices1_Search_DB_3fd916ce-dbe2-41fb-b67f-16756b2a409e_log' on file 1.
BACKUP DATABASE successfully processed 6665 pages in 0.395 seconds (138.227 MB/sec).
11/6/2008 8:49:21 AM: Backing up SharedServices1_Search_DB_61463879-8f5b-4e2d-9bf9-d27b52d55460 (full database) to:
11/6/2008 8:49:21 AM: C:\Documents and Settings\Administrator.212RESOURCES\Desktop\sharepoint_backup\FULL_(local)_SharedServices1_Search_DB_61463879-8f5b-4e2d-9bf9-d27b52d55460_20081106_084921.sqb
11/6/2008 8:49:21 AM: BACKUP DATABASE [SharedServices1_Search_DB_61463879-8f5b-4e2d-9bf9-d27b52d55460] TO DISK = 'C:\Documents and Settings\Administrator.212RESOURCES\Desktop\sharepoint_backup\<AUTO>.sqb' WITH NAME = '<AUTO>', DESCRIPTION = '<AUTO>', COMPRESSION = 1
11/6/2008 8:49:22 AM: Database size : 25.938 MB
11/6/2008 8:49:22 AM: Compressed data size: 4.995 MB
11/6/2008 8:49:22 AM: Compression rate : 80.74%
Processed 2424 pages for database 'SharedServices1_Search_DB_61463879-8f5b-4e2d-9bf9-d27b52d55460', file 'SharedServices1_Search_DB_61463879-8f5b-4e2d-9bf9-d27b52d55460' on file 1.
Processed 1 pages for database 'SharedServices1_Search_DB_61463879-8f5b-4e2d-9bf9-d27b52d55460', file 'SharedServices1_Search_DB_61463879-8f5b-4e2d-9bf9-d27b52d55460_log' on file 1.
BACKUP DATABASE successfully processed 2425 pages in 0.171 seconds (116.173 MB/sec).
11/6/2008 8:49:22 AM: Backing up SharedServicesContent_d33b5005-cc09-411d-ba34-9bc9c2c6e187 (full database) to:
11/6/2008 8:49:22 AM: C:\Documents and Settings\Administrator.212RESOURCES\Desktop\sharepoint_backup\FULL_(local)_SharedServicesContent_d33b5005-cc09-411d-ba34-9bc9c2c6e187_20081106_084922.sqb
11/6/2008 8:49:22 AM: BACKUP DATABASE [SharedServicesContent_d33b5005-cc09-411d-ba34-9bc9c2c6e187] TO DISK = 'C:\Documents and Settings\Administrator.212RESOURCES\Desktop\sharepoint_backup\<AUTO>.sqb' WITH NAME = '<AUTO>', DESCRIPTION = '<AUTO>', COMPRESSION = 1
11/6/2008 8:49:23 AM: Database size : 14.188 MB
11/6/2008 8:49:23 AM: Compressed data size: 2.521 MB
11/6/2008 8:49:23 AM: Compression rate : 82.23%
Processed 1496 pages for database 'SharedServicesContent_d33b5005-cc09-411d-ba34-9bc9c2c6e187', file 'SharedServicesContent_d33b5005-cc09-411d-ba34-9bc9c2c6e187' on file 1.
Processed 1 pages for database 'SharedServicesContent_d33b5005-cc09-411d-ba34-9bc9c2c6e187', file 'SharedServicesContent_d33b5005-cc09-411d-ba34-9bc9c2c6e187_log' on file 1.
BACKUP DATABASE successfully processed 1497 pages in 0.121 seconds (101.350 MB/sec).
11/6/2008 8:49:23 AM: Backing up SharePoint_AdminContent_25b8b309-3643-41aa-b8c2-3881b158b1bd (full database) to:
11/6/2008 8:49:23 AM: C:\Documents and Settings\Administrator.212RESOURCES\Desktop\sharepoint_backup\FULL_(local)_SharePoint_AdminContent_25b8b309-3643-41aa-b8c2-3881b158b1bd_20081106_084923.sqb
11/6/2008 8:49:23 AM: BACKUP DATABASE [SharePoint_AdminContent_25b8b309-3643-41aa-b8c2-3881b158b1bd] TO DISK = 'C:\Documents and Settings\Administrator.212RESOURCES\Desktop\sharepoint_backup\<AUTO>.sqb' WITH NAME = '<AUTO>', DESCRIPTION = '<AUTO>', COMPRESSION = 1
11/6/2008 8:49:24 AM: Database size : 69.938 MB
11/6/2008 8:49:24 AM: Compressed data size: 14.991 MB
11/6/2008 8:49:24 AM: Compression rate : 78.57%
Processed 7800 pages for database 'SharePoint_AdminContent_25b8b309-3643-41aa-b8c2-3881b158b1bd', file 'SharePoint_AdminContent_25b8b309-3643-41aa-b8c2-3881b158b1bd' on file 1.
Processed 1 pages for database 'SharePoint_AdminContent_25b8b309-3643-41aa-b8c2-3881b158b1bd', file 'SharePoint_AdminContent_25b8b309-3643-41aa-b8c2-3881b158b1bd_log' on file 1.
BACKUP DATABASE successfully processed 7801 pages in 0.445 seconds (143.608 MB/sec).
11/6/2008 8:49:24 AM: Backing up SharePoint_AdminContent_53c1ef50-2787-42b3-9e4e-603dbc36d8e0 (full database) to:
11/6/2008 8:49:24 AM: C:\Documents and Settings\Administrator.212RESOURCES\Desktop\sharepoint_backup\FULL_(local)_SharePoint_AdminContent_53c1ef50-2787-42b3-9e4e-603dbc36d8e0_20081106_084924.sqb
11/6/2008 8:49:24 AM: BACKUP DATABASE [SharePoint_AdminContent_53c1ef50-2787-42b3-9e4e-603dbc36d8e0] TO DISK = 'C:\Documents and Settings\Administrator.212RESOURCES\Desktop\sharepoint_backup\<AUTO>.sqb' WITH NAME = '<AUTO>', DESCRIPTION = '<AUTO>', COMPRESSION = 1
11/6/2008 8:49:25 AM: Database size : 67.438 MB
11/6/2008 8:49:25 AM: Compressed data size: 18.207 MB
11/6/2008 8:49:25 AM: Compression rate : 73.00%
Processed 8232 pages for database 'SharePoint_AdminContent_53c1ef50-2787-42b3-9e4e-603dbc36d8e0', file 'SharePoint_AdminContent_53c1ef50-2787-42b3-9e4e-603dbc36d8e0' on file 1.
Processed 1 pages for database 'SharePoint_AdminContent_53c1ef50-2787-42b3-9e4e-603dbc36d8e0', file 'SharePoint_AdminContent_53c1ef50-2787-42b3-9e4e-603dbc36d8e0_log' on file 1.
BACKUP DATABASE successfully processed 8233 pages in 0.484 seconds (139.348 MB/sec).
11/6/2008 8:49:25 AM: Backing up SharePoint_Config (full database) to:
11/6/2008 8:49:25 AM: C:\Documents and Settings\Administrator.212RESOURCES\Desktop\sharepoint_backup\FULL_(local)_SharePoint_Config_20081106_084925.sqb
11/6/2008 8:49:25 AM: BACKUP DATABASE [SharePoint_Config] TO DISK = 'C:\Documents and Settings\Administrator.212RESOURCES\Desktop\sharepoint_backup\<AUTO>.sqb' WITH NAME = '<AUTO>', DESCRIPTION = '<AUTO>', COMPRESSION = 1
11/6/2008 8:49:26 AM: Database size : 9.688 MB
11/6/2008 8:49:26 AM: Compressed data size: 1.809 MB
11/6/2008 8:49:26 AM: Compression rate : 81.33%
Processed 888 pages for database 'SharePoint_Config', file 'SharePoint_Config' on file 1.
Processed 1 pages for database 'SharePoint_Config', file 'SharePoint_Config_log' on file 1.
BACKUP DATABASE successfully processed 889 pages in 0.084 seconds (86.698 MB/sec).
11/6/2008 8:49:26 AM: Backing up SharePoint_Config_104a1c17-caad-40b0-bd60-ec5207fd617a (full database) to:
11/6/2008 8:49:26 AM: C:\Documents and Settings\Administrator.212RESOURCES\Desktop\sharepoint_backup\FULL_(local)_SharePoint_Config_104a1c17-caad-40b0-bd60-ec5207fd617a_20081106_084926.sqb
11/6/2008 8:49:26 AM: BACKUP DATABASE [SharePoint_Config_104a1c17-caad-40b0-bd60-ec5207fd617a] TO DISK = 'C:\Documents and Settings\Administrator.212RESOURCES\Desktop\sharepoint_backup\<AUTO>.sqb' WITH NAME = '<AUTO>', DESCRIPTION = '<AUTO>', COMPRESSION = 1
11/6/2008 8:49:27 AM: Database size : 9.688 MB
11/6/2008 8:49:27 AM: Compressed data size: 1.783 MB
11/6/2008 8:49:27 AM: Compression rate : 81.60%
Processed 1032 pages for database 'SharePoint_Config_104a1c17-caad-40b0-bd60-ec5207fd617a', file 'SharePoint_Config_104a1c17-caad-40b0-bd60-ec5207fd617a' on file 1.
Processed 1 pages for database 'SharePoint_Config_104a1c17-caad-40b0-bd60-ec5207fd617a', file 'SharePoint_Config_104a1c17-caad-40b0-bd60-ec5207fd617a_log' on file 1.
BACKUP DATABASE successfully processed 1033 pages in 0.132 seconds (64.108 MB/sec).
11/6/2008 8:49:27 AM: Backing up WSS_Content_f07383ff-a588-4988-a7f4-ef67a774bc62 (full database) to:
11/6/2008 8:49:27 AM: C:\Documents and Settings\Administrator.212RESOURCES\Desktop\sharepoint_backup\FULL_(local)_WSS_Content_f07383ff-a588-4988-a7f4-ef67a774bc62_20081106_084927.sqb
11/6/2008 8:49:27 AM: BACKUP DATABASE [WSS_Content_f07383ff-a588-4988-a7f4-ef67a774bc62] TO DISK = 'C:\Documents and Settings\Administrator.212RESOURCES\Desktop\sharepoint_backup\<AUTO>.sqb' WITH NAME = '<AUTO>', DESCRIPTION = '<AUTO>', COMPRESSION = 1
11/6/2008 8:50:16 AM: Database size : 4.124 GB
11/6/2008 8:50:16 AM: Compressed data size: 4.068 GB
11/6/2008 8:50:16 AM: Compression rate : 1.35%
Processed 532416 pages for database 'WSS_Content_f07383ff-a588-4988-a7f4-ef67a774bc62', file 'WSS_Content_f07383ff-a588-4988-a7f4-ef67a774bc62' on file 1.
Processed 5 pages for database 'WSS_Content_f07383ff-a588-4988-a7f4-ef67a774bc62', file 'WSS_Content_f07383ff-a588-4988-a7f4-ef67a774bc62_log' on file 1.
BACKUP DATABASE successfully processed 532421 pages in 48.666 seconds (89.622 MB/sec).
11/6/2008 8:50:16 AM: Backing up WSS_Search_STARSTREAM (full database) to:
11/6/2008 8:50:16 AM: C:\Documents and Settings\Administrator.212RESOURCES\Desktop\sharepoint_backup\FULL_(local)_WSS_Search_STARSTREAM_20081106_085016.sqb
11/6/2008 8:50:16 AM: BACKUP DATABASE [WSS_Search_STARSTREAM] TO DISK = 'C:\Documents and Settings\Administrator.212RESOURCES\Desktop\sharepoint_backup\<AUTO>.sqb' WITH NAME = '<AUTO>', DESCRIPTION = '<AUTO>', COMPRESSION = 1
11/6/2008 8:50:17 AM: Database size : 90.375 MB
11/6/2008 8:50:17 AM: Compressed data size: 2.309 MB
11/6/2008 8:50:17 AM: Compression rate : 97.44%
Processed 1568 pages for database 'WSS_Search_STARSTREAM', file 'WSS_Search_STARSTREAM' on file 1.
Processed 1 pages for database 'WSS_Search_STARSTREAM', file 'WSS_Search_STARSTREAM_log' on file 1.
BACKUP DATABASE successfully processed 1569 pages in 0.261 seconds (49.246 MB/sec).
11/6/2008 8:50:17 AM: Backing up msdb (full database) to:
11/6/2008 8:50:17 AM: C:\Documents and Settings\Administrator.212RESOURCES\Desktop\sharepoint_backup\FULL_(local)_msdb_20081106_085017.sqb
11/6/2008 8:50:17 AM: BACKUP DATABASE [msdb] TO DISK = 'C:\Documents and Settings\Administrator.212RESOURCES\Desktop\sharepoint_backup\<AUTO>.sqb' WITH NAME = '<AUTO>', DESCRIPTION = '<AUTO>', COMPRESSION = 1
11/6/2008 8:50:18 AM: Database size : 12.313 MB
11/6/2008 8:50:18 AM: Compressed data size: 2.123 MB
11/6/2008 8:50:18 AM: Compression rate : 82.76%
Processed 1352 pages for database 'msdb', file 'MSDBData' on file 1.
Processed 5 pages for database 'msdb', file 'MSDBLog' on file 1.
BACKUP DATABASE successfully processed 1357 pages in 0.175 seconds (63.523 MB/sec).
11/6/2008 8:50:18 AM: SQL Backup process ended.
Comments
It seems to be a permissions issue, if you right click the job in SSMS/Enterprise Manager and start it, do you get an error message and an entry in the Application Log/SQL Server logs or does it start ok?
What is the error message if any?
When you look at the properties of the job, does it have an owner with sufficient permissions?
Thanks,
Redgate Foundry
Thank you very much for your reply. I don't know very much about database management, but your reply gave me enough to get it running. I was able to find the SQL server agent, and get it running with the SQL Server Configuration Manager. (It does look like they are using different authentication--the DB is running with a specific userid, and SQL Backup 5 is running with windows authentication)
I am still wondering though why I was able to do a manual backup, when the scheduled one didn't work. Is a scheduled backup always tied to the SQL server agent, and a manual backup is a direct connection perhaps?
Thanks!