Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
How to Automate the Validate Recover method
Versions des environnements
Network:
Windows 2000 Server
I have an application that I wish to allow users to create a duplicate of the databases and tables. For example a multi office application where the underlying information is completely different but the dbc/tables/application are exactly the same. I have coded to allow the users to select between datasets by creating separate subdirectories and datasets beneath the application main directory. Now I want to programatically copy the database & related tables to a subdirectory if a user wants to add a new office to their application.
In order to maintain system integrity I want to have a unique name for each new database so I copy the database and related tables then rename it. I can easily validate the new database with "recover" through the command prompt then manually reply 'yes' to resolve the back link messages but I would like to automate this process so it is invisible to the users.
Does anyone know of a way that I can accomplish this? I have tried using the ON ERROR to return a "YES" (6) then calling Validate Recover, but the validate routine seems to ignore this. I assume it's not actually generating an error but a message.
Thanks,
Greg Taylor
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement