August 18, 2008 at 11:33 pm
Hi, i have created a MP where in it overwrites the existing media for the full backup on ProductionStatistics Database.
This worked fine for two days and now failing with the following error.
please help me.
executed as user sa...9.00.3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 3:22:16 AM Progress: 2008-08-19 03:22:19.89 Source: {30DE2257-25D6-4649-A38D-C9B29FB00402} Executing query "DECLARE @GUID UNIQUEIDENTIFIER EXECUTE msdb..sp".: 100% complete End Progress Error: 2008-08-19 03:22:20.40 Code: 0xC002F210 Source: Back Up Database (Full) Execute SQL Task Description: Executing the query "BACKUP DATABASE [ProductStatistics] TO DISK = N'R:\MSSQL\BACKUP\ProductStatistics\ProductStatistics.bak' WITH NOFORMAT, INIT, NAME = N'ProductStatistics_backup_20080819032220', SKIP, REWIND, NOUNLOAD, STATS = 10 " failed with the following error: "Cannot open backup device 'R:\MSSQL\BACKUP\ProductStatistics\ProductStatistics.bak'. Operating system error 32(The process cannot access the file because it is being used by another process.). BACKUP DATABASE is terminating abnormally... The package execution fa... The step failed.
August 19, 2008 at 1:46 am
Operating system error 32(The process cannot access the file because it is being used by another process.)
Something else has the BAK file open.
Are you backing the file up to tape or something like that?
August 19, 2008 at 6:41 am
Check the log during backup job which process is overlapping.
Also the backup size may be large enough to fit in your tape drive.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply