Quick Start Guide for Microsoft SQL Backup & Recovery

Quick Start Guide for Microsoft SQL Backup & Recovery

About Microsoft SQL Backup & Recovery

BDRSuite delivers data protection for Microsoft SQL Server, enabling full, differential, and transaction log backups for comprehensive database recovery options. It supports automated backup scheduling, ensuring minimal disruption to database operations. Advanced features include granular recovery of individual databases and customizable retention policies for optimized storage management. Centralized monitoring and reporting streamline operations, providing actionable insights for effective SQL Server backup management.

Getting Started

Step 1: Planning

Required Components:
1. BDRSuite Backup Server
2. Microsoft SQL Server
System Requirements(Backup Server): Windows Server 2012 R2 Core (Standard or Datacenter) & above. To learn more, refer to the System Requirements.
Supported Platform(MS SQL Server): 
Port Configuration:

Step 2: Deploying Backup Server

BDRSuite Backup Server is the central management component for configuring, scheduling, managing backups and recovery across virtual, physical, cloud, and SaaS environments. This server has to be installed and hosted on a dedicated machine.
  1. BDRSuite Backup Server Installation on Windows
  2. BDRSuite Backup Server Installation on Linux
  3. BDRSuite Backup Server Installation on Docker containers
After installation you can access the backup server by navigating to http://<IP Address>:6060 or http://localhost:6060 in your browser.
Watch BDRSuite Backup Server installation on Windows video.

Configuring Microsoft SQL Backup & Recovery 

Step 1: Creating a Storage Repository to store the Backup data

  1. BDRSuite supports on-premise storage options and remote solutions, including DAS, NAS, SAN. You can navigate to the Infrastructure -> Backup Repository tab choose Block Storage. Refer to Block Storage Repository to learn more.
Watch creating Block Storage Repository video

  1. BDRSuite also supports public cloud services like Amazon S3, Azure Blob, Google Cloud, and S3-compatible platforms such as Wasabi, MinIO, and Backblaze. You can navigate to the Infrastructure -> Backup Repository tab choose Object Storage. Refer to Object Storage Repository to learn more.

Step 2: Adding Microsoft SQL Backup Sources

To configure backups and restores, the Microsoft SQL Server must be added to the BDRSuite Backup Server. Navigate to Data Source -> Microsoft SQL Server  and click on Add SQL Server, and enter the required credentials to integrate the MS SQL source. To learn more, refer to the Adding Microsoft SQL Backup Source.

Watch Adding Data Source Video.

Step 3: Configuring Microsoft SQL Backups

To configure MS SQL backups within the BDRSuite Backup Server, follow the steps to set up backup jobs, schedule them, manage retention policies, and ensure effective data protection. Navigate to the Backup -> Configure Backup -> SQL Server Database.

Configure Microsoft SQL Backup
  1. Specify a backup job name & select the backup repository
  2. Select MS SQL Server instance for backup
  3. Select the database
  4. Schedule when you want backups to run
  5. Configure settings
  6. Save the backup job. The backup will run as per schedule
  7. You can centrally manage and monitor backups
Refer MS SQL Configuration to learn more.

Step 4: Recovering MS SQL Backups

To perform recovery operations for Microsoft SQL backup jobs, follow the steps outlined. Navigate to Recovery -> Restore Backup Data and click on the Restore button alongside the respective MS SQL backup job you wish to restore.

Microsoft SQL Recovery
  1. Choose the MS SQL Server from which you want to restore.
  2. Select the Restore type.
  3. Select Restore Point or timestamp to restore
  4. Specify the restore details and initiate the restore
Refer to the MS SQL Recovery for more information.

Step 5: Managing Microsoft SQL Backups

In BDRSuite Backup Server, managing MS SQL backup jobs involves navigating to Backup -> List Backup Jobs where you can perform various actions like searching, scheduling, and editing backup jobs. You can also suspend, resume, or abort jobs, adjust schedules, and even generate job reports. For more information, refer to managing backup jobs.

Step 6: Reporting & Notification

The Reports section provides information on automatically generated reports for MS SQL backups in BDRSuite Backup Server, including backup and recovery status, job summaries, and error logs. It also explains how notifications can be configured to keep users informed about the status of Microsoft SQL backup operations and any issues that may arise. You can navigate to the Reports tab in the BDRSuite Backup Server console. To learn more, refer to Reporting & Notifications.

Watch Microsoft SQL Backup & Recovery Demo Video.

Secondary Copy for MS SQL Backups

Secondary Copy - Offsite Copy

Offsite Copy page provides instructions on configuring Offsite Copy/DR in BDRSuite Backup Server, where backup data is replicated to a DR server in an offsite location for disaster recovery purposes. It explains how to set up offsite copy jobs for Microsoft SQL backups, allowing backup data to be stored securely in a remote location, ensuring data availability and business continuity in the event of site failure. To learn more refer to the Secondary Copy - Offsite Copy.

Watch Secondary Copy - Offsite Copy Video.

Backup Settings

For detailed guidance on configuring and managing backup settings in BDRSuite Backup Server, including features like concurrent backups, bandwidth throttling, and more to optimize backup performance and resource management. You can navigate to Backup -> Configure Backup Settings. To learn more, refer to the Backup Settings.

Purchase & Manage Licenses

Licensing in BDRSuite enables seamless management of Microsoft SQL Backup & Recovery, including activation, renewal, and allocation of licenses to ensure uninterrupted backup and recovery operations. For further details, refer to the Purchase & Manage License guide, which provides step-by-step instructions.

Watch Purchase & Manage License Video.


    • Related Articles

    • Quick Start Guide for Microsoft Azure Backup & Recovery

      About Microsoft Azure Backup BDRSuite provides a robust solution for protecting Microsoft Azure resources, including Azure VMs, Azure Files, and SQL databases. It supports automated incremental backups, granular recovery, and secure storage across ...

    • Quick Start Guide for Microsoft 365 Backup & Recovery

      About Microsoft 365 Backup & Recovery BDRSuite provides a comprehensive solution for protecting Microsoft 365 data, including Mailbox, Group Mailbox, SharePoint and Teams. It ensures secure backups with flexible retention policies and incremental ...

    • Quick Start Guide for KVM Backup & Recovery

      About KVM Backup & Replication BDRSuite provides a robust and reliable solution for protecting KVM-based virtual environments. It supports full and incremental backups, flexible scheduling, offsite replication, and centralized management. Whether ...

    • Quick Start Guide for VMware Backup & Replication

      About VMware Backup & Replication BDRSuite offers a robust solution for protecting VMware vSphere virtual machines with features like agentless, image-level backups, CBT for incremental backups, and application-aware processing. It supports granular ...

    • Quick Start Guide for oVirt Backup & Recovery

      About oVirt Backup & Recovery BDRSuite provides agentless, image-level backups for oVirt virtual machines, leveraging Changed Block Tracking (CBT) for efficient incremental backups and supporting automated scheduling. Backup data is secured with ...