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.
http://www.sqlserverio.com
http://www.cactuss.org
http://www.salssa.org
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
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply