Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2003

    Unanswered: Restore database - Seems hung?

    I'm restoring a complete backup of a database from Enterprise Manager. This has been running for 3 hours and shows no sign of progress. The "Restore Progress" dialog is on the screen and the progress bar hasn't showed any progress. The disk is at full capacity in performance monitor. Nothing else is using the system.

    The data file is 14 GB. It seems like something is wrong. Anything I can do to check?

    SQL Server 2000 SP3a Enterprise Edition
    Windows 2000

  2. #2
    Join Date
    Jul 2003
    San Antonio, TX
    Paying the bill would be nice.

    Check errorlog of the server. The progress may be reported there.
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  3. #3
    Join Date
    Nov 2002
    Seems hung?
    Well that's what they sa....ummm never mind

    Forget EM

    Try and do this from QA and do RESTORE FILELISTONLY and see what that says...

    Also, make sure to set the database into single user mode with Rollback immediate...

    I betcha you've got some blocking going on...

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts