March 22, 2010 at 2:48 am
Executing the query "BACKUP DATABASE [WSS_Content_OurPlace] TO DISK = N'E:\\SQLbackup\\WSS_Content_OurPlace\\WSS_Content_OurPlace_backup_201003212001.bak' WITH EXPIREDATE = N'03/31/2010 00:00:00', NOFORMAT, NOINIT, NAME = N'WSS_Content_OurPlace_backup_20100321200121', SKIP, REWIND, NOUNLOAD, STATS = 10
" failed with the following error: "Write on "E:\\SQLbackup\\WSS_Content_OurPlace\\WSS_Content_OurPlace_backup_201003212001.bak" failed: 33(error not found)
BACKUP DATABASE is terminating abnormally.
10 percent processed.
20 percent processed.
30 percent processed.
40 percent processed.
50 percent processed.
60 percent processed.
70 percent processed.
80 percent processed.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
March 22, 2010 at 3:27 am
Hi there,
Are you backing up directly to a network location?
March 22, 2010 at 3:42 am
The E-drive is directly on the server.
March 22, 2010 at 3:51 am
This looks like some type of hardware failure. The backup process just writes pages out to disk as quickly as possible, but doesn't wait for issues with storage.
Is the e: drive directly attached storage, a SAN, or perhaps a NAS mapped drive?
March 22, 2010 at 3:53 am
Trying to figure out the issue...
- Is it a NAS drive?
- Is the backup location a compressed volume?
March 22, 2010 at 5:18 am
It is a local drive and it is not compressed.
March 22, 2010 at 7:25 am
Error 33 is telling you that the file is locked by another process. One of the reasons for that could be a compressed volume. Another possibility is the tape backup job has the file locked.
Identify the other process that is accessing the file and you should be able to solve this problem.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
March 23, 2010 at 12:52 pm
Is there anti-virus on this drive?
March 25, 2010 at 12:52 am
According to my previous experience I faced this error many times and its failed just because of disk space availability. check your disk space and make room for the backup file after re execute the backup..
I'm sure its now its completed with success.
Thanks & Regards,
Nitin Gupta
SQl Server (7.0,2000,2005) - Sr. DBA
HCL Technologies, India
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply