Hanging Restore

• JulieW

  Say Hey Kid

  Points: 680

  More actions

  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

• philcart

  SSC-Forever

  Points: 47794

  More actions

  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

• Andy Warren

  SSC Guru

  Points: 119902

  More actions

  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://www.sqlservercentral.com/columnists/awarren/

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

• kleb_writes

  Old Hand

  Points: 337

  More actions

  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