Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Calling SQL SERVER backup & restore fro VFP
Message
De
09/07/2006 13:02:20
Dragan Nedeljkovich
Now officially retired
Zrenjanin, Serbia
 
 
À
07/07/2006 15:35:09
Stephen Hunt
Admit Computer Services Inc.
Farmingdale, New York, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
01134436
Message ID:
01134791
Vues:
22
>Ok the backup works ! Thanks ! Now I am trying to do the restore but it tells me that the database is in use, so I tried an SQLDISCONNECT() then SQLEXEC() to run the restore but I know longer have a connection handle to send with the SQLEXEC(). Is there anyway to attach to the database without actually opening it ?

Add a "use master" line before the first line of your restore command, and don't disconnect. You can't restore a database while you're using it - so use master instead. It has to do some housekeeping (to register the restore, at least) anyway.

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform