ACRONIS Recovery for MS SQL Server, ESD, 1u, Standard, FRE Spécifications

Copyright © Acronis, Inc., 2000-2010 10 1.5 Supported Microsoft SQL Server versions • Microsoft SQL Server 7.0 (SP4+) • Microsoft SQL Server 200

11 Copyright © Acronis, Inc., 2000-2010 • you will find it in a CD box if you buy a licensed Acronis Recovery for MS SQL Server CD • you can recei

Copyright © Acronis, Inc., 2000-2010 12 Chapter 2. Understanding Acronis Recovery for MS SQL Server This chapter provides common information about

13 Copyright © Acronis, Inc., 2000-2010 Figure 1. Integration between Acronis Recovery for MS SQL Server and Acronis Recovery for MS SQL Server Age

Copyright © Acronis, Inc., 2000-2010 14 Chapter 3. Installation of Acronis Recovery for MS SQL Server From this chapter you will learn how to inst

15 Copyright © Acronis, Inc., 2000-2010 • server (Acronis Recovery for MS SQL Server Agents) UDP port: 9876 • server (Acronis Recovery for MS SQL

Copyright © Acronis, Inc., 2000-2010 16 the Management Console to any networked computer (for information about the remote installation see Insta

17 Copyright © Acronis, Inc., 2000-2010 Figure 5. Program selection window 3. Enter a serial number for the selected product. For information abou

Copyright © Acronis, Inc., 2000-2010 18 Figure 7. Computer selection window 5. The summary page displays all operations, which will be performed.

19 Copyright © Acronis, Inc., 2000-2010 3.3.3 Extracting Acronis Recovery for MS SQL Server Components For installing Acronis Recovery for MS SQL S

Copyright © Acronis, Inc., 2000-2010 2 Copyright © Acronis, Inc., 2000-2010. All rights reserved. “Acronis”, “Acronis Compute with Confidence”, and

Copyright © Acronis, Inc., 2000-2010 20 Chapter 4. Getting started with Acronis Recovery for MS SQL Server This chapter will help you to start wor

21 Copyright © Acronis, Inc., 2000-2010 Figure 10. Main area If you select a server in the Computers pane, on which Acronis Recovery for MS SQL Ser

Copyright © Acronis, Inc., 2000-2010 22 Backup – create a database backup archive Restore – restore databases from a previously created archive Bac

23 Copyright © Acronis, Inc., 2000-2010 The Operations menu contains two available operations: • Backup - create a database backup archive • Resto

Copyright © Acronis, Inc., 2000-2010 24 Figure 13. The Computers pane 4.4 Management Acronis Recovery for MS SQL Server Management Console allow

25 Copyright © Acronis, Inc., 2000-2010 Figure 14. Discovering servers 4.6 Adding Servers If, for any reason, a server cannot be found with the Di

Copyright © Acronis, Inc., 2000-2010 26 Figure 15. Adding servers 2. Click OK to add the server to the tree. 4.7 Connecting to a Remote Database

27 Copyright © Acronis, Inc., 2000-2010 Figure 16. Connecting to a Remote Database Server 4.8 Remote Installation of Acronis Recovery for MS SQL S

Copyright © Acronis, Inc., 2000-2010 28 Chapter 5. Creating Backup Archives This chapter provides general information about backup methods, descri

29 Copyright © Acronis, Inc., 2000-2010 state of the original database when the backup finished, minus any uncommitted transactions. For a small da

3 Copyright © Acronis, Inc., 2000-2010 Table of Contents TABLE OF CONTENTS ...

Copyright © Acronis, Inc., 2000-2010 30 - Transaction Logs backup every twenty minutes • Database size is large and activity is high, recovery mo

31 Copyright © Acronis, Inc., 2000-2010 5.1.6 Disaster Recovery Plan With Acronis Recovery for MS SQL Server you can create a Disaster Recovery Pla

Copyright © Acronis, Inc., 2000-2010 32 Backup and restore on a tape drive proceed in the same way as with other devices with the following excepti

33 Copyright © Acronis, Inc., 2000-2010 Figure 17. Defining a backup strategy If you are not sure which backup strategy to choose, use Schedule a b

Copyright © Acronis, Inc., 2000-2010 34 Figure 18. Specifying a task execution account 5.2.3 Selecting Objects to Back Up In the left pane of the

35 Copyright © Acronis, Inc., 2000-2010 Figure 19. Selecting objects to back up You can also use the Change link to change the credentials for conn

Copyright © Acronis, Inc., 2000-2010 36 • Full backup is created - Rolling Snapshots will be created immediately after creation of the full backup

37 Copyright © Acronis, Inc., 2000-2010 • model – used as the template for all databases created on the Microsoft SQL Server instance • msdb – u

Copyright © Acronis, Inc., 2000-2010 38 We recommend you to store the archives of each task in a separate location to avoid confusion during recove

39 Copyright © Acronis, Inc., 2000-2010 Figure 22. Selecting a backup archive location Acronis Recovery for MS SQL Server allows you to clean stora

Copyright © Acronis, Inc., 2000-2010 4 5.2.2 Specifying a Task Execution Account ...

Copyright © Acronis, Inc., 2000-2010 40 Figure 23. Performance window Click Next to continue. Acceptable Data Loss At this step specify a period o

41 Copyright © Acronis, Inc., 2000-2010 Click Next to continue. Server Load During a Week Specify the workload distribution on the database server d

Copyright © Acronis, Inc., 2000-2010 42 Figure 26. Server Load During a Day window Initial Task Starting Specify a time for applying the selected

43 Copyright © Acronis, Inc., 2000-2010 Figure 27. Initial Task Starting window Table of Backup Strategies The table below describes different back

Copyright © Acronis, Inc., 2000-2010 44 5.2.7 Setting Backup Scheduling Parameters If you used Acronis Recovery for MS SQL Server Assistant, Acron

45 Copyright © Acronis, Inc., 2000-2010 Figure 30. Backup Options window 5.2.9 Specifying a Task Name and Providing Comments On the Task Name and

Copyright © Acronis, Inc., 2000-2010 46 5.2.10 Backup Summary The final stage of the backup is the summary window, which displays the list of oper

47 Copyright © Acronis, Inc., 2000-2010 Figure 33. Setting default backup options 5.3.1 Pre/Post Commands You can specify commands (or even batch

Copyright © Acronis, Inc., 2000-2010 48 Figure 34. Pre/Post commands 5.3.2 Compression Level Select the compression level for the backup. With hi

49 Copyright © Acronis, Inc., 2000-2010 Figure 35. Compression level 5.3.3 Backup Priority You can set up the backup process priority: • Low - th

5 Copyright © Acronis, Inc., 2000-2010 11.2 DELETING A TASK ...

Copyright © Acronis, Inc., 2000-2010 50 Figure 36. Backup priority 5.3.4 Backup Protection Password The preset is No Password. You can password p

51 Copyright © Acronis, Inc., 2000-2010 Figure 37. Backup protection 5.3.5 Backup Type Substitution A full backup of the database is required befo

Copyright © Acronis, Inc., 2000-2010 52 Figure 38. Backup type substitution Note, if you use the Acronis Recovery for MS SQL Server Assistant

53 Copyright © Acronis, Inc., 2000-2010 5.3.7 Additional Settings Validate backup archive once it has been created When enabled, the program will

Copyright © Acronis, Inc., 2000-2010 54 Chapter 6. Disaster Recovery Plan It is extremely important for all organizations and users to have detail

55 Copyright © Acronis, Inc., 2000-2010 Figure 42. Selecting databases 3. Choose whether you want to receive the Disaster Recovery Plan by e-mail

Copyright © Acronis, Inc., 2000-2010 56 Figure 43. Disaster recovery plan options 2. Select the databases for which you want to obtain the Disast

57 Copyright © Acronis, Inc., 2000-2010 Click Finish to schedule receipt of the Disaster Recovery Plan after each update. 6.3 Summary Thus, in case

Copyright © Acronis, Inc., 2000-2010 58 Chapter 7. Import a Maintenance Plan With Acronis Recovery for MS SQL Server, you are able to import an ex

59 Copyright © Acronis, Inc., 2000-2010 7.2 Selecting a Maintenance Plan Select the database maintenance plan you want to import from the tree in t

Copyright © Acronis, Inc., 2000-2010 6 Chapter 1. Introducing Acronis Recovery for MS SQL Server This chapter provides general information about A

Copyright © Acronis, Inc., 2000-2010 60 Chapter 8. Backup Location Clean-up Sooner or later the backups you create will fill up the assigned stora

61 Copyright © Acronis, Inc., 2000-2010 Figure 46. Selecting a backup location 8.3 Providing a Password If there are any password-protected backup

Copyright © Acronis, Inc., 2000-2010 62 8.4 Specifying Cleaning Options Specify the maximum lifetime of an archive and the maximum number of full

63 Copyright © Acronis, Inc., 2000-2010 Figure 49. Schedule Cleaning window 8.6 Backup Location Clean-up Summary The final stage of the backup loc

Copyright © Acronis, Inc., 2000-2010 64 Chapter 9. Restoring the Backup Data Launch the Restore Data wizard by clicking on the restore operation

65 Copyright © Acronis, Inc., 2000-2010 Thus, the task will run as if it was started by the specified user. Enter the Username and password then cli

Copyright © Acronis, Inc., 2000-2010 66 9.1.5 Providing a Password If there are any password-protected backup archives in the location you have se

67 Copyright © Acronis, Inc., 2000-2010 Server will restore databases from Full, Differential and Transaction Logs backups (if any), but will not ap

Copyright © Acronis, Inc., 2000-2010 68 Figure 55. Contents selection Restoring Databases Choose the database to restore. You can set all the reco

69 Copyright © Acronis, Inc., 2000-2010 Figure 56. Contents selection Click OK to continue. Restoring System Databases System databases can only be

7 Copyright © Acronis, Inc., 2000-2010 1.2 Why Acronis Recovery for MS SQL Server Comprehensive recovery requires more than just data backup. Your

Copyright © Acronis, Inc., 2000-2010 70 Figure 57. Contents selection If the filegroup restore completes with an error message about the database

71 Copyright © Acronis, Inc., 2000-2010 9.1.9 Selecting Start Parameters You can run a restore task manually or specify the frequency (Daily, Weekl

Copyright © Acronis, Inc., 2000-2010 72 Figure 60. Setting default restore options 9.2.1 Pre/Post Commands You can specify commands or batch file

73 Copyright © Acronis, Inc., 2000-2010 • Normal - set by default. The restore process will run with normal priority • High - the restore process

Copyright © Acronis, Inc., 2000-2010 74 Figure 63. Additional settings

75 Copyright © Acronis, Inc., 2000-2010 Chapter 10. Scheduling Tasks 10.1 What is a task? A task is a job you execute for a database that includes

Copyright © Acronis, Inc., 2000-2010 76 days Start time Time for starting the task. The current time is set by default Repeat Task execution freq

77 Copyright © Acronis, Inc., 2000-2010 Figure 66. Setting weekly schedule Monthly - the task will be executed monthly at the specified time and da

Copyright © Acronis, Inc., 2000-2010 78 Figure 67. Setting monthly schedule One time - the task will be executed once at the specified time and da

79 Copyright © Acronis, Inc., 2000-2010 Chapter 11. Managing Tasks To manage operations, click Manage Tasks in the Pick a Tool group or select the

Copyright © Acronis, Inc., 2000-2010 8 Encryption Protect backups with strong industry-standard encryption technology. AES (Advanced Encryption Sta

Copyright © Acronis, Inc., 2000-2010 80 11.2 Deleting a Task To delete an existing task, select it in the Tasks window and click Delete Task on the

81 Copyright © Acronis, Inc., 2000-2010 Chapter 12. Notifications Acronis Recovery for MS SQL Server can notify you when a task is complete using

Copyright © Acronis, Inc., 2000-2010 82 12.2 SNMP You can choose whether to send event log messages issued by Acronis Recovery for MS SQL Server to

83 Copyright © Acronis, Inc., 2000-2010 • Errors only - only error messages will be recorded to the Windows Event Log Figure 72. Windows event lo

Copyright © Acronis, Inc., 2000-2010 84 Chapter 13. Viewing Logs Acronis Recovery for MS SQL Server working logs provide information about schedu

85 Copyright © Acronis, Inc., 2000-2010 Appendix A. Acronis Recovery for MS SQL Server: Best Practices This section provides instructions for bes

Copyright © Acronis, Inc., 2000-2010 86 a. Select the whole Microsoft SQL Server instance (or all available instances) as a backup source b. Sele

87 Copyright © Acronis, Inc., 2000-2010 b. Select the Restore to point in time option and specify the date and time manually, or select the backup

Copyright © Acronis, Inc., 2000-2010 88 A.3 Migrate to another Microsoft SQL Server version. Scenario The company needs to move a database to a

89 Copyright © Acronis, Inc., 2000-2010 A.6 Using the Disaster Recovery Plan to restore databases Scenario The business owner wants to be sure t

9 Copyright © Acronis, Inc., 2000-2010 • Tapes, Autoloaders, Tape Libraries Backup Modes: • Full • Differential • Transaction Logs Backup Featur

Copyright © Acronis, Inc., 2000-2010 90 Appendix B. Installing Acronis Recovery for MS SQL Server from command line Acronis Recovery for MS SQL S

91 Copyright © Acronis, Inc., 2000-2010 Reinstall Options /f[p|o|e|d|c|a|u|m|s|v] <Component.msi | ProductCode> Reinstalls or upgrades the pro

Copyright © Acronis, Inc., 2000-2010 92 i - Logs status messages w - Logs nonfatal warnings e - Logs all error messages a - Logs startup of actions

93 Copyright © Acronis, Inc., 2000-2010 TransformList - List of paths separated by semicolons Options for Advertising Using a Transform msiexec /j[