I am trying to restore a database in MS SQL Server 7.0. I keep getting the following error message.
Backup or restore operation terminating abnormally.
SqlDumpExceptionHandler: Process 8 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
I searched on google and on Microsoft's Knowledge Base. Any reference to this above error states that it is a bug in SQL Server, but all references have something to do when querying the database, nothing about restoring a database causing this error.
Are any of you familiar with this and what a fix could be?
Thanks for your response. To answer your questions:
1. This is not a new instance of SQL.
2. I am restoring a backup file to the same machine that the database resides, just giving it a different name.
3. The account used to perform the restore has db_backupoperator checked for its role in this databse.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!
Discuss This Question: 2  Replies