Copyright © Acronis, Inc., 2008. All rights reserved. “Acronis”, “Acronis Compute with Confidence”, and the Acronis logo are trademarks of Acronis, Inc. Linux is a registered trademark of Linus Torvalds. Windows is a registered trademark of Microsoft Corporation. All other trademarks and copyrights referred to are the property of their respective owners. Distribution of substantively modified versions of this document is prohibited without the explicit permission of the copyright holder.
ACRONIS, INC. End User License Agreement (EULA) BEFORE INSTALLING AND USING THE SOFTWARE PRODUCT WHICH EITHER YOU HAVE DOWNLOADED OR IS CONTAINED ON THESE DISKS (“SOFTWARE”) YOU SHOULD CAREFULLY READ THE FOLLOWING LICENSE AGREEMENT (“AGREEMENT”) THAT APPLIES TO THE SOFTWARE. CLICK “ACCEPT” IF YOU FULLY ACCEPT AND AGREE TO ALL OF THE PROVISIONS OF THIS AGREEMENT. OTHERWISE, CLICK “DO NOT ACCEPT.
Standard Software license. A standard Software License is the general license that is available to LICENSEE.
RESULTS AND PERFORMANCE OF THE SOFTWARE IS ASSUMED BY LICENSEE. FURTHERMORE, LICENSOR DOES NOT WARRANT OR MAKE ANY REPRESENTATIONS REGARDING THE USE OR THE RESULTS OF THE USE OF THE SOFTWARE OR RELATED DOCUMENTATION IN TERMS OF THEIR CORRECTNESS, ACCURACY, RELIABILITY, CURRENTNESS, OR OTHERWISE. NO ORAL OR WRITTEN INFORMATION OR ADVICE GIVEN BY LICENSOR SHALL CREATE A WARRANTY OR IN ANY WAY INCREASE THE SCOPE OF THIS WARRANTY. Liability Limitations.
Table of Contents CHAPTER 1. 1.1 1.2 1.3 1.4 1.5 1.6 1.7 1.8 1.9 INTRODUCING ACRONIS RECOVERY FOR MS SQL SERVER .................... 9 WHAT IS ACRONIS RECOVERY FOR MS SQL SERVER ................................................................. 9 WHY ACRONIS RECOVERY FOR MS SQL SERVER .................................................................... 10 FEATURES .................................................................................................................................
5.2.4 Specifying Credentials ........................................................................................................... 41 5.2.5 Selecting a Backup Archive Location..................................................................................... 41 5.2.6 Using Acronis Recovery for MS SQL Server Assistant .......................................................... 43 5.2.7 Setting Backup Scheduling Parameters ................................................................................
CHAPTER 12. 12.1 12.2 12.3 NOTIFICATIONS .................................................................................................... 82 E-MAIL NOTIFICATIONS ............................................................................................................ 82 SNMP....................................................................................................................................... 83 WINDOWS EVENT LOG .......................................................................
Chapter 1. Introducing Acronis Recovery for MS SQL Server This chapter provides general information about a new Acronis product - Acronis Recovery for MS SQL Server, its features and advantages. You will learn about supported databases, operating systems and platforms. 1.1 What is Acronis Recovery for MS SQL Server Acronis Recovery for MS SQL Server offers a fast and reliable disaster recovery solution to protect your Microsoft SQL Server database.
The Acronis Recovery for MS SQL Server Management Console automatically detects all database servers on the network. The servers are displayed clearly with status information, making it easy to manage enterprise-wide installations • Easy Administration Intuitive wizard-driven GUI allows even non-DBAs to confidently configure and implement professional backup strategies. Acronis Recovery for MS SQL Server even lets you import an existing Microsoft SQL Server Maintenance Plan in just a few clicks 1.
Configure your backup strategy in seconds by importing a preexisting Microsoft SQL Server Maintenance Plan • Rolling snapshot creation Automatically created snapshots allow the database to be recovered in seconds - in cases of data corruption or human error - by simply discarding changes (for Microsoft SQL Server 2005 Enterprise Edition only) • Encryption Protect backups with strong industry-standard encryption technology.
• SAN, NAS • FTP • Tapes, Autoloaders, Tape Libraries Backup Modes: • Full • Differential • Transaction Logs Backup Features: • Tune backup strategy with Acronis Recovery for MS SQL Server Assistant • Backup several databases at once • Backup files/filegroups • Rolling snapshots on Microsoft SQL Server 2005 Enterprise • Protect backups with industry-standard encryption • Backup system databases • Verify backup • Keep many versions of archives • Online backup Restore Features •
• Remote agent installation 1.5 Supported Microsoft SQL Server versions • Microsoft SQL Server 7.0 (SP4+) • Microsoft SQL Server 2000 (SP3a+, both 32-bit and 64-bit versions) • Microsoft SQL Server 2000 Desktop Engine Release A • Microsoft SQL Server 2005 (both 32-bit and 64-bit versions) • Microsoft SQL Server 2005 Express Please note, Acronis Recovery for MS SQL Server is not a cluster-aware product. 1.6 Supported Platforms • x86 • x64 1.
Trial 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 buying the product. You may obtain the trial serial number in one of the following ways: • in a CD box • contacting Acronis sales representatives. See http://www.acronis.
Chapter 2. Understanding Acronis Recovery for MS SQL Server This chapter provides common information about working with Acronis Recovery for MS SQL Server. 2.1 Components Acronis Recovery for MS SQL Server includes the following components: • Management Tools including Acronis Recovery for MS SQL Server Management Console • Acronis Recovery for MS SQL Server Agent • SDK (shipped separately) 2.1.
Below are diagrams describing interaction between Management Console, Agent and SDK.
Chapter 3. Installation of Acronis Recovery for MS SQL Server From this chapter you will learn how to install Acronis Recovery for MS SQL Server components both locally and remotely. 3.1 Minimum System Requirements Acronis Recovery for MS SQL Server requires the following hardware: • Pentium processor or higher • 512 MB RAM • Mouse (recommended) 3.2 Security Policy 3.2.1 Credentials Acronis Recovery for MS SQL Server obtains access to networked computers using two types of credentials. 1.
Naturally, you are free to use administrator credentials for both purposes. This will work, but make sure it conforms to the security policy set in your network. 3.2.
It is recommended that you install Acronis Recovery for MS SQL Server Management Console first. This will allow you to install Acronis Recovery for MS SQL Server Agent remotely from the Management Console to any networked computer (for information about the remote installation see 3.3.2 “Installing Acronis Recovery for MS SQL Server Agent remotely”). In addition, Acronis Recovery for MS SQL Server supports the Microsoft Installer utility (msiexec.
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 number for the selected product. For information about obtaining a serial number, see section 1.8 “License Policy”. The Next button will not be active until you enter a serial number.
4. Select the computer in the Computer field: enter a computer name manually or click Browse… and select the required computer from the tree. Enter a User name and password into the corresponding fields to access the selected computer. By checking the Save password you can save the password for future connections. 5. The summary page displays all operations, which will be performed. Click Proceed to install Acronis Recovery for MS SQL Server Agent on the remote computer.
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, import existing maintenance plans for Microsoft SQL Server databases. 3.3.3 Extracting Acronis Recovery for MS SQL Server Components For installing Acronis Recovery for MS SQL Server from the command line, you will need to extract the .msi file prior to starting the installation process.
3.3.4 Removing Acronis Components Recovery for MS SQL Server You can remove any Acronis Recovery for MS SQL Server component separately by selecting Control panel -> Add or Remove Programs -> > Remove. Component names are: Acronis Recovery for MS SQL Server and Acronis Recovery for MS SQL Server Agent. Follow instructions on the screen. You may need to reboot your computer to complete the uninstallation.
Chapter 4. Getting started with Acronis Recovery for MS SQL Server This chapter will help you to start working with Acronis Recovery for MS SQL Server, and will guide you through connecting to a remote server, and remote installation of Acronis Recovery for MS SQL Server Agent. 4.
• 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 server in the Computers pane, on which Acronis Recovery for MS SQL Server Agent is not installed, Acronis Recovery for MS SQL Server workspace will contain two operation icons in the Pick a Tool group: • Add Servers – add a database server to the group • Install Acronis Agents – install Acronis Agents on remote computers As soon as you are connected to a datab
• Restore – restore databases from a previously created archive • Backup Location Clean-up - clean database backup locations • Disaster Recovery Plan – generate step-by-step instructions on how to restore your databases in case of any kind of failure The Pick a Tool group contains the following items: • Manage Tasks – manage tasks scheduled on a computer • Logs – open the Log Viewer window • Import Maintenance Plan – set backup options by importing a preexisting backup strategy 4.2.
• Restore - restore databases from a previously created archive • Backup Location Clean-up - clean database backup locations • Disaster Recovery Plan – generate step-by-step instructions on how to restore your databases in case of any kind of failure The Tools menu contains three available operations: • Manage Tasks – manage tasks scheduled on a computer • Logs – open the Log Viewer window • Import Maintenance Plan – set backup options by importing a preexisting backup strategy • Options – open
4.4 Management Acronis Recovery for MS SQL Server Management Console allows installation Acronis Recovery for MS SQL Server components on remote computers. To perform any of these operations you will need administrator rights on the target machine. To connect to the server click Connect to a Remote Server in the Pick a Task pane (see 4.7 “Connecting to a Remote Database Server”).
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 apply any discovery operation later as required. The operation will add newly connected servers to the list in the Computers pane. At the same time, discovery will update the current status of all computers already included in the list.
2. 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 server, you must first connect to it. Once connected, you can manage tasks: set up backup/restore options on remote database servers and schedule backup, restore and backup location clean-up tasks. To establish a remote connection, select a server in the Computers pane and click Connect to a Remote Computer in the right pane.
4.8 Remote Installation of Acronis Recovery for MS SQL Server Agent The remote installation of Acronis Recovery for MS SQL Server Agent is described in detail in 3.3.2.
Chapter 5. Creating Backup Archives This chapter provides general information about backup methods, describes how to backup Microsoft SQL Server databases, and which options can be set using Acronis Recovery for MS SQL Server. 5.1 General Information Backup is crucial to maintaining timely and consistent record of your databases for recovery in case of failure. Acronis Recovery for MS SQL Server offers an easy and flexible process for creating of backup archives. 5.1.
A full backup contains all data at the moment of backup creation – a complete database or instance. You can recover the entire database by restoring the database from a full database backup to a chosen location. Enough of the transaction log is included in the backup to let you recover the database to the time when the backup finished. When the database is recovered, uncommitted transactions are rolled back.
• Transaction Logs backup every hour Database size is large and activity is high, recovery model is Full or BulkLogged: - Full backup once a week - Differential backup once a day - Transaction Logs backup every twenty minutes • Database size is large and activity is high, recovery model is Simple: - Full backup once a week - Differential backup twice a day For advice on creating the best strategy you can also rely upon Acronis Recovery for MS SQL Server Assistant while working with the Create Backup
5.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 databases by separate filegroups when the database size and performance requirements make it not practical to create full database backups. In this case, each time the task is being executed, only one filegroup will be backed up.
to 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). Backup and restore on a tape drive proceed in the same way as with other devices with the following exceptions. 1. You do not have to provide filenames for backups. 2. As soon as the tape is full and the Acronis Recovery for MS SQL Server Management Console is connected to the computer, a dialog window with a request to insert a new cartridge will appear. 3.
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 default). See 5.2.6 for details. If you know which backup method to use for your data, select the Schedule a backup task manually option. In this case you will have to define backup methods and schedule parameters for backup tasks. To immediately run a backup task once select the Create a Backup Now option. In this case you a full backup will be created.
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 Server instances or specific databases to back up. In case an instance is selected, all associated databases will also be selected. Information on the selected item is displayed in the right pane of the window: server name, installed operating system and the number of Microsoft SQL Server instances.
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 Databases to Back Up Select the specific database you want to back up. The right pane will display database name, size, recovery model and status.
• Full backup is created - Rolling Snapshots will be created immediately after creation of the full backup • Differential backup is created - Rolling Snapshots will be created immediately after creation of the differential backup • Transaction log backup is created - Rolling Snapshots will be created immediately after the creation of the transaction log Please be aware that it is not possible to create Rolling Snapshots of the master and model system databases.
After selecting the appropriate object for back up, click Next to continue. 5.2.4 Specifying Credentials In the first step of this wizard you specified the default task execution account (see 5.2.1) so the backup task would run as it was executed by the specified user. If you want to change the credentials for access Microsoft SQL Server, click the Change link while selecting the source to backup.
Acronis Backup Server This software application, when installed on a networked computer, automatically manages backup archives and retention policies for the specified location and ensures optimal usage of storage space. Outdated archives will automatically be deleted as specified in the retention policies set by the administrator. In addition, Acronis Backup Server facilitates the creation and execution of group backup tasks. Acronis Backup Server is shipped with Acronis True Image Echo Enterprise Server.
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 archive to another hard disk will protect your data if the primary disk is damaged. Data saved to a network disk or backup server will survive even if all your local hard disks are down. Acronis Recovery for MS SQL Server allows you to clean storage places to avoid storing out of date archives. See Chapter 8 “Backup Location Clean-up” for details. 5.2.
Acceptable Data Loss At this step specify a period of time when data changes significantly. This will help the Acronis Recovery for MS SQL Server Assistant define the schedule for backup creation – how often to run the backup operation and which backup method to choose.
Click Next to continue. Server Load During a Day Specify workload distribution on the database server throughout the day. As in the previous step, this information will help to define a backup schedule according to your company’s server’s load. In the table there are three rows representing three levels of load (High, Medium and Low), and twenty four columns representing 24 hours of the day. By default the most widely used pattern is specified (selected cells are highlighted in blue).
• On the specified date and time – the selected scheme will be applied at the specified date.
Transaction logs 12 hours 12 hours 12 hours 5.2.7 Setting Backup Scheduling Parameters If you used the Acronis Recovery for MS SQL Server Assistant, Acronis Recovery for MS SQL Server will offer the appropriate schedule for the choices you made. Click Edit to change existing schedule settings. If you decided to define the backup strategy manually, you have to set a schedule for each backup method. See Chapter 10 “Scheduling Tasks” for detailed information.
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 the backup task. Enter a task name in the Task Name field to identify and organize tasks by operation (edit, delete, etc.). You may provide comments for the archives you create. The backup file size and creation date are automatically appended to the description, so you do not need to enter this information. 5.2.
Click Finish to save the created schedule or start the backup creation task immediately. You will be redirected to the Task List automatically, where you can view and edit created tasks. 5.3 Setting Default Backup Options Acronis Recovery for MS SQL Server lets you set the backup options you want to use as default for future tasks. To edit the default backup options, select Tools -> Options from the main program menu. You will also still be able to edit the backup options while creating a backup task.
5.3.1 Pre/Post Commands You can specify commands (or even batch files) that will be automatically executed before and after the backup procedure. For example, you may want to start/stop certain Windows processes, or check your data before starting the backup operation. You can use commands set by default, as well as specify your own commands.
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 processes running on your computer • Normal - the backup process will run with normal priority • High - the backup process will run faster, but it may influence other processes running on your computer Changing the priority of a backup process can make it run faster or slower, but it can also adversely affect the performance of other programs running simultaneously.
5.3.4 Backup Protection Password The preset is No Password. You can password protect your archives so that they will be inaccessible to others. Enter a password in the text field and confirm it. The password is case sensitive. Please keep in mind that in the Restore Data wizard, Acronis Recovery for MS SQL Server will ask for a password after you select a folder within the archive location.
You can specify the behavior of Acronis Recovery for MS SQL Server when creating differential backup or backing up transaction logs of databases with the Simple recovery model: • Create a differential backup if transaction log backup creation is impossible; Create a full backup if a differential backup creation fails – will create a differential backup for a database with the Simple recovery model (a transaction log backup can not be created for such databases).
5.3.7 Additional Settings Validate backup archive once it has been created When enabled, the program will verify the integrity of the archive immediately after it’s created. To validate archive data integrity you must have all of the backups in the series (full, differential and transaction log backups) available in the same location. If any of the successive backups are missing validation will not be possible.
Chapter 6. Disaster Recovery Plan It is extremely important for all organizations and users to have detailed instructions describing the process for recovering data quickly and efficiently in case of disaster – a Disaster Recovery Plan. This plan should contain all of the required information to guide someone through the recovery process.
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 e-mail or to view it in HTML format 4. If in the previous step you selected to receive the Disaster Recovery Plan by e-mail, you will need to specify the e-mail parameters Specify the e-mail account that will be used for sending the Disaster Recovery Plan. Provide the e-mail address to which the plan will be sent and the outgoing SMTP server name.
5. The final stage of the Disaster Recovery Plan Creation wizard is the summary window, which display the list of operations to be performed. Click Finish to obtain the Disaster Recovery Plan immediately. In the latter case an e-mail will be sent to the address you specified or a HTML version of the Disaster Recovery Plan will be opened in your web browser after you click Finish. 6.
4. The final stage of the Disaster Recovery Plan Creation wizard is the summary window which displays the list of operations to be performed. Click Finish to schedule receipt of the Disaster Recovery Plan after each update. 6.3 Summary Thus, in case of disaster, you only need to take the most recent version of the Disaster Recovery Plan and follow the instructions to restore your databases.
Chapter 7. Import a Maintenance Plan With Acronis Recovery for MS SQL Server, you are able to import an existing Microsoft SQL Server Maintenance Plan for a database and convert it into an Acronis Recovery for MS SQL Server task. Later on, you can work with the imported task, as with the regular Acronis backup task i.e.: launch the task, edit the tasks’ options and schedule the task execution parameters. Launch the Import Maintenance Plan wizard by clicking on the icon in the main area. 7.
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 selected maintenance plan will be displayed in the right pane. Select a job from the tree. The associated schedule and objects will be shown on the right. To disable a Microsoft SQL Server, task after importing the maintenance plan, select the Disable SQL task after import checkbox. The Microsoft SQL Server maintenance plan will be deleted after importing.
Chapter 8. Backup Location Clean-up Sooner or later the backups you create will fill up the assigned storage space. Acronis Recovery for MS SQL Server allows you to clean up backup locations by specifying how long to store the archive and/or the maximum number of full backups to store. By default, these options are disabled. Launch the Backup Location Clean-up wizard by clicking on the icon in the main program window. 8.
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 the password to clean up the archive location. Click Next to continue. 8.4 Specifying Cleaning Options Specify the maximum lifetime of an archive and the maximum number of full backups to store. Select the Consider maximum archive’s life check box and type or select a number of days to store archives in the Days box.
Select the Consider maximum full backup check box and type or select the maximum number of full backup archives to store. 8.5 Schedule Cleaning Acronis Recovery for MS SQL Server allows you to schedule backup location clean-up. Specify the schedule that would be the best for your needs (see Chapter 10. “Scheduling Tasks” for detailed information). 8.
Chapter 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.1.1 Restoration Time Selection In the first step of the Restore Data wizard you will select when to run the restoration process. There are two choices: • Now – select this option to execute the restore operation immediately after you finish the wizard • On schedule – select this option to schedule the operation 9.1.
the server and, by default, for connecting to the Microsoft SQL Server (if you do not specify another account for Microsoft SQL Server while selecting the source to backup). Thus, the task will run as if it was started by the specified user. Enter the Username and password then click Next. The domain name must be specified if the user is a member of a domain (DOMAIN\Username). 9.1.
9.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 enter the password to restore your data from archives. Click Next to continue. 9.1.6 Restore Point Selection Specify to which state you want to restore your data. Acronis Recovery for MS SQL Server offers four ways for restoring your data: • to the point of failure – the data will be restored to the state at the point of failure.
from and click OK. As with restoring to the time of the latest backup, Acronis Recovery for MS SQL Server will restore databases from Full, Differential and Transaction Logs backups (if any), but will not apply Active Log. After selecting the appropriate option click Next to continue. 9.1.7 Content Selection Acronis Recovery for MS SQL Server allows restoring instances, single databases and filegroups. Select a database server from the tree in the left pane.
Restoring Databases Choose the database to restore. You can set all the recovery parameters as described above in the Restoring instances section. Additionally, you may customize the location, where database files will be restored, and setting the database state after restoring. Note, you can restore a database from rolling snapshots. Remove the database snapshots using Microsoft SQL Server Management Studio then begin the restore operation.
Click OK to continue. Restoring System Databases System databases can only be restored from a backup created in the Microsoft SQL Server version that the server instance is currently running. The master database must be accessible to run a Microsoft SQL Server instance and to restore databases. If the master database is not accessible, you have to restore the database from a full backup and rebuild it.
If the filegroup restore completes with an error message about the database checksum validation failure (824), the database is not consistent after restoring. You should restore the entire database. After defining all the required parameters click Next to continue. 9.1.8 Restore Options Select the options for the restoration process (Pre/Post commands, restoration process priority etc.). You can Use default options (See 9.2 “Setting Default Restore Options” for more information.
9.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 created task. If you click Cancel, no databases will be restored. Click Finish to save the schedule or start the restore task immediately. 9.2 Setting Default Restore Options To view or edit the default restore options, select Tools -> Options -> Default Restoration Options from the main program menu. You can also edit restore options while creating a restore task.
9.2.1 Pre/Post Commands You can specify commands or batch files to be automatically executed before and after the restore procedure. Click Edit to open the Edit Command window and input the command, its arguments and the working directory, or browse folders to find a batch file. Interactive commands (commands that require user input) are not supported). 9.2.
9.2.3 Additional Settings Backup archive validation Before data is restored from the archive, Acronis Recovery for MS SQL Server can check its integrity. If you suspect that the archive might have been corrupted, select Validate backup archive before restoration. Databases overwriting mode This option allows you to keep useful data changes made since the restored backup was completed. If you are to rename a database or change the default instance, the restored database can overwrite the existing one.
Chapter 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, restore, etc.), parameters of the operation (what to backup, what to restore, etc.) and a schedule (optional). Each time you want to perform an operation with specific parameters, you should create a task. Once the task is created, you can execute it manually at any time or run it on a scheduled basis (if provided).
Daily - the task will be executed daily at the specified time. You can set the following parameters: Parameter Description Recur every (…) The task execution frequency days Start time Time for starting the task.
End date Select this check box to specify the date when this schedule will be disabled Monthly - the task will be executed monthly at the specified time and day. You can set the following parameters: Parameter Description Months Select months for the task execution from the drop-down list. Then choose one of the following parameters: Days - choose this parameter to specify days of the selected months for task execution. Choose the dates from the dropdown list.
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 the operation. Current time is set by default. All the settings you made are displayed in the Result field at the bottom of the window. To save your settings, click OK. To quit task scheduling without saving, click Cancel. Note, Acronis Recovery for MS SQL Server allows you to set multiple schedules for one task.
Chapter 11. Managing Tasks To manage operations, click Manage Tasks in the Pick a Tool group or select the Tools -> Manage tasks menu item. All the scheduled tasks appear in the Scheduled Tasks pane in the Manage Computer Tasks window of the Acronis Recovery for MS SQL Server Management Console. Information about the task name, credentials, the type of backup, its status (completed, scheduled), the task’s schedule and the date and time when it was run last is displayed.
11.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. 11.2 Deleting a Task To delete an existing task, select it in the Tasks window and click Delete Task on the left. Follow the wizard’s instructions on the screen. 11.3 Starting a Task To begin executing an existing task immediately, select it in the Tasks window and click Start Task Now on the left. 11.
Chapter 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 default all notifications are disabled. 12.1 E-mail Notifications Specify the default e-mail account that will be used for notifications regarding the backup operation process. Provide the e-mail address to which notifications will be sent and the outgoing SMTP server name. A Username and a password may also be needed if the SMTP server requires authentication.
You 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 messages issued by Acronis Recovery for MS SQL Server to computers running SNMP (Simple Network Management Protocol) management applications. To specify SNMP settings, check the Send Notification with SNMP parameter to enable SNMP notification.
• Warnings and errors - warnings and error messages will be recorded to the Windows Event Log • Errors only - only error messages will be recorded to the Windows Event Log 84
Chapter 13. Viewing Logs Users can view the Acronis Recovery for MS SQL Server working logs. The logs provide information about scheduled task results, including failure reasons, if any. To view logs, click the Logs item in the Pick a Tool group. The log browsing window contains two panels: the left panel features the log list, and the right panel displays the selected log’s contents.
Appendix A. Acronis Recovery for MS SQL Server: Best Practices This section provides instructions for best practices when using Acronis Recovery for MS SQL Server. A.1 Protect your server from hardware failure, user errors and viruses Scenario The company is running several internet and intranet applications on several Windows 2000 servers using Microsoft SQL Server as the back end (using different instances). Since all transactions are stored in the database, any data loss is not acceptable.
e. 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 failure For every damaged server perform the following actions: 1. Install and configure a new server. Install the necessary Microsoft SQL Server instances on the server. 2. Install Acronis Recovery for MS SQL Server Agent on the server 3. Connect to the server from Acronis Recovery for MS SQL Server Management Console using the appropriate credentials 4.
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 following actions: 1. Recover the server from viruses, reinstall the operating system or replace the server with a new one. 2. Connect to the server from Acronis Recovery for MS SQL Server Management Console using the appropriate credentials 3. Launch the Restore Data wizard and follow the instructions to restore the database: a. Select a backup archive location b.
name, and the old server must remain operational (to provide fast database rollback in case a contingency occurs). Acronis solution 1. Install a new Microsoft SQL Server instance. 2. Set the old database to StandBy mode. 3. Create a backup of the old Microsoft SQL Server instance using a previously created task (running it from the Acronis Recovery for MS SQL Server Management Console) or create a new task (full backup). 4. Restore to a new Microsoft SQL Server instance. 5.
Acronis solution While creating a backup task, the database administrator should specify a Disaster Recovery Plan option, so that it would be sent to the business owner’s email. In case of a disaster, the staff can restore databases according to the instructions contained in the Disaster Recovery Plan. A.7 Restore databases immediately using rolling snapshots (for Microsoft SQL Server 2005 Enterprise only) Scenario Database administrator must be able to restore databases in the shortest amount of time.
Appendix B. Installing Acronis Recovery for MS SQL Server from command line Acronis Recovery for MS SQL Server supports the Microsoft Installer utility (msiexec.exe) with all its commands. Here is the MSI installation command and options: Install Options /i Installs or configures a product.
Reinstall Options /f[p|o|e|d|c|a|u|m|s|v]
w - Logs nonfatal warnings e - Logs all error messages a - Logs startup of actions r - Logs action-specific records u - Logs user requests c - Logs initial user interface parameters m - Logs out-of-memory p - Logs terminal properties v - Logs verbose output. To use v, specify /L*v + - Appends to existing file ! - Flushes each line to the log * - Logs all information except for the v option. This is a wildcard LogFile.
Options 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-} /qn - Displays no user interface /qb - Displays a basic user interface /qr - Displays a reduced user interface with a modal dialog box displayed at the end of the installation /qf - Displays the full user interface with a modal dialog box displayed at the end /qn+ - Displays no user interface, except for a modal dialog box displayed at the end /qb+ - Displays a basi
