Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Simple VFP program to backup SQL Server database
Message
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00857511
Message ID:
00857678
Views:
34
>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
>
Thank you very much Zoran! Short and sweet.
Previous
Reply
Map
View

Click here to load this message in the networking platform