Last post Jul 27, 2009 09:27 AM by shabirhakim1
Jul 24, 2009 03:31 PM|mania_mj|LINK
I am doing a simple backup of sql server database through VB.NET form. It gets executed well but I want to display details of successful query execution in a label (i.e. time taken, database size etc.)
The message which I want to display in label is like
"Processed 296 pages for database 'aaa', file 'aaa' on file 1.
Processed 1 pages for database 'aaa', file 'aaa_log' on file 1.
BACKUP DATABASE successfully processed 297 pages in 0.522 seconds (4.660 MB/sec)."
This result we get in sql server query window when we execute backup query there. I want to get this message in label when I fire backup query from Windows form in VB.NET
Need your help here guys..
Jul 27, 2009 09:27 AM|shabirhakim1|LINK
Are you using SMO or DMO for developing this Backup Utility,anyways i am
sending you some URL's wher you will get complete source code for using progress status,
simple and best WAY TO implement THIS functionality is use "BackgroundWorker" if you don't know multithreading programming
if nothing works let me know i have developed this type of utility and i can email you source code