August 11, 2003 at 6:57 pm
Hi All,
I normally restore a database from a backup file as a test db for myself on daily basis without any problems. But somehow today, I got this kind of error if I ran the restore task from EM:
"SqlDumpExceptionHandler: Process 52 generated fatal exception C0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process".
If I ran restore sql statement from query analyzer, it returned succeed message; however, from the EM the restored db is marked loading and I couldn't use it.
I digged into this problem but couldn't find any answers. Please help
Minh Vu
August 11, 2003 at 7:57 pm
Does it happen EVERY time you try to restore with EM, or just randomly?
There may be more useful details about the error in your SQL Error Log, or even in the stack dump that should have been created in your errorlog directory.
Cheers,
- Mark
Cheers,
- Mark
August 12, 2003 at 11:16 am
it just happened from yesterday. I suspect that the backup file got corrupt. In my errorlog file said:"Error while undoing logged operation in database 'Bill Master'. Error at log record ID (6733:417:3).
I'm trying to figure out the record id comes from which tables, but I still could not find out the answer. Any ideas will be very appreciated.
Minh
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply