no progress in restore!!!!

[Former Member]

Hi,

i am trying to restore the database with SQL enterprise manager.

in restore progress, its showing nothing progress ( no cursor ) from 2hrs.

kindly tell me your suggestions..........

Regards,

Lakshmi.

[Former Member · Accepted solution]

Hi lakshmi,

what's the size of backup file, and remember one thing.....you should not close the enterprise manager window in case of backup failures.

Gayathry.

[Former Member · Accepted solution]

Hi Gayathry,

It's 210GB, may i know why we should not close enterprise manager window after backup failures??? i am getting this!!

Thanks and Regards,

Lakshmi.

[Former Member · Accepted solution]

Hi Lakshmi,

sorry, it's not in case of "backup failure" it's in case of restore failure. some times the database name (SID) may disappears. if you are not much confident enough, should not colse the enterprise manager, and try to restore again from that screen only. But make sure that backup file should work fine.

and check whether the size of database files sizes are increasing or not.

if it was increased, don't worry you have to wait for some time because it is total 210gb.

Regards,

Gayathry.

[Former Member]

Hi,

During first step of restore database files are created - for 200 GB it can take 2 hours.