>I need to write a simple VFP program for routine backup of a SQL Server database.
>
>User should only choose database, if more than one, and enter a password. Backup path and name and the rest of the process should be automatic.
>
>Can someone help? Thank you.
>
>Alex

Alex,

You could try something like this:

LOCAL loServer, loBackup

loServer   = CREATEOBJECT('SQLDMO.SqlServer')
loServer.Connect("MyServerName","MyUserName", "My password")

loBackup = CREATEOBJECT('SQLDMO.Backup')
WITH loBackup
	.Database   		= "MyDatabaseName"
	.Files      		= '[C:\Backups\BackupFileName]'
	.Initialize 		=  .T.
	.BackupSetName 		= "My Backup"
	.BackupSetDescription = "Mt description"
	.SQLBackup(loServer)
ENDWITH

Cheers,

Zoran