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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy