SQL Manage
自动Microsoft SQL管理和维护的业界领先的软件程序
Microsoft SQL完全维护-备份代理-监控&警报
预防故障
执行维护,管理,系统加速,完全及增量备份SQL数据库
产品特征:
对数据库的日常维护工作来说,防范系统重要数据的丢失是至关重要的。数据库的维护工作通常都很复杂,极具技术挑战性而且成本较高。数据传输的路径越繁忙,维护工作就越容易出现问题。
增加系统存活率
该软件通过减少故障和当机来增强系统稳定性,提高工作效率
备份代理
该产品是一个先进的备份系统能够实现完整数据备份,日志备份,备份的网络转送,将近95%的压缩率及简单易行的恢复系统。另外,系统可以修复任何特定时间点,并且备份服务器在灾难中的数据库(structured databases)。
Ongoing Maintenance
自动执行缩减和重建索引,控制处理文件大小并为所有行为设置合理的时间表。系统的有效性和稳定性随着性能的提高而大大增强。
监控 & 警报
硬件或软件一发生故障便立即通知用户或第三方,比如服务器/数据库故障,硬盘毁坏,没有备份及备份失败等。
节省时间
全面的维护套件(Maintenance Suite)
SQL Manage
集中的信息&管理
包含服务器及数据库的全面信息&管理页面。及时查看数据库相关的重要信息――用户连接,数据库文件(和大小),备份历史等。当然也能够执行从备份到整体检查的维护行为。
维护规则附件(Attachment)
点击几下即可连接部分或全部数据库到预定义的维护和最优化类的维护规则上。您可以创建/改变维护规则以适应您的需要,另外,没有box 产品比如SAP Business One...也可以创建和使用预定义的维护 suites
简单的修复页面
只要点击一下,您就可以恢复数据库从登记的备份系列表,外部资源或事件到特定时间点。通过这个简单的修复页面,您只要轻松点击就从现有数据库备份装置中创建新的数据库-必须要有QA的特征并且/或者开发环境•••
SQL查询
具有简单易用的SQL Query页面,高亮SQL Syntax on the fly,能够保存/登陆对CSV文件的查询和查询结果。
Comprehensive Status &警报页面
主要的情况&警报页面预示当前的故障和服务器和数据库的信息警报-根据您自己的通知设置。也可以深层查看服务器的当前硬件使用情况(比如logical drives,CPU使用率,内存使用率等)
Email通知
轻松使用SMTP settings页面来设定e-mail设置和收件人接收关于服务器和数据库故障通知-根据您自己的通知设置。Email通知可以发送到单个或一组收件人。在站点支持(offsite support)的情况下很有用。
服务器通知设置
具有简单全面的通知设置页面。您可以决定哪些情况报警,哪些情况不报警,及哪些报警您希望接收到弹出式的提示框或email通知。服务器通知包括:当创建/删除一个数据库就报警(能够自动连接到一系列预定义的维护规则上),服务失败提示,CPU使用情况和存储器使用情况的通知,硬盘空间不足提示,等等
数据库通知设置
具有简单,全面的通知设置页面。您可以决定哪些报警您希望接收到弹出式的提示框或email通知。数据库通知包括:关于数据/日志大小(也包括日志文件growth),各种关于数据和日志备份的通知(比如数据没有备份或者备份设置太陈旧),通知属性等
压缩& FTP 容量
先进的备份压缩能力可以实现 95%的备份文件压缩,能够将这些压缩的备份文件发送到远程的FTP服务器(确保失败情况下的工作连贯性)
SQL Manage
The leading program for automatic Microsoft SQL management and maintenance
Full Maintenance - Smart Backup Agent - Monitoring & Alerts
Prevents failures.
Performs maintenance, administration, system acceleration, full and differential backups of SQL databases.
Main Features Summary
SQL Manage
In the routine work with databases, it is essential to take precautions against the loss of data which is the heart of the system. Maintenance of databases is complex, technically challenging and usually, costly. The heavier the data traffic is, the more problematic the maintenance can be.
Increasing system survivability
Fewer malfunctions, fewer crushes, increased stability and efficiency.
Backup Agent
An advanced backup system that includes full data backup, log backup, network transference of backups, compression of approximately 95% and a simple and easy restoration system. Additionally, the system offers restoration to any specific point in time and backup of the server’s structured databases in a disaster scenario.
Ongoing Maintenance
Automatically performs shrinking and re-indexing, controls transaction file size and sets a reasonable time schedule for all of the activities. System efficiency and stability increase along with a significant improvement in performance
Monitoring & Alerts
An immediate notice is sent to the user or a 3rd party regarding hardware or software malfunctions and critical problems, such as server / database failures, disk crashes, missing backup and serious failures.
Time Savings
Comprehensive Maintenance Suite
SQL Manage
Centralized Information & Management
A comprehensive information & management page for your server and databases. See all the critical information in real-time regarding your database - User connections, Database files (and size), Backup history and more. And of course - the ability to perform immediate maintenance actions from backups to integrity check.
Attachment Of Maintenance Rules
With few clicks you can attach some or all of your databases to a pre-defined maintenance rules in the categories of maintenance and optimizations. You can create/change your maintenance rules to fit your organization needs,furthermore, a pre-defined maintenance suites have already been created for your use with out of the box products such as SAP Business One...
A Simple Restore Page
Restoring your databases was never easier, with a single click you can restore your database from a list of registered backup sets, an external source or event to a specific point in time. This simple restore page also provides you the ability to instantly create a new database from any existing database backup set with a single click - a must have feature for QA and/or development environments...
SQL Query
A simple and easy to use SQL Query page, highlighting SQL Syntax on the fly, and providing the ability to save/load a query and a query’s results to a CSV file.
Monitoring & Alerts
SQL Manage
Comprehensive Status & Alerts Page
A main status & alerts page indicating the current failures and/or information alerts on your server and databases - according to your own notification settings. Also provides a deeper look on your server’s current hardware status (such as logical drives, CPU usage, memory usage and more)
Email Notifications
An easy to use SMTP settings page to configure your e-mail settings and the recipients to receive notifications regarding the failures on your server and databases - all according to your own notification settings. Email notifications may be sent to a single or a group of recipients. This may be very useful in a case of offsite support.
Server Notification Settings
A very simple and comprehensive notification settings page. You can decide which alerts you want to enable or disable, and for which aler