Microsoft SQL Server Management Studio

As an administrator, you will probably spend the majority of your time interacting with Microsoft SQL Server through the Microsoft SQL Server Management Studio, in which you can manage the Microsoft SQL Server areas of AVEVA Historian Server.

Using Microsoft SQL Server Management Studio, you can perform the following database functions (including the Runtime database):

• Register servers

• Manage backups

• Manage databases

• Manage devices

• Manage logins and permissions

• Manage replication

• Manage objects, such as tables, views, stored procedures, triggers, indexes, rules, defaults, and user-defined data types

• Schedule tasks

• Drag-and-drop objects from one server to another or within a server

• Generate SQL scripts

To start Microsoft SQL Server Management Studio, on the Start menu of the Windows Taskbar, point to the Microsoft SQL Server program group, and then click SQL Server Management Studio.