cancel
Showing results for 
Search instead for 
Did you mean: 

SQL restore got stuck while "Begin reading"

Zahid_Haseeb
Moderator
Moderator
Partner    VIP    Accredited
I have a Netbackup6.5 on a windows2003 Server with SP2, i am successfully taking the backup of my SQL databases. i tried to restore my small databases around 100 MBs and they restored successfully. but when  i tried to restore my one database which is around 20GB of size, i am not able to get the success. initially when i tried to restore the big database it got timeout so i increased the timeout values of "Read and Browse" from 300 to 3600 in the netbackup server-->Host Properties. now what is happening the netbackup restore process started and just got stuck at the stage of "begin reading" for around 40minutes(but the time doesnt got stuct it keeps going on)

kindly help me out
thanks
Zahid Haseeb
4 REPLIES 4

Shashank
Level 4
Also check client received timeout & set to 3600.Also restart services netbackup Master Server services after changging setting. 

Michel_Steiner
Level 4
Zahid,

Is the DB created? Any info/error in the NBU SQL GUI "view status"?

sql_noob
Level 4
what kind of hardware are you restoring it on?

we started to see this around a year ago as our db's grew past around 100GB and we were restoring on the old SCSI hard drives. works better on the newer SAS drives, but i still had this happen on the SATA drives.

my solution is to let the restore fail, but don't delete the db files that are created. start the restore again and it should work. i think it's a time out issue as the restore is creating the blank db files on disk

Anton_Panyushki
Level 6
Certified

You should increase read timeout on the media server you are restoring from. We faced this problem before. and increasing timeout on media server made a trick for us.