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:

• Database backup and restore
• Database maintenance
• Database table partitioning
• Database purging
• SQL Server GUI tools
• SQL Server command line tools