Cloud Attached Storage

(1)

Backing Up and Restoring

SQL Server Databases

Cloud Attached

Storage®

February 2014

Version 4.0

(2)

Information in this document is subject to change without notice and does not represent a commitment on part of CTERA Networks Ltd.

CTERA, C200, C400, C800, P1200, CloudPlug, NEXT3, Cloud Attached Storage, and Virtual Cloud Drive are trademarks, service marks, or registered trademarks of CTERA Networks Ltd.

All other product names mentioned herein are trademarks or registered trademarks of their respective owners.

The products described in this document are protected by U.S. patents, foreign patents, or pending applications.

(3)

Cloud Attached Storage® Backing Up and Restoring SQL Server Databases 3

This document explains how to backup your SQL server databases and restore them from a file-level backup.

1

Introduction

(4)

If your CTERA Agent is connected to a CTERA appliance, use the following procedures to back up and restore your SQL server databases.

Backing Up SQL Server Databases

To back up SQL server databases

1 Right-click on the CTERA Agent tray icon in the notification area of the Windows taskbar, and then click Settings.

If you are prompted for a username-password authentication, enter your credentials.

The CTERA Agent Manager opens displaying the Control Panel tab.

2 Click the File-level Backup tab.

2

Backing Up and Restoring SQL

Server Databases Using CTERA

Agent in Appliance Mode

(5)

Backing Up and Restoring SQL Server Databases Using CTERA Agent in Appliance Mode 2

The File-level Backup tab appears.

3 In the Applications to Back Up field, click . The Select Applications window opens.

(6)

2 Backing Up and Restoring SQL Server Databases Using CTERA Agent in Appliance Mode

6 Cloud Attached Storage® Backing Up and Restoring SQL Server Databases

4 Click on the + icons to expand the All Applications node, then select the check boxes next to the databases you want to back up.

5 Click OK.

6 Click Save.

7 Click the Control Panel tab.

The Control Panel tab appears.

8 Click Go.

The SQL server databases are backed up.

Restoring SQL Server Databases

Tip

This procedure explains how to restore an entire SQL Server database.

Tip

In order to restore databases backed up by CTERA to a new server instance, make sure the new server meets the following requirements:

The SQL version on the new server is the same as the SQL version on the old server.

The computer name of the new server is the same as the computer name of the old server.

The SQL Server name on the new server is the same as the SQL Server name on the old server.

To restore SQL server databases

1 Connect your CTERA Agent to the CTERA appliance.

For information, refer to the appliance's user guide or the CTERA Agent User Guide.

2 Right-click on the the CTERA Agent tray icon in the notification area of the Windows taskbar, and click Restore.

(7)

Backing Up and Restoring SQL Server Databases Using CTERA Agent in Appliance Mode 2

The CTERA Agent Manager opens displaying the Restore tab.

3 Next to the desired snapshot, click Restore.

The Restore Files from Backup dialog box opens.

4 Expand the list using the + icon and select the databases you would like to restore.

5 Click Next.

(8)

2 Backing Up and Restoring SQL Server Databases Using CTERA Agent in Appliance Mode

The Restore In Progress screen appears with a progress bar.

6 Click Finish.

(9)

If your CTERA Agent is connected to the CTERA Portal, use the following procedures to back up and restore your SQL server databases.

Backing Up SQL Server Databases

To back up SQL server databases

1 Right-click on the CTERA Agent tray icon in the notification area of the Windows taskbar, and then click Settings.

If you are prompted for a username-password authentication, enter your credentials.

The CTERA Agent Web interface opens in your Web browser, displaying the Cloud Backup Control Panel page.

2 In the navigation pane, click Backup Options > Backup Applications.

3

Backing Up and Restoring SQL

Server Databases Using CTERA

Agent in Cloud Mode

(10)

3 Backing Up and Restoring SQL Server Databases Using CTERA Agent in Cloud Mode

The Backup Applications page appears.

3 Click on the + icons to expand the All Applications node, then select the SQL Server databases you want to back up.

4 Click Save.

5 In the navigation pane, click Main > Cloud Backup.

The Cloud Backup Control Panel page appears.

6 Click Backup Now.

A progress bar appears, and the Microsoft SharePoint Server is backed up.

(11)

Backing Up and Restoring SQL Server Databases Using CTERA Agent in Cloud Mode 3

Restoring SQL Server Databases

Tip

This procedure explains how to restore an entire SQL Server database.

Tip

In order to restore databases backed up by CTERA to a new server instance, make sure the new server meets the following requirements:

The SQL version on the new server is the same as the SQL version on the old server.

The computer name of the new server is the same as the computer name of the old server.

The SQL Server name on the new server is the same as the SQL Server name on the old server.

To restore SQL server databases

1 Connect your CTERA Agent to the CTERA Portal.

For information, refer to the CTERA Agent User Guide.

2 Right-click on the the CTERA Agent tray icon in the notification area of the Windows taskbar, and click Restore.

The Restore Files Wizard opens displaying the Select Files to Restore dialog box.

3 Expand the list using the + icon and select the databases you would like to restore.

4 Click Next.

(12)

3 Backing Up and Restoring SQL Server Databases Using CTERA Agent in Cloud Mode

The Restore Files dialog box appears.

5 Choose Overwrite the destination file.

6 Click Next.

The Completing the Restore Files Wizard screen appears.

7 Click Finish.

Tip

You can monitor the restoration process from the CTERA Cloud Agent's Web Interface.