Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL Backup
Message
De
30/07/2011 12:45:07
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
Windows 2003 Server
Database:
MS SQL Server
Application:
Desktop
Divers
Thread ID:
01519678
Message ID:
01519693
Vues:
45
>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--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform