MS SQL Server - With Stats clause

Author

With Stats clause

Robert Richards via SQLMonster.com

2005-07-15, 11:23 am

I am wondering, when performing a restore, and I have the clause "with stats
= 5", why do I not see an output until the completion of the entire restore.
It would seem that I would see a progression of 5,10,15,...100 during the
restore.

--
Message posted via webservertalk.com
http://www.webservertalk.com/Uwe/Fo...server/200507/1

Hari Prasad

2005-07-15, 8:23 pm

Hi,

Looks like you are restoring with Grid in Result window. Change that in to
TEXT mode. Then you could see advance every 5%.

Thanks
Hari
SQL Server MVP

"Robert Richards via webservertalk.com" <forum@webservertalk.com> wrote in message
news:515D6B1B369C6@w
ebservertalk.com...
>
> I am wondering, when performing a restore, and I have the clause "with
> stats
> = 5", why do I not see an output until the completion of the entire
> restore.
> It would seem that I would see a progression of 5,10,15,...100 during the
> restore.
>
>
> --
> Message posted via webservertalk.com
> http://www.webservertalk.com/Uwe/Fo...server/200507/1

Robert R via SQLMonster.com

2005-07-18, 11:23 am

I tried your suggestion, changing to "Results in Text", and the advance still
does not show. Any other thoughts?

Hari Prasad wrote:[color=darkred
]
>Hi,
>
>Looks like you are restoring with Grid in Result window. Change that in to
>TEXT mode. Then you could see advance every 5%.
>
>Thanks
>Hari
>SQL Server MVP
>

--
Message posted via http://www.webservertalk.com

Sponsored Links