General information
Category:
Coding, syntax & commands
Environment versions
Network:
Windows 2003 Server
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?
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only