>>
>>Also, keep in mind that when you're performing a backup on the server, the server can only access itself and not the user's computer.
>
>Dear Teacher Naomi
>
>I am unable to understand what you said in above sentence.
>Please write again in some easy wording.

I suggest to you to start from creating a backup of your database in SQL Server Management Studio.

Use the interface for that and click on the button to script the command. Then execute it to test.

If it works correctly, copy that script and put it in your VFP command.