• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1078
  • Last Modified:

SQL 2005 Maintenance Backup Plan fails

I recently created a maintenance plan on a SQL 2005 database.  The plan runs nightly, and it will work without errors for 2-3 days.  Then I will get an error like this
Executing the query "declare @backupSetId as int
select @backupSetId = position from msdb..backupset where database_name=N'TRACKIT80_ISDATA' and backup_set_id=(select max(backup_set_id) from msdb..backupset where database_name=N'TRACKIT80_ISDATA' )
if @backupSetId is null begin raiserror(N'Verify failed. Backup information for database ''TRACKIT80_ISDATA'' not found.', 16, 1) end
RESTORE VERIFYONLY FROM  DISK = N'D:\\SQL Backups\\TRACKIT80_ISDATA\\TRACKIT80_ISDATA_backup_200710170200.bak' WITH  FILE = @backupSetId,  NOUNLOAD,  NOREWIND
" failed with the following error: "Cannot open backup device 'D:\\SQL Backups\\TRACKIT80_ISDATA\\TRACKIT80_ISDATA_backup_200710170200.bak'. Operating system error 32(The process cannot access the file because it is being used by another process.).
VERIFY DATABASE is terminating abnormally.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

and this error number:  -1073548784

Any suggestions?
0
thomashospital
Asked:
thomashospital
1 Solution
 
Chris MangusDatabase AdministratorCommented:
The double backslashes look very suspicious.  When the backup job runs successfully what does the job log and the SQL log show?  Do either of them show double backslashes?

Also, do you have anything else running at the same time as your backup job like diskeeper or is anything trying to back up the .bak file at the same time?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Certified Penetration Testing

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now