>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--