September 20, 2002 at 11:32 am
Hi. I am running MS SQL Server 6.5 on NT 4.0 platform. I'm having trouble recently with my database backups. They are scheduled with the "dump database <database_name> to disk = '.....' with init " command.
The Task History in Enterprise Manager shows:
Write on dump device '\\<ipaddress>\tempsql\PW_PUBLICATION.dmp' failed, vsn=4936 return=-2 status=-2. Please consult the SQL Server error log for more details. (Message 3202)
&
Unexpected end-of-dump while loading database, attempting to continue. Please verify database integrity. (Message 3103)
While the server error logs show:
2002/09/20 03:39:13.31kernel dbswriteflush: Write failure on backup device '\\<ipaddress>\tempsql\PW_PUBLICATION.dmp', returned operating system error 240(The session was cancelled.)
No doubt I cannot access the backup server as that database is "marked inaccessible and cannot be edited" (loading).
Of the 6 databases that are backed up only the 2 largest ones produce errors similar to above.
Any ideas?
Thx.
jda
September 20, 2002 at 11:39 am
September 20, 2002 at 2:00 pm
There is a ton of disk space leftto put the database dump.
I am not physically located near the box. I was just informed there is a "Dr. Watson" Application error on this box.
Also should mention the server is running service pack 4.
Any more clues.
Thx.
jda
September 23, 2002 at 10:47 am
Sounds like app trouble. Can you drop the physical file and let the backup recreate it?
Steve Jones
September 24, 2002 at 4:18 am
If Dr. Watson did a dump you may be able to glen some info off it. However double check your rights, have ou installed anything recently (patches included), try another location including local, recheck network configurations on the server and remote box and try what Steve suggests.
Also there is a similar problem with dumping to DLT tapes that become full, look the following ID up on MS KB site for details. The fix is SP 5a for SQL 6.5 and may help you. Another cause of the error that is similar is when writing to the DB the file locks and this could be a file lock issue which also 5a is supposed to fix but I hav no KB ID.
FIX: Dumping to a DLT Tape Drive May Fail to Span Tapes
ID: Q174483
Edited by - antares686 on 09/24/2002 04:23:52 AM
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply