answersLogoWhite

0


Best Answer

Back Up

Database

Task Performs different types of SQL Server

database backups.

Check

Database

Integrity

Task Checks the allocation and structural

integrity of database objects and indexes.

Execute SQL

Server Agent

Job Task Runs SQL Server Agent jobs.

Execute T-

SQL

Statement

Task Runs Transact-SQL statements

and more

User Avatar

Wiki User

12y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: What tasks are included in database maintenance?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

A technician is designing a hardware preventive maintenance plan for a company Which strategy should be included in the plan?

Schedule and document routine maintenance tasks.


What is Database maintenance?

Database maintenance is an activity which is designed to keep a database running smoothly.


What are the purpose of DBMS?

DBMS or database management systems are used to standardize the updating, maintenance and extraction of data. They make certain tasks routine which allows for simpler programs to access the data.


Which is the utility called located in the system tools folder allows you to select when and how often maintenance tasks are performed?

Task Scheduler allows you to choose when and how often maintenance tasks are performed.


Explain how some maintenance tasks can be automated?

It depends upon what type of maintenance tasks. In the world of computers, many tasks can be set up to run on a regular basis without intervention.


What is the function of an aircraft maintenance technician?

The job of the AMT is to perform maintenance tasks on the aircraft. Such tasks include inspections, component replacements, or troubleshooting.


How do you know what your role is in a maintenance schedule?

You know that your maintenance role is when your tasks are mainly administrative.


What would be the purpose behind remote DBA?

A database administrator (DBA) is a person that does the installation, upgrade, administration, and maintenance of databases in an organization. A remote DBA would simply perform these tasks from outside the confines of the organization.


What is Difference between real time database and simple database?

the difference is about the transactions. the normal database is not included deadline, but the real time database is.


What is the utility located in the System Tools folder that allows you to choose when and how often maintenance tasks is performed called?

Task Scheduler allows you to choose when and how often maintenance tasks are performed.


What is included in the database Fedbizopps?

There are a lot of things that are included in the database Fedbizopps. They have a list of all the phone numbers of major businesses located in the United States.


What are the primary duties of a remote database administrator?

A database administrator's responsibilities can include the following tasks: future storage requirements for the database system. Creating primary database and the database tools and applications are executed on remote computers.