Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Backup
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
Windows 2003 Server
Database:
MS SQL Server
Application:
Desktop
Miscellaneous
Thread ID:
01519678
Message ID:
01519693
Views:
44
>In order to backup SQL dbfs I have a small program in which I use following syntax:
>lcQueryString="BACKUP DATABASE "+"["+lcDatabase+"]"+" TO DISK = N"+"'"+lcPath+lcDatabase+".bak"+"'"+" WITH NOFORMAT, INIT, NAME = N"+"'"+lcDatabase+"_Backup"+"'"+", SKIP, NOREWIND, NOUNLOAD, STATS = 10"
>lnQuery=SQLEXEC(lnSQLCon,lcQueryString)
>It works fine with SQL 2000 but does not work with either SQL 2005 or 2008 Express. How do I do to get it work with the SQL Express?

What error do you get? Does it work if you run the same command from SSMS?
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform