SQL Server Performance Forum – Threads Archive
Cannot restore databases
At the moment we have a very worrying situation on our production server. We cannot restore databases. Every time we try to restore a database, SQL generates an error: "fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION" We can restore the same backups on our other servers with no problems. Everything else seems to be running smoothly on the production server – it is just the restores which are failing. All servers are identical machines, running Window 2000 and SQL Server 7.0, all with the same service packs. Can anyone help shed some light on this problem? I can provide a copy of the stack dump if it will be useful in troubleshooting this problem.Are there any recent changes to the server /operating system/sql server installation?
Since when this problem is occuring, refer to the event viewer for any information on application/system/security logs. Run SQLDIAG utility before and after this error in order to get more information. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
quote:Originally posted by satya
Are there any recent changes to the server /operating system/sql server installation?
Since when this problem is occuring, refer to the event viewer for any information on application/system/security logs. Run SQLDIAG utility before and after this error in order to get more information.
Since when this problem is occuring, refer to the event viewer for any information on application/system/security logs. Run SQLDIAG utility before and after this error in order to get more information.
There have been no recent changes to either SQL Server or Win2k since the last successful database restore. This error first occurred about a week ago, when one of the other developers tried to restore a database he was working on. I will run the SQLDIAG utility and see what it says.
RESTORE capability for a developer on a production server!!
Have you tried taking a fresh backup and try to restore for test purpose. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
quote:Originally posted by satya
Have you tried taking a fresh backup and try to restore for test purpose.
Backups made on the production server can be restored on other servers with no problems. I tried creating a new database, backing it up then restoring it and the restore failed on the production server, but worked fine on our test and development servers. It is the same with all of the other backups – they restore fine on other servers, just not the production server.
Have you tried taking a fresh backup and try to restore for test purpose.
I beleive there could be some issue with the SQL Server installation or with OS itself that may be contributing this issue. If the RESTORE operation is a must and should on this production server then approach MS PSS for suitable solution. BTW any assessment from SQLDIAG utility during this behaviour. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
]]>