Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
hsi
Starting Member
1 Post |
 Posted - 2005-06-16 : 06:08:06
|
| Dear All,Would you kindly tell me how to use VB6 to make a tools for backup/restore up SQL data. Backup progress (e.g. 10%, 20%...) is needed. Password is also needed.Thanks a lot.Best regardsHSI |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-06-16 : 07:35:46
|
| I think You cannot precalculate the time required for backup/restore and accordingly show the status bar valuesMadhivananFailing to plan is Planning to fail |
 |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-06-16 : 07:53:11
|
| The BACKUP and RESTORE commands have a WITH STATS option that can display progress during the operation, however I don't know if the messages are accessible via an ADO connection.The SQL-DMO COM library would be the only other option I can think of, but a quick glance does not show any Backup or Restore methods. |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2005-06-16 : 11:41:53
|
| You could run DBCC OUTPUTBUFFER on the backup/restore SPID and parse it. (YUCK!!!)MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
|
|
|
Backup tools with progress status