Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
danielc
Starting Member
49 Posts |
 Posted - 2009-06-01 : 18:24:11
|
| Hello folks,I am having a problem with our backups when I verify backup integrity. I have created a backup maintenance plan to backup our database. When I check the box Verify Backup Integrity the backups fail with the following error:Executed as user: test123\SQLsrv. ...ersion 9.00.4035.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 2:58:21 PM Progress: 2009-06-01 14:58:23.18 Source: {B57B4A12-1FFC-4CA1-AFF6-D0BA4A9D3BE3} Executing query "DECLARE @Guid UNIQUEIDENTIFIER EXECUTE msdb..sp".: 100% complete End Progress Progress: 2009-06-01 14:58:42.65 Source: Maintenance Cleanup Task Executing query "EXECUTE master.dbo.xp_delete_file 0,N'\\test123\".: 100% complete End Progress Progress: 2009-06-01 14:59:41.25 Source: Back Up Database Task Executing query "BACKUP DATABASE [DST08000CHARTER] TO DISK = N'\\g".: 50% complete End Progress Error: 2009-06-01 15:00:11.89 Code: 0xC002F210 Source: Back Up Database Task Execute SQL Task Description: Executing the query "declare @backupSetId as int select @backupSetId = position from msdb..backupset where database_name=N'DST08000CHARTER' and backup_set_id=(sele... The package execution fa... The step failed.But when I uncheck the box Verify Backup Integrity the backups succeed. I have executed a DBCC CHECKDB('DST08000CHARTER') and no errors in the results. I have restored the database and data is good. What could the problem be?Thanks,Daniel |
|
|
PCJunkie
Starting Member
7 Posts |
Posted - 2009-06-01 : 19:38:02
|
| Are you using Symantec Backup Exec for Windows Server? If so what version? |
 |
|
|
danielc
Starting Member
49 Posts |
Posted - 2009-06-02 : 11:59:30
|
| Thanks for the reply,I don't use Symantec Backup Exec for Windows Server. I created the maintenance plan using sql server. One of the options is to select Verify Backup Integrity, which I have checked.Thank you,Daniel |
|
|
|
dhjackal
Starting Member
42 Posts |
Posted - 2009-06-03 : 11:00:08
|
| Strange. Very strange indeed but that just about sums up maintenance plans for you. Have you tried recreating the maintenance plan from scratch? |
|
|
|
danielc
Starting Member
49 Posts |
Posted - 2009-06-03 : 13:27:10
|
| thanks again for the reply... I have recreated the maintenace plan several times thinking that was the problem. I have also taken the step to create a scheduled job and scripting the backup process. But that also fails the error message in my first post.Daniel |
|
|
|
|
|
|
Backups Failing...