![]() The centralized job view helps you view all issues instantly and prioritize your work. 9 P a g eġ1 6.1) Scheduled Operations Panel The Scheduled Operations interface provides you with a powerful single-glance view of all jobs that were created and are running on all servers simultaneously. Select "Create New DRP Rule" at the top of the DRP menu and the wizard will guide you to define the rule simply and efficiently. Important: Before defining a DRP Rule, make sure that the desired database has a backup rule made by the EZManage SQL software (Data backup and Log backup). When setting a DR Rule with different versions of SQL server based on transaction log or differential data, the destination database is kept in a RESTORING mode and is not accessible for user queries until it is brought online (Bringing the destination DB online is only for the sake of reading information). The destination database is kept in a READ_ONLY or STANDBY mode to assure that it is an exact copy of the source database upon restore. When the destination database is restored it is kept in a STANDBY (readonly) mode and is accessible for user queries. When setting a DR Rule, note the following items: The source database backup files should be placed in a location that is accessible from the destination server (It means that the SQL server and agent services are running with a user that has permissions for the backup folder of the source server). 8 P a g eĩ 5.1) Setting up a Disaster Recovery Rule EZManage SQL provides you with an easy way to setup a complete Disaster Recovery solution, using a step-by-step wizard, which allows you to customize your settings to achieve the optimal and most suitable flow for your needs. Apply the suites to the selected servers and databases, and click 'finish'. ![]() Simply select all the desired servers or groups of servers -> right click-> fast implementation. 4 P a g eĨ 5) Fast Implementation Suites and Settings Once finished creating "Maintenance Suites" and "Notification Suites", you can apply them all for multiple servers simultaneously. Mark the (Use integrated security) checkbox to use Windows Authentication. Important: You can connect to the SQL server by Windows Authentication or by the local SQL user authentication. The selected server will be shown on the left side as a "TREE", you now can divide them into groups and attach policies per groups (production, test, DRP, QA ). 3 P a g eĤ 2) Installation Once the Setup Wizard installation is completed, use the "ADD SQL SERVER" in order to broadcast the network and select the servers you want to manage. The EZManage SQL Pro is a Microsoft Platform VeriTest approved solution and also a SAP software solution and technology partner worldwide. Quickly analyze and solve performance issues. EZManage SQL Advanced Backup and Restore. The Benefits for EZManage SQL Users EZManage SQL helps businesses in a number of ways, including: Central Management of Multiple SQL Servers. The With EZManage SQL Pro you enjoy enhanced performance, business continuity, higher availability, a dramatic decline in overhead and fewer failures, all of which will reduce your overall IT costs and guarantee you a speedy ROI and peace of mind. The EZManage SQL is a real "All-in-One" solution, allowing anyone with or without a technical background to effectively manage their SQL Server environment. ![]() EZManage SQL automates traditional DBA tasks such as monitoring, re-indexing, backup & restore, to improve SQL Server performance, minimize downtime and reduce costs. Providing comprehensive maintenance, backups, monitoring and DRP from one centralized console, as well as an advanced performance monitoring and blocking analyze. For further information and support, please contact us at 1 P a g eĢ Table of Contents 1 About EZManage SQL Installation Define Server's and Data Base's Notification Settings Define Data Base's Backups, Maintenance and Optimization Rules Fast Implementation Suites and Settings Disaster Recovery Procedure Setting up a Disaster Recovery Rule In case of an emergency (Disaster Recovery procedure needed) DBA Tools Scheduled Operations panel Management Center panel Multi-Servers Scripting panel Performance and Blocking Monitor Automatic DBA Reports EZManage SQL Pro Global Settings *For detailed information, refer to the "Help File" on the software Help menu 2 P a g eģ 1) About EZManage SQL EZManage SQL is an affordable, easy-to-use database management solution for Microsoft SQL Server databases. All trademarks, trade names, service marks and logos referenced herein belong to their respective companies. EZManage SQL is a powerful agentless centralized management tool for the optimal performance of Microsoft SQL Servers. 1 EZManage SQL Pro Quick guide for installation and implementation The purpose of this document is to guide you through the process of implementing EZManage SQL using SQL Server Databases.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |