Specifications

Table of Contents
CHAPTER 1. INTRODUCING ACRONIS RECOVERY FOR MS SQL SERVER.................... 9
1.1 WHAT IS ACRONIS RECOVERY FOR MS SQL SERVER................................................................. 9
1.2 WHY ACRONIS RECOVERY FOR MS SQL SERVER .................................................................... 10
1.3 FEATURES ................................................................................................................................. 10
1.4 KEY FEATURES ......................................................................................................................... 11
1.5 SUPPORTED MICROSOFT SQL SERVER VERSIONS ..................................................................... 13
1.6 SUPPORTED PLATFORMS ........................................................................................................... 13
1.7 SUPPORTED OPERATING SYSTEMS ............................................................................................ 13
1.8 LICENSE POLICY ....................................................................................................................... 13
1.9 TECHNICAL SUPPORT ................................................................................................................ 14
CHAPTER 2. UNDERSTANDING ACRONIS RECOVERY FOR MS SQL SERVER ............ 15
2.1 COMPONENTS............................................................................................................................ 15
2.1.1 Acronis Recovery for MS SQL Server Management Console .............................................. 15
2.1.2 Acronis Recovery for MS SQL Server Agent........................................................................ 15
2.2 COMPONENTS INTEGRATION........................................................................................................... 15
CHAPTER 3. INSTALLATION OF ACRONIS RECOVERY FOR MS SQL SERVER .......... 17
3.1 MINIMUM SYSTEM REQUIREMENTS ................................................................................................ 17
3.2 SECURITY POLICY........................................................................................................................... 17
3.2.1 Credentials.............................................................................................................................. 17
3.2.2 Firewall Settings ..................................................................................................................... 18
3.3 GENERAL RULES OF INSTALLATION ................................................................................................ 18
3.3.1 Installing Acronis Recovery for MS SQL Server Components............................................... 18
3.3.2 Installing Acronis Recovery for MS SQL Server Agent Remotely........................................ 19
3.3.3 Extracting Acronis Recovery for MS SQL Server Components ........................................... 22
3.3.4 Removing Acronis Recovery for MS SQL Server Components ............................................ 23
CHAPTER 4. GETTING STARTED WITH ACRONIS RECOVERY FOR MS SQL SERVER
24
4.1 RUNNING ACRONIS RECOVERY FOR MS SQL SERVER MANAGEMENT CONSOLE ..................... 24
4.2 ACRONIS RECOVERY FOR MS SQL SERVER WORKSPACE ........................................................ 24
4.2.1 Main Area ................................................................................................................................ 24
4.2.2 Computers Pane................................................................................................................... 26
4.2.3 Program Menu......................................................................................................................... 26
4.2.4 Help Menu................................................................................................................................ 27
4.2.5 Status Bar................................................................................................................................. 27
4.3 NAVIGATION ............................................................................................................................. 27
4.4 MANAGEMENT .......................................................................................................................... 28
4.5 DISCOVERING SERVERS ............................................................................................................ 28
4.6 ADDING SERVERS ..................................................................................................................... 29
4.7 CONNECTING TO A REMOTE DATABASE SERVER ...................................................................... 30
4.8 REMOTE INSTALLATION OF ACRONIS RECOVERY FOR MS SQL SERVER AGENT ...................... 31
CHAPTER 5. CREATING BACKUP ARCHIVES........................................................................ 32
5.1 GENERAL INFORMATION.................................................................................................................. 32
5.1.1 What is a backup?.................................................................................................................... 32
5.1.2 Backup Methods....................................................................................................................... 32
5.1.3 Which Backup Strategy to Choose? ......................................................................................... 33
5.1.4 Recovery Models...................................................................................................................... 34
5.1.5 Backup Levels .......................................................................................................................... 35
5.1.6 Disaster Recovery Plan............................................................................................................ 35
5.1.7 Backing up to Tape Libraries and Tape Drives ................................................................... 35
5.2 BACKUP .......................................................................................................................................... 36
5.2.1 Defining a Backup Strategy ..................................................................................................... 36
5.2.2 Specifying a Task Execution Account......................................................................................37
5.2.3 Selecting Objects to Back Up................................................................................................. 38