SQL 2005 Maintenance Backup Plan fails

Posted on 2007-10-17
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
" 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?
Question by:thomashospital
    1 Comment
    LVL 17

    Accepted Solution

    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?

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    PRTG Network Monitor: Intuitive Network Monitoring

    Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

    Suggested Solutions

    The new Microsoft OS looks great, is easier than ever to upgrade to, it is even free.  So what's the catch?  If you don't change the privacy settings, Microsoft will, in accordance with the (EULA) you clicked okay to without reading, collect all theā€¦
    This collection of functions covers all the normal rounding methods of just about any numeric value.
    This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
    Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

    760 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

    Need Help in Real-Time?

    Connect with top rated Experts

    9 Experts available now in Live!

    Get 1:1 Help Now