Just connect to AWS Console, create a group, specify policy for the group and add a user into the group. So you may ask how to create a user account for Amazon S3 service with minimum permissions to backup databases with SQLBAckupAndFTP into a specified bucket and folder? It’s very easy. Many admins prefer to create user accounts for any systems with minimum privileges due security reasons. How to write Amazon S3 access policy having the minimum permission required to backup databases with SQLBackupAndFTP Select databases to backup At first let’s select our databases that we’d like to back up. As you can see, all the settings are very easy as described in the following image. Just run the application, click on “Connect to SQL Server” button, enter your connection settings on “Connect to SQL Server” form, click on “Save & Close” button and you can select your databases on the main form. If you still do not have this tool, just get it on the download page and install. Although SkyDrive destination is available in standard version of SQLBackupAndFTP or above, they are currently running a very rare promotion: 5–9 licenses: 20% off 10–19 licenses: 35% off more than 20 licenses: 50% off Although backing up to SkyDrive is available in paid version of the application, we can try it in trial mode. Box destination is available in free version. Let us now see how we can take backup and move it to your SkyDrive cloud. Now it gives you the ability to save your backups on SkyDrive and Box clouds and it’s really easy! You do not have to install any specific driver other application of these clouds, just install SQLBackupAndFTP, select databases which you’d like to backup and connect it to your clouds. SQLBackupAndFTP is a simple tool that you can use to backup and compress databases and save them to different destinations. To ensure your SQL Server database remains safe from computer failures, you should create SQL Server backups of your databases periodically. All your backups should be available for you always and everywhere. Backing up databases to a cloud offers benefits such as availability, reliability and simplicity. Backup SQL databases to SkyDrive or Box clouds with SQLBackupAndFTP

Download sql backup master full