Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to tell how SQL backup is going
Message
De
14/04/2004 01:35:01
 
 
À
14/04/2004 01:14:32
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Divers
Thread ID:
00894630
Message ID:
00894680
Vues:
8
>>OK, maybe this requires the famous "callback". When I am creating a backup of a SQL database, I'd like to give feedback to user of what is going on. Ideally it would show a percentage of job, but it OK just to reassure that all is well. Any ideas?
>>
>>Alex

William,

What I'm trying to do is backup databases with our backup batch files. Those files currently zip and copy a number of directories from several machines into the indicated directory. So the VFP program will receive database particulars and a target directory, both of which may be in different machines, and make a copy to target directory.

>Can you pass anything to/from the SQL-DMO when the backup is running ?

That is a good question. I kind of thought that SQL Server was so smart that it could do that, perhaps by putting users on hold. Actually in this case it won't matter because these backups are made at the end of the day.

>[i ask cause some backup types, if set 'this' way, will knock out all users]
>IF SO - you can retrieve what you need from vfp by encapsulating the SQL-DMO object thingie.

Thanks for the input.

Alex
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform