Step-by-Step SqlBak Setup: Secure Offsite Backups in MinutesOffsite backups are a cornerstone of any resilient database strategy. SqlBak provides an easy-to-use service to automate SQL Server backups, securely store them offsite, and restore quickly when needed. This step-by-step guide walks you through setting up SqlBak, configuring secure offsite storage, scheduling backups, testing restores, and best practices to ensure your backups protect your business.
What is SqlBak and why use it?
SqlBak is a cloud-based service that automates backing up SQL Server databases (including Azure SQL and SQL Server on-premises), stores backups to remote storage (S3, Google Drive, FTP, OneDrive, Azure Blob, etc.), and provides restore, monitoring, and alerting tools. Use SqlBak when you want:
- Automated, scheduled backups without scripting.
- Secure offsite storage to protect against local failures or disasters.
- Easy restore and point-in-time recovery for quick recovery.
- Centralized monitoring and alerts for backup health.
Prerequisites
Before you begin, prepare the following:
- A SqlBak account (sign up at the SqlBak website).
- A Windows machine with internet access that can reach your SQL Server instance — this acts as the agent host.
- Administrative credentials for the SQL Server instance (or credentials with backup privileges).
- Access/credentials for the remote storage you’ll use (S3, Google Drive, Azure Blob, FTP, etc.).
- Optional: firewall rules allowing outbound connections from the agent host to SqlBak and your storage provider.
Step 1 — Create your SqlBak account and add a new server
- Sign up and log in to your SqlBak dashboard.
- From the dashboard, click “Add Server” (or similar).
- Choose the connection method:
- For on-premises SQL Server: install the SqlBak Agent on a Windows machine that has network access to the SQL Server.
- For Azure SQL/managed instances: use the connection string and credentials.
- Provide a friendly name for the server, the server address, authentication type (Windows/SQL), and credentials with backup permissions.
- Test the connection to ensure SqlBak can access the instance.
Step 2 — Install and configure the SqlBak Agent
- Download the SqlBak Agent installer from your account dashboard.
- Run the installer on the Windows machine that will act as the agent host.
- During installation:
- Enter the API key/token from your SqlBak account to link the agent.
- Allow the agent to run as a Windows service so it starts automatically.
- Verify the agent appears online in the SqlBak dashboard and is associated with the correct server.
Step 3 — Choose offsite storage and create backup jobs
- In SqlBak, navigate to “Locations” or “Backup Storage” and add the offsite destination:
- AWS S3: provide access key, secret key, bucket name, and region.
- Azure Blob: provide connection string/container.
- Google Drive/OneDrive: authenticate via OAuth.
- FTP/SFTP: provide host, port, username, password/key.
- Once the storage location is added, create a new Backup Job:
- Select the server and database(s) to back up.
- Choose the backup type: Full, Differential, Transaction Log (for point-in-time recovery).
- Pick the storage location and folder path.
- Configure compression and encryption (see security section below).
- Set retention rules (how many copies/days to keep).
- Configure notifications (email/Slack/webhook) for success/failure.
Step 4 — Schedule backups and retention
- Set a schedule that balances recovery point objectives (RPO) and resource use:
- Full backups: daily or weekly depending on database size and change rate.
- Differential backups: between full backups to reduce time and storage.
- Transaction log backups: every 5–15 minutes for low RPOs.
- Use staggered schedules for large databases to avoid overlapping heavy workloads.
- Configure retention to meet compliance and storage cost goals (e.g., keep daily backups 14 days, weekly 8 weeks, monthly 12 months).
Step 5 — Secure your backups
Security is critical for offsite backups. Apply these settings:
- Enable AES-256 encryption in SqlBak when creating backup jobs to encrypt backup files at rest.
- Use encrypted connections for storage endpoints (S3 over HTTPS, SFTP instead of FTP).
- Restrict storage credentials and rotate keys periodically.
- Use role-based access in SqlBak for team members — give only necessary permissions.
- Keep the agent host patched and limit network access to it.
Note: Encryption and secure transport protect data confidentiality; retention and access controls protect availability and integrity.
Step 6 — Test restores regularly
Backups are only useful if they can be restored. Schedule periodic restore tests:
- Use the SqlBak “Restore” feature to list available backups from your offsite storage.
- Restore to a test server or new database name to verify backup integrity.
- For point-in-time recovery, verify transaction log restores and consistency.
- Document the restore procedure and estimated recovery time objective (RTO).
A good practice: perform a complete restore at least quarterly and after major schema or infrastructure changes.
Step 7 — Monitor, alert, and maintain
- Configure alerts for:
- Failed backups
- Long-running backups
- Low storage space in target location
- Use the dashboard to review backup history and trends.
- Periodically review and adjust schedules, retention, and storage choices as data grows.
- Keep the SqlBak Agent and server updated.
Troubleshooting common issues
- Agent offline: check Windows service, internet connectivity, firewall outbound rules.
- Authentication errors: verify SQL credentials and permissions, or reauthorize OAuth for cloud drives.
- Storage upload failures: check bucket/container permissions, network bandwidth, and storage quotas.
- Large backups slow: enable compression, schedule during off-peak hours, consider differential strategy.
Best practices checklist
- Use multiple backup types: full + differential + transaction logs.
- Encrypt backups with AES-256 and use secure transport.
- Keep at least one recent on-premises copy for fast restores and offsite for disaster recovery.
- Test restores regularly and document procedures.
- Monitor backup health and rotate storage keys/credentials.
Pricing and alternatives
SqlBak is a paid service with tiered plans based on the number of servers and features. Compare features like supported storage, encryption, scheduling flexibility, and monitoring when evaluating alternatives such as native SQL Server Agent scripts with cloud uploads, Veeam, Redgate SQL Backup, or custom PowerShell/Azure Automation solutions.
SqlBak simplifies setting up secure offsite backups for SQL Server with an agent-based workflow, encrypted storage options, and built-in scheduling and restore tools. Following the steps above you can have automated, secure offsite backups running in minutes and tested to meet your recovery objectives.