ACRONIS Recovery MS SQL Server - Upgrade AAS to AAP Spécifications

10The Acronis Recovery for MS SQL Server Management Console automatically detects all database servers on the network. The servers are displayed cle

11Configure your backup strategy in seconds by importing a preexisting Microsoft SQL Server Maintenance Plan • Rolling snapshot creation Automatic

12• SAN, NAS • FTP • Tapes, Autoloaders, Tape Libraries Backup Modes: • Full • Differential • Transaction Logs Backup Features: • Tune backu

13• Remote agent installation 1.5 Supported Microsoft SQL Server versions • Microsoft SQL Server 7.0 (SP4+) • Microsoft SQL Server 2000 (SP3a+,

14Trial Serial Numbers Acronis allows you to have a trial serial number to be able to use Acronis Recovery for MS SQL Server for 14 days without buy

15Chapter 2. Understanding Acronis Recovery for MS SQL Server This chapter provides common information about working with Acronis Recovery for MS SQ

16Below are diagrams describing interaction between Management Console, Agent and SDK. Integration between Acronis Recovery for MS SQL Server and A

17Chapter 3. Installation of Acronis Recovery for MS SQL Server From this chapter you will learn how to install Acronis Recovery for MS SQL Server c

18Naturally, you are free to use administrator credentials for both purposes. This will work, but make sure it conforms to the security policy set i

19 It is recommended that you install Acronis Recovery for MS SQL Server Management Console first. This will allow you to install Acronis Recovery f

2Copyright © Acronis, Inc., 2008. All rights reserved. “Acronis”, “Acronis Compute with Confidence”, and the Acronis logo are trademarks of Acronis,

20 Click Next to continue. 2. Select the program you want to install on the remote computer from the list and click Next. 3. Enter a serial numbe

21 4. Select the computer in the Computer field: enter a computer name manually or click Browse… and select the required computer from the tree. En

22 By connecting to a remote computer with Acronis Recovery for MS SQL Server Agent installed, you can set up backup and recovery tasks, browse logs

233.3.4 Removing Acronis Recovery for MS SQL Server Components You can remove any Acronis Recovery for MS SQL Server component separately by selecti

24Chapter 4. Getting started with Acronis Recovery for MS SQL Server This chapter will help you to start working with Acronis Recovery for MS SQL Se

25• Connect to a Remote Computer – connect to a remote server where Acronis Recovery for MS SQL Server Agent is already installed If you select a

26• Restore – restore databases from a previously created archive • Backup Location Clean-up - clean database backup locations • Disaster Recover

27• Restore - restore databases from a previously created archive • Backup Location Clean-up - clean database backup locations • Disaster Recover

28 4.4 Management Acronis Recovery for MS SQL Server Management Console allows installation Acronis Recovery for MS SQL Server components on remote

29 4.6 Adding Servers If, for any reason, a server cannot be found with the Discover Computers tool, you can add it to the tree manually. You can a

3ACRONIS, INC. End User License Agreement (EULA) BEFORE INSTALLING AND USING THE SOFTWARE PRODUCT WHICH EITHER YOU HAVE DOWNLOADED OR IS CONTAINED

302. Click OK to add the server to the tree. 4.7 Connecting to a Remote Database Server In order to perform any operation on a remote database ser

314.8 Remote Installation of Acronis Recovery for MS SQL Server Agent The remote installation of Acronis Recovery for MS SQL Server Agent is descr

32Chapter 5. Creating Backup Archives This chapter provides general information about backup methods, describes how to backup Microsoft SQL Server d

33A full backup contains all data at the moment of backup creation – a complete database or instance. You can recover the entire database by restor

34- Transaction Logs backup every hour • Database size is large and activity is high, recovery model is Full or Bulk-Logged: - Full backup once a

355.1.5 Backup Levels Acronis Recovery for MS SQL Server allows backs up databases, as well as separate filegroups. You can choose to back up datab

36to a tape drive in the local network (section 3.8.3 “Setting up Backup to a Tape or a Tape Library in the Local Network” of the User’s Guide). Ba

37 If you are not sure which backup strategy to choose, use Schedule a backup task with Acronis Recovery for MS SQL Server Assistant (selected by de

38 5.2.3 Selecting Objects to Back Up In the left pane of the window select a server with Microsoft SQL Server installed and specify Microsoft SQL

39 You can also use the Change link to change the credentials for connecting to the Microsoft SQL Server (see 5.2.3 for details). Selecting Database

4Standard Software license. A standard Software License is the general license that is available to LICENSEE. Unless the Virtual Editio

40• Full backup is created - Rolling Snapshots will be created immediately after creation of the full backup • Differential backup is created - R

41After selecting the appropriate object for back up, click Next to continue. 5.2.4 Specifying Credentials In the first step of this wizard you sp

42 Acronis Backup Server This software application, when installed on a networked computer, automatically manages backup archives and retention poli

43 Note, the further you store the backup archive from the original location, the safer it will be in case of data damage. For example, saving the a

44Acceptable Data Loss At this step specify a period of time when data changes significantly. This will help the Acronis Recovery for MS SQL Server

45 Click Next to continue. Server Load During a Day Specify workload distribution on the database server throughout the day. As in the previous ste

46• On the specified date and time – the selected scheme will be applied at the specified date. Note, that if there is no full backup when the firs

47Transaction logs 12 hours 12 hours 12 hours 5.2.7 Setting Backup Scheduling Parameters If you used the Acronis Recovery for MS SQL Server As

48 5.2.9 Specifying a Task Name and Providing Comments On the Task Name and Archive Comments wizard page, you can provide a name and comments for

49Click Finish to save the created schedule or start the backup creation task immediately. You will be redirected to the Task List automatically, w

5RESULTS AND PERFORMANCE OF THE SOFTWARE IS ASSUMED BY LICENSEE. FURTHERMORE, LICENSOR DOES NOT WARRANT OR MAKE ANY REPRESENTATIONS REGARDING THE US

505.3.1 Pre/Post Commands You can specify commands (or even batch files) that will be automatically executed before and after the backup procedure.

51 5.3.3 Backup Priority You can set up the backup process priority: • Low - the backup process will run slower, but it will not influence other pro

525.3.4 Backup Protection Password The preset is No Password. You can password protect your archives so that they will be inaccessible to others. En

53You can specify the behavior of Acronis Recovery for MS SQL Server when creating differential backup or backing up transaction logs of databases w

54 5.3.7 Additional Settings Validate backup archive once it has been created When enabled, the program will verify the integrity of the archive im

55Chapter 6. Disaster Recovery Plan It is extremely important for all organizations and users to have detailed instructions describing the process f

56 2. Select the databases you want to obtain the Disaster Recovery Plan for 3. Choose whether you want to receive the Disaster Recovery Plan by

575. The final stage of the Disaster Recovery Plan Creation wizard is the summary window, which display the list of operations to be performed. Cl

58 4. The final stage of the Disaster Recovery Plan Creation wizard is the summary window which displays the list of operations to be performed. Cl

59 Chapter 7. Import a Maintenance Plan With Acronis Recovery for MS SQL Server, you are able to import an existing Microsoft SQL Server Maintenance

Table of Contents CHAPTER 1. INTRODUCING ACRONIS RECOVERY FOR MS SQL SERVER... 9 1.1 WHAT IS ACRONIS RECOVERY FOR MS SQL SERVER...

60 7.2 Selecting a Maintenance Plan Select the database maintenance plan you want to import from the tree in the left pane. Information about the se

61Chapter 8. Backup Location Clean-up Sooner or later the backups you create will fill up the assigned storage space. Acronis Recovery for MS SQL Se

62 8.3 Providing a Password If there are any password-protected backup archives in the location you have selected (see 8.2), you will need to enter

63Select the Consider maximum full backup check box and type or select the maximum number of full backup archives to store. 8.5 Schedule Cleaning A

64

65Chapter 9. Restoring the Backup Data Launch the Restore Data wizard by clicking on the restore operation icon in the main workspace. 9.1 Restore 9

66the server and, by default, for connecting to the Microsoft SQL Server (if you do not specify another account for Microsoft SQL Server while selec

679.1.5 Providing a Password If there are any password-protected backup archives in the location you have selected (see 9.1.3), you will need to ent

68from and click OK. As with restoring to the time of the latest backup, Acronis Recovery for MS SQL Server will restore databases from Full, Differ

69 Restoring Databases Choose the database to restore. You can set all the recovery parameters as described above in the Restoring instances section

75.2.4 Specifying Credentials ... 41 5.2.5

70 Click OK to continue. Restoring System Databases System databases can only be restored from a backup created in the Microsoft SQL Server version

71 If the filegroup restore completes with an error message about the database checksum validation failure (824), the database is not consistent af

729.1.10 Restore Summary In the final step, the restoration summary is displayed. Up to this point, you can click Back to make changes in the create

739.2.1 Pre/Post Commands You can specify commands or batch files to be automatically executed before and after the restore procedure. Click Edit t

74 9.2.3 Additional Settings Backup archive validation Before data is restored from the archive, Acronis Recovery for MS SQL Server can check its in

75

76Chapter 10. Scheduling Tasks 10.1 What is a task? A task is a job you execute for a database that includes the type of operation (backup, resto

77Daily - the task will be executed daily at the specified time. You can set the following parameters: Parameter Description Recur every (…) days Th

78End date Select this check box to specify the date when this schedule will be disabled Monthly - the task will be executed monthly at the speci

79 One time - the task will be executed once at the specified time and day. You can set the Start time parameter: specify the date and time to start

8CHAPTER 12. NOTIFICATIONS ... 82 12.1 E-MAIL NOT

80Chapter 11. Managing Tasks To manage operations, click Manage Tasks in the Pick a Tool group or select the Tools -> Manage tasks menu item.

8111.1 Editing a Task To edit a task, select it in the Tasks window and click Edit Task on the left. Follow the wizard’s instructions on the screen.

82Chapter 12. Notifications Acronis Recovery for MS SQL Server can notify you when a task is complete using an SNMP service or via e-mail. By defau

83You can check if the settings are correct by clicking the Send Test E-mail Message button. 12.2 SNMP You can choose whether to send event log mess

84• Warnings and errors - warnings and error messages will be recorded to the Windows Event Log • Errors only - only error messages will be recor

85 Chapter 13. Viewing Logs Users can view the Acronis Recovery for MS SQL Server working logs. The logs provide information about scheduled task r

86Appendix A. Acronis Recovery for MS SQL Server: Best Practices This section provides instructions for best practices when using Acronis Recovery

87e. Use default settings for backup f. Add the necessary comments for the task g. Save the created task To recover all data in case of hardware

88 Only one database will be restored to the selected point in time. To recover all data in case of a virus attack For all servers perform the follo

89name, and the old server must remain operational (to provide fast database rollback in case a contingency occurs). Acronis solution 1. Install a

9Chapter 1. Introducing Acronis Recovery for MS SQL Server This chapter provides general information about a new Acronis product - Acronis Recovery

90Acronis solution While creating a backup task, the database administrator should specify a Disaster Recovery Plan option, so that it would be sent

91Appendix B. Installing Acronis Recovery for MS SQL Server from command line Acronis Recovery for MS SQL Server supports the Microsoft Installer ut

92Reinstall Options /f[p|o|e|d|c|a|u|m|s|v] <Component.msi | ProductCode> Reinstalls or upgrades the product p – reinstalls only missing file

93w - Logs nonfatal warnings e - Logs all error messages a - Logs startup of actions r - Logs action-specific records u - Logs user requests c - Log

94Options for Advertising Using a Transform msiexec /j[u][m] component /t TransformList User Interface Level Options msiexec /q{n|b|r|f|n+|b+|b-} /