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: