Progress bar for backup operation

Hi,
I am creating a simple form that user will backup his database using that. I
need to show a progress bar when the backup is in progress. How can I read a
value which indicates that? I saw that BACKUP statement has a STATS option,
but I don't know how to capture its value from the server and bring it to
client.
Any help would be greatly appreciated.
Thanks in advance,
Amin
Amin,
Use the Complete event of the Backup object in SQL-DMO.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Amin Sobati wrote:
> Hi,
> I am creating a simple form that user will backup his database using that. I
> need to show a progress bar when the backup is in progress. How can I read a
> value which indicates that? I saw that BACKUP statement has a STATS option,
> but I don't know how to capture its value from the server and bring it to
> client.
> Any help would be greatly appreciated.
> Thanks in advance,
> Amin
>
>
|||Amin,
Oops, I meant use the PercentComplete event of the Backup object. Ignore
my other post in this thread.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Amin Sobati wrote:
> Hi,
> I am creating a simple form that user will backup his database using that. I
> need to show a progress bar when the backup is in progress. How can I read a
> value which indicates that? I saw that BACKUP statement has a STATS option,
> but I don't know how to capture its value from the server and bring it to
> client.
> Any help would be greatly appreciated.
> Thanks in advance,
> Amin
>
>
|||Thanks Mark! That was great tip :-)
"Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
news:OZDT9GabEHA.4092@.TK2MSFTNGP11.phx.gbl...[vbcol=seagreen]
> Amin,
> Oops, I meant use the PercentComplete event of the Backup object. Ignore
> my other post in this thread.
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> Amin Sobati wrote:
that. I[vbcol=seagreen]
read a[vbcol=seagreen]
option,[vbcol=seagreen]
to[vbcol=seagreen]