Post reply

Hanging Restore

  • October 10, 2003 at 4:55 am

    #81232

    Hello,

    I was wondering if someone could help me. We recently needed to restore a database from a backup file.

    The first thing I did was attempt a restore from enterprise manager. The restore "time bar" went all the way across not errors, but then hung. I waited 30 minutes after the hour bar had moved all the way across, so I cancelled it.

    I subsequenty used T-SQL. In this case I waited 35 minutes before pressing cancel however the restore had actually worked but the T-SQL had not finished. I checked the database thouroughly after and it contained the restore that I wanted.

    Question then, why don't my restores stop executing ever though they look as if they had finished ?

    Thanks

    J

  • October 12, 2003 at 5:26 pm

    #477956

    Are there any error messages in the log? Try restoring with the STATS parameter to get progress details.

    Hope this helps

    Phill Carter

    --------------------

    Colt 45 - the original point and click interface

    --------------------
    Colt 45 - the original point and click interface

  • October 13, 2003 at 4:08 am

    #477976

    Can also check sysprocesses to see if the diskio/cpu are increasing for the restore spid.

    Andy

    http://qa.sqlservercentral.com/columnists/awarren/

    Andy
    SQLAndy - My Blog!
    Connect with me on LinkedIn
    Follow me on Twitter

  • October 13, 2003 at 7:04 am

    #477987

    If I were a gambler, I'd bet you do not have sufficient disk space to complete the restore. A similar experience happened with a client of mine and boggled me for a bit, so I started looking at the server machine from a higher level. It turned out to be disk space.

    Hope that does it for ya.

    Kel

    K Leb


    K Leb

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

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