Restore dies after completing

  • Paresh Motiwala

    SSCommitted

    Points: 1741

    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

    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

    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: 714373

    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

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply