From what you describe, the only thing you will be able to do is 1)pull all the data down and store locally, 2) do your processing, 3) if success, delete local copies, else delete all data on server and upload all backup data.


>I need to have my VFP 6.0 code create a back up of a SQLServer7.0 database before doing some batch processing on the tables. I would also like to give the VFP code the option of restoring the database if the batch process hicups.
>
>What's the suggested 'best practice' for this.
>
>Note: The VFP code is run by various users (i.e. their network logins are different. Also, none of the users are database admins or dbo owners.) I do not have control of the server. It is in a separate department so getting or changing permissions and access rights is sort of a problem. All this might have some bearing on how best to do the backup/restore.)