DB Restore Time

I have a database backup on one server and I am restoring
this to another server. It is about 75 GB. Is there any
way to find out how much of it has been restored through
SQL Server or any other tool ?
Thanks.
If you are using STATS, you can see the progress...
Thanks
GYK
"Ron" wrote:

> I have a database backup on one server and I am restoring
> this to another server. It is about 75 GB. Is there any
> way to find out how much of it has been restored through
> SQL Server or any other tool ?
> Thanks.
>
|||I am running this through DTS package (then, as a
scheduled job).
[vbcol=seagreen]
>--Original Message--
>If you are using STATS, you can see the progress...
>Thanks
>GYK
>"Ron" wrote:
restoring[vbcol=seagreen]
through
>.
>
|||Ron,
I think what CYK is saying is to run something like this:
RESTORE DATABASE MY_DB FROM DISK = 'C:\PATH\MY_DB.BAK' WITH STATS=10
The value for STATS can be any integer between 1 and 100. See Books Online
subject 'RESTORE' under 'Transact-SQL Reference' for more details.
HTH
"Ron" wrote:

> I am running this through DTS package (then, as a
> scheduled job).
>
> restoring
> through
>
|||I understand that but how am I going to view this ?
The script is in the DTS package. I can add that statement
into the DTS package. DTS package is scheduled to run as a
job. May be on the "status" column when executing DTS
package ?
My question is either executing the DTS package or just
running the job, how am I going to see this visually ?
I have test it in the Query analyzer and works. I can see
the progress in "Messages" window.
Thanks.

>--Original Message--
>Ron,
>I think what CYK is saying is to run something like this:
>RESTORE DATABASE MY_DB FROM DISK = 'C:\PATH\MY_DB.BAK'
WITH STATS=10
>The value for STATS can be any integer between 1 and
100. See Books Online
>subject 'RESTORE' under 'Transact-SQL Reference' for more
details.[vbcol=seagreen]
>HTH
>"Ron" wrote:
any
>.
>
|||Run the RESTORE DATABASE command from Query Analyzer instead of a DTS
package. DTS won't offer an 'interactive' response to the query like QA will.
"Ron" wrote:

> I understand that but how am I going to view this ?
> The script is in the DTS package. I can add that statement
> into the DTS package. DTS package is scheduled to run as a
> job. May be on the "status" column when executing DTS
> package ?
> My question is either executing the DTS package or just
> running the job, how am I going to see this visually ?
> I have test it in the Query analyzer and works. I can see
> the progress in "Messages" window.
> Thanks.
>
> WITH STATS=10
> 100. See Books Online
> details.
> any
>
|||"Mike" <mstuart_spamtastesgood@.gates.com> wrote in message
news:CBDF6AC8-3854-40BD-B7A0-33A36685D6D7@.microsoft.com...
> Run the RESTORE DATABASE command from Query Analyzer instead of a DTS
> package. DTS won't offer an 'interactive' response to the query like QA
will.
>
Right, but it's tough to automate that.
I believe Ron's asking for automatic jobs.
I do this as a routine thing (backup from box 1 and restore to box 2.)