December 15, 2008 at 12:46 am
I get this error some times when our backup routine runs.
I haven't been able to find any consistency in the failures, it just happens some times.
The entire error message:
Executing the query "BACKUP DATABASE [Varer] TO DISK = N'g:\\tempbackup\\Varer\\Varer_backup_200812140530.bak' WITH RETAINDAYS = 2, NOFORMAT, NOINIT, NAME = N'Varer_backup_20081214053002', SKIP, REWIND, NOUNLOAD, STATS = 10
" failed with the following error: "Write on "g:\\tempbackup\\Varer\\Varer_backup_200812140530.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.
90 percent processed.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
The backup job does a backup of all databases, but it always fails on the Varer database, when it fails. That's also the biggest database.
Anyone got a clue as to why it fails?
December 15, 2008 at 8:10 am
Is g a local drive or a mapped drive? I have had problems backing up larger db's across a network and this not recommended anyway.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
December 15, 2008 at 8:31 am
G: is a USB harddrive that I've connected because there's not enough room on the other drives in the machine.
December 15, 2008 at 8:41 am
Please check the storage space on USB drive. It might have less space than required for database backup.
Regards,
Nitin
December 16, 2008 at 12:25 am
There's more than enough free space, 128GB total. Each backup takes up about 70-80GB.
The drive's also compressed.
December 16, 2008 at 11:56 am
I dont think just by connecting a USB to the drive where the backup is stored will improve the Space issue. yet again i'm not sure about that...but first check with the path wether its in the network mapping. I some how think that the drive that you have mapped is not in the network.
December 17, 2008 at 12:38 am
I think you missed the point.
I connected an external harddrive to the server and use that to put the backup on.
Ofcourse that will give me more space 🙂
December 17, 2008 at 12:20 pm
Check the OS event logs. Check the format of the USB drive and make sure it is not FAT or FAT32. I'm not sure what your problem is but I've seen issues with USB drives and the default formatting.
December 17, 2008 at 12:29 pm
error 33 is 'The process cannot access the file because another process has locked a portion
of the file.'
do you have some other process that copies the backup of your USB after its created (that could explain why its intermittent)
---------------------------------------------------------------------
December 17, 2008 at 2:08 pm
Hi Simon,
Can you pls post the more details?...
like
-database size of each database you are trying to backed up..
-space availabale on all internal hard drive where database datafile, logfile, temp database and sql biraries are stored
-Space on available on USB harddrive.
If possible post the SQL server log and application log also..
Regards,
Nitin
January 6, 2009 at 2:05 am
Sorry about the delay, I had some vacation coming up 😉
I found the problem though!
It turns out that it wasn't too happy about the compression. Actually, that WAS the problem 😉
After I turned it off, there was no problems at all.
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply