Why not use Sql DMO (SQL 2000) or SMO (2005)?
Here's an example written in VB 6 but it should not be difficult to translate to VFP:
http://www.freevbcode.com/ShowCode.asp?ID=2579>I was wondering if anyone has ever built in functionality in there VFP application that calls out to SQL Server/MSDE/or SQL Express to use the built
>in backup & restore functionality, and can also pass the backup & restore results back to VFP when the operation is complete !
>
>Thanks For Your Help !
>Stephen J. Hunt
>Admit Computer Services Inc.
I'm a mixture of Albert Einstein and Arnold Schwarzenegger. The only trouble is that I got Einstein's body and Schwarzenegger's brain