Online Documentation for SQL Manager for SQL server
Services
SQL Manager for SQL Server provides a number of powerful tools for working with your database server.
Tools for managing server-level security principals
A convenient tool to browse the server logs
A convenient tool to get information about connections and the locks that they hold
A tool for managing SQL Server workload and resources
SQL Manager for SQL Server provides graphical user interface for most SQL Server objects and native services.
The following tools for SQL Server objects and services management are available in SQL Manager for SQL Server:
Provides tools for working with backup devices: Backup devices manager, Backup Device properties.
Provides tools for working with database snapshots: Snapshots manager, Snapshot properties.
Provides tools for working with linked servers: Linked servers manager, Linked Server Editor.
Provides tools for working with DTS packages: DTS Packages manager, DTS Package properties.
Provides tools for working with jobs: Jobs manager, Job Editor.
Provides a convenient tool to browse the list of recent jobs: Job History.
Provides tools for working with alerts: Alerts manager, Alert Editor.
Provides tools for working with operators: Operators manager, Operator Editor.
Provides tools for working with schedules: Shared schedules manager, Schedule Editor.
Provides tools for working with proxies: Proxies manager, Proxy Editor.
Provides a powerful tool for working with credentials: Credential Editor.
Provides a powerful tool for working with endpoints: Endpoint Editor.
Provides a powerful tool for working with DDL triggers: DDL Trigger Editor.
Provides a convenient tool for target servers management: Target Servers manager
SQL Manager for SQL Server provides graphical interface for a number of database maintenance operations. The following specific database tools are available in SQL Manager:
Allows you to attach an existing database to the instance of Microsoft® SQL Server™.
Allows you to detach a database from the instance of Microsoft® SQL Server™.
Creates backup copies of entire databases, transaction logs and files/filegroups.
Restores entire databases, transaction logs and files/filegroups from previously created backups.
Reduces data and transaction log files.
Allows you to reorganize, rebuild, and disable indexes.
Updates database statistics.
Checks the allocation, structural, and logical integrity of all database objects.
Allows you to grant/revoke privileges on database objects.
Facilitates using SQL Manager wizards.
|
See also: |
