What is the first priority of a database administrator in determining the proper functioning of a SQL Server instance?
What will be an ideal response?
The first priority for a database administrator is to ensure that all services are running normally. Monitoring the status of services or stopping and starting a service should be done using the SQL Server Configuration Manager. The most critical services are the Database Engine Services, SQL Server Agent, and SQL Server Integration Services.
You might also like to view...
On a CD, the area that separates the pits is a mountain
Indicate whether the statement is true or false
If you attempt to open a file with the Open file mode, what happens if the file does not exist?
A. The file is created and then opened for use. B. The program returns a prompt to the user asking if the file should be created. C. The program will return a null object, and all data written to the file will be discarded. D. The program throws a System.IO.FileNotFoundException error.