Very Computer

Hello,

Every day I make an entire backup off the
database DB_1 and every 2 hours I make a backup
off the transaction log off the database DB_1. I
scheduled these tasks in the schedule manager.
The tasks have run properly for 2 weeks now. Al
at once I got the following error messages:

SQLDumpExceptionHandler: Process 23 generated
access violation; SQL Server is terminating this
process

Msg 3201, Level 16, State 1
Can't open dump device 'D:
\MSSQL\BACKUP\DB_1.DMP', device error or device
off line. Please consult the SQL Server error log
for more details.

Can anybody tell me what this means?

Thanks,
Annick

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.

What version, SP do you use? If you are using 6.5, then I recommend you to
install SP5a. As far as I can remember, error 3201 was  present through
whole lifecycle of 6.5, corrected in SP1, again in SP3 ...

HTH,
Dejan Sarka

Aside from any bugs which may exist... the error message is telling you the
backup wants to go to that file, but it can't be opened.... Maybe the drive
or directory doesn't exist... Maybe the file already exists and you didn't
include 'with init' in your backup command... the disk drive could be out of
space... or maybe sql server doesn't have appropriate permissions to write
to the file/directory..

--
Wayne Snyder MCT,MCSE, Sql Server MVP
IKON Education Services, C*te, NC
(Please respond to the newsgroup.)