July 17, 2001 at 8:11 am
Over the past several days, whenever I restore a database to our QA server, it goes through the statistics till 100%. Then it starts moving the data to the files..
It is at this stage that the restore dies...with the following message...
Error: 0, Severity: 19, State: 0
SqlDumpExceptionHandler: Process 150 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
Any ideas????
Paresh Motiwala Manager of Data Team, Big Data Enthusiast, ex DBA
July 17, 2001 at 8:33 am
what OS version sql version and patch lvls for both? Also, you may want to run a DBCC to make sure there isn't any corrupt data. The last time I saw this was because the schima tables were all goofed up.
July 17, 2001 at 8:46 am
oops..I have NT 4.0/SP 6A
SQL 7.0 with SP2.
The database is roughly 52 GB
Paresh Motiwala Manager of Data Team, Big Data Enthusiast, ex DBA
July 17, 2001 at 12:50 pm
Never seen this and I restore 2-3 servers every week. Granted, they are the same servers.
I'd call MS. Worth the $250 for an exception to find out.
Steve Jones
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply