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?