471,317 Members | 2,606 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,317 software developers and data experts.

SQL backup progress

This has been posted in sqlserver.programming but the thread has not been
successful so far.
How do I use the 'STATS' output from SQL Backup or restore operations when
these are called programmatically? SQL books says that the STATS option
"Displays a message each time another percentage completes and is used to
gauge progress." - but where can I find that message, so I can use it to
update a progress bar?

The 'SqlInfoMessageEventHandler' event only fires when the backup is
complete (the final event message contains a whole list of '%complete' lines)
- it doesn't fire for each individual percentage completion. So this doesn't
acheive my objective. I have "....WITH INIT,STATS=10" in the backup command.

Someone has suggested SQL-DMO but that appears to be designed for C/C++ and
VB: no mention of it in .NET. I was hoping I could achieve this without
learning a whole new set of programming tools....

Please can anyone help?
Feb 10 '06 #1
0 1235

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Norbert Munkel | last post: by
3 posts views Thread by ChrisWinterscheid | last post: by
1 post views Thread by | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.