[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

SQL 2005 Maintenance Backup Plan fails

Posted on 2007-10-17
1
Medium Priority
?
1,069 Views
Last Modified: 2008-01-09
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
Comment
Question by:thomashospital
1 Comment
 
LVL 17

Accepted Solution

by:
Chris Mangus earned 1500 total points
ID: 20095540
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

Featured Post

Transaction-level recovery for Oracle database

Veeam Explore for Oracle delivers low RTOs and RPOs with agentless transaction log backup and transaction-level recovery of Oracle databases. You can restore the database to a precise point in time, even to a specific transaction.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
This month, Experts Exchange sat down with resident SQL expert, Jim Horn, for an in-depth look into the makings of a successful career in SQL.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…

873 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question