Point out the correct statement related to database maintenance :
A. Performing SQL Server Maintenance with Maintenance Window
B. Performing SQL Server Maintenance with No Maintenance Window
C. Performing SQL Server Maintenance with Scrip Maintenance Window
D. None of the mentioned
Answer:A
Point out the correct statement related to database maintenance :
A. Performing SQL Server Maintenance with Maintenance Window B. Performing SQL Server Maintenance with No Maintenance Window C. Performing SQL Server Maintenance with Scrip Maintenance Window D. None of the mentioned
Explanation:When the production SQL Server is running on a 24X7 basis or the maintenance window is not long enough to support the maintenance.