MAK [Muthusamy Anantha Kumar]
Step 4: Create Job
Create a new job.
Add step with the following statement:
exec master.dbo.USP_ftpbackup 'userdatabase','c:\temp\','c:\temp\ftp.txt', 'Database'
Schedule this job to run every day @ 9 AM.
Create another job with the job step using the following
statement to backup Transaction log and transfer the file using FTP.
exec master.dbo.USP_ftpbackup 'userdatabase','c:\temp\','c:\temp\ftp.txt', 'log'
Schedule this job to run every hour.
When the Full backup job runs it:
When the Transaction log backup job runs, it will do the
above for every transaction log backup.
The same process
can be used for all of the databases in a server. The above process can be used
not only for database backups, but also for transferring files using FTP. This
process helps in simplifying the remote standby server process as well as
remote disaster recovery file transfer processes.