Note: If you are using 64-bit Windows be sure to run the version of odbcad32.exe under the sysWOW64 folder. Now use the Windows ODBC Data Source Administrator program to create a system DSN to access your database with Windows authentication.
Note: To use log shipping, a database's Recovery Model must be set to either Full or Bulk-Logged. Grant the Login db owner or dbbackupoperator permissions on the database. Next, use the SQL Server Management Studio to create a SQL Server Login for the new user with Windows authentication instead of SQL Server authentication. To configure a system to send backups for offsite log shipping, first create a Windows user account and grant the user full permissions on the ProgramData folder under the Robo-FTP installation folder. Robo-FTP is an ideal choice for offsite log shipping because of its ability to execute the SQL commands to create database backup files and then send them to a remote server using a secure, encrypted connection. Log Shipping is a technique for keeping a warm backup of your SQL Server database.
This sample script was written for use with Robo-FTP client v3.10. Additional script logic and error-handling may need to be added to achieve the desired results in your specific environment. These scripts are solely intended to demonstrate techniques for accomplishing common tasks.
Sample scripts are provided as-is with no warranty of fitness for a particular purpose.