SQL Server administration and maintenance

For the smooth and reliable operation of the Verba system, it is imperative to have a properly sized and well managed database system.

Verba system administrators have the following common tasks with the SQL Server:

• Configuring backup and database maintenance plans

• Restoring the database after a (hardware) failure

• Helping support team with direct database access

There are two types of tools, which can be used to maintain and administer SQL Server:

• Command line tools

• Graphical management tools (recommended)

This chapter contains the following information: