Restore dies after completing

• Paresh Motiwala

  SSCommitted

  Points: 1741

  July 17, 2001 at 8:11 am

  #157803

  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
  DBA, Project Manager, Big Data Enthusiast

• Wesley Brown

  SSChampion

  Points: 12035

  July 17, 2001 at 8:33 am

  #417117

  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

• Paresh Motiwala

  SSCommitted

  Points: 1741

  July 17, 2001 at 8:46 am

  #417119

  oops..I have NT 4.0/SP 6A

  SQL 7.0 with SP2.

  The database is roughly 52 GB

  Paresh Motiwala
  DBA, Project Manager, Big Data Enthusiast

• Steve Jones - SSC Editor

  SSC Guru

  Points: 715391

  July 17, 2001 at 12:50 pm

  #417139

  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

  steve@dkranch.net

  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