April 16, 2010 at 2:48 pm
Hi there Im trying restoring and backuping,
I executed this code:
restore database AdwentureWorks
from zaloha3
with stopat='2010-04-16 21:50:00',recovery
Now database has icon and labels (restoring...) ,but nothing else it runs 2 hours ...
Any Ideas?
THX Radek
April 19, 2010 at 1:07 am
Icon does get updated automatically. You need to refresh.
April 19, 2010 at 6:29 am
Did the query itself complete? If not, it's still restoring.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 23, 2010 at 9:00 am
Radek
You can use the [font="Courier New"]WITH STATS =[/font] clause in your [font="Courier New"]RESTORE DATABASE [/font]statement in order to view the progress of the restore.
John
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply