This has been posted in sqlserver.progr amming 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 programmaticall y? 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 'SqlInfoMessage EventHandler' 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?
successful so far.
How do I use the 'STATS' output from SQL Backup or restore operations when
these are called programmaticall y? 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 'SqlInfoMessage EventHandler' 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?