> 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 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 New Task> Tab on SQL;

sql-backup-1

Step 2. Login with Windows Authentication or with SQL Server Authentication.

sql-backup-2

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.

sql-backup-4

  • Plan: schedule (daily, weekly, monthly), backup type (full backup, differential backup, transaction log backup).

sql-backup-5

  • Options: Email-notification, Encryption, Backup Mode, etc

sql-backup-5

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 select the MS SQL Server backup task from the backup task list.

sql-recovery-1

Step 2. Then click "Recovery" on the top to restore the database backup files. You can choose to  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. For more information, please refer to Version Comparison.

EaseUS
Todo Backup for Mac

All-in-one software for Mac data backup and recovery, backup archive, disk clone and file synchronization.