> How to > Todo Backup Guide > Backup and restore SQL Server 2008/2005/2000 database

Backup and restore SQL Server 2008/2005/2000 database

2014-09-02 15:18:55 Posted by Hana Lee to Todo Backup Guide

Summary:
To avoid to loss the crucial business data, we need to backup SQL Server database to the local, tape, hard disk or network etc. EaseUS Todo Backup would be the high speed and efficient storage backup solution.

Today the SQL Server database is used widely in the business and backup Server also becomes essential. To avoid the potentially catastrophic data loss due to media failure, user wrong operation, hardware failures or other unexpected reasons, we need to backup the databases.

EaseUS Todo Backup Advanced Server, the Server backup software, is designed for business can perform SQL Server backup and recovery to ensure the stability of business. The advanced backup solution reduces the backup, recovery time and minimize the storage costs. It protects all databases stored on SQL Server and helps recover the database when servers fail.

  • Supportive SQL Server: Microsoft SQL Server 2000, SQL Server 2005, SQL Server 2008 and SQL Server 2008 R2.
  • Backup device and backup media: Support storing SQL backup to tape, backup to hard disk, backup to network, backup to removable disk. Certainly, also support Backup and restore SQL Server on the local.
  • Support the full backup, differential backup and transaction log backup. With the full backup, it can backup all database stored on SQL Server. Differential backups of SQL Server - Only backup the changed database stored on Microsoft SQL Server since the last full backup. Transaction log backup - Simply backup the transaction log since the last transition log backup. It is quite fast, but reconstructing the database from a chain of transaction log backups is the slowest method of recovery.
  • Support three SQL recovery models: Full recovery, bulk-logged recovery, simple recovery.
  • Support the online backup. We can normally operate the SQL server when backup, the backup has no effect to the Server work.
  • Reduce the storage cost: use the standard compression technique to compress the SQL backup, save storage space.
  • Supportive the operating systems: Windows Server 2016/2012/2003/2008 32 bit and 64 bit operating systems.

Besides the features, EaseUS Todo Backup Advanced Server also supports Exchange Server 2003/2007/2010 backup and restore. With the schedule backup, users can backup Microsoft SQL Server every day, week, month, or set your own period. It will notify administrator the backup results by sending E-mail.

How to backup SQL Server database with EaseUS Todo Backup Advanced Server?

Step 1. Launch EaseUS Todo Backup, click Other Backups -> SQL Backup.

sql-backup-1

Step 2. Login with Windows Authentication or with SQL Server Authentication.Then click Backup.

sql-backup-2

sql-backup-3

Step3. Select the SQL database you want to backup from the left side of the window. You need to customize some information like name, destination etc.
Basic information: task name, destination, backup now or set a schedule, continue if error.
Plan: schedule (daily, weekly, monthly), backup type (full backup, differential backup, transaction log backup).

sql-backup-4

Options: compression, recovery model, notification.

sql-backup-5

sql-backup-6

There are there recovery models: simple recovery, bulk-logged recovery, full recovery
Simple recovery - doesn't use a log file for transactions
Bulk-logged recovery - records most transactions individually, but others in "bulk" fashion
Full recovery(the default) - records every transaction in a log file

Step 4. Click Proceed to execute task for SQL Server backup.

How to restore SQL Server database with EaseUS Todo Backup Advanced Server?

Step 1 . Run the EaseUS Todo Backup and click SQL Backup. And login with Windows Authentication or with SQL Server Authentication, Select Recovery.

sql-recovery-1

Step 2. Choose the image files, select recovery method (Overwrite database or Recover to a new database), then click Proceed to execute the recovery task.

Tips: Only EaseUS Todo Backup Advanced Server Edition and Technician Edition support SQL Server backup and restore. More information refer to Editions Comparison.