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.
Paresh Motiwala Manager of Data Team, Big Data Enthusiast, ex DBA