RelationalDBDesign
SiteMap
Business Rules
Cursors Views
Database Creation
SQL Monitoring
Database Web Apps
Data Manipulation
Access Features
Tables Queries
Monitoring Databases
«Prev
Next»
Configuration Monitoring
Importing/Exporting Data
Insert Data Load Statement
Select into Statement
Bulk Insert Statement
SQL Bulk Copy Program
SSIS
SQL Server Data Tools
SQL Server Agent
Azure Data Factory
SQL Data Integration
Load Export Conclusion
Intro Monitoring SSMS
SQL Server Connections
Monitoring SQL Connections
Monitor Locked Resources
SQL EM Monitor Locks
Overall System Performance
Database Consistency Checker
Monitor Data Cache
Monitor Performance Using DBCC
Trace Flags
Built In Functions
SQL EM Conclusion
Monitoring Databases
Monitor Database Size
Use SSMS monitor DB Size
Monitor Databases using DBCC
Monitor Consistency Individual Tables
Miscellaneous DB Monitoring via Dbcc
Monitor Transaction Log
Maintaining Database Statistics
View Statistical Information
Run sqlmaint.exe
Database Maintenance Plan wizard
SQL-Em Conclusion
SQL-Server Profiler
Sql Server Profiler
Create Trace Filters
SqlServer Profiler Events
Trace Data Columns
Running Traces
Replay Trace File
Index Tuning Wizard
Trace Wizard
Develop Database Maintenance Plan - Exercise
Develop Database Maintenance Plan
Objective:
Given specific conditions, write a SQL statement to effectively monitor a database.
Exercise scoring
This exercise is worth a total of 10 points. To receive full credit, you will need to review the scenario and write your ideas for a database maintenance plan in the text box below. Once you have completed your answer, press the submit button.
Background/overview
As the system administrator for the XYZ Rental Corporation, you need to develop a database maintenance plan for the Sales database.
A full database backup takes four hours and you only have time to do it once a week.
A transaction log backup takes 20 minutes.
You expect that your data distribution will significantly change over a three week period.
All tables have autostats turned on.
You only want to perform backups if the database is not corrupt.
You want to backup files to disk.
You want the reports to be emailed to JoeSmith.
You will also want to view the reports from your Internet.
You will use integrated security.
You need to be able to recover up to the minute.
Instructions
Construct the sqlmaint statements that will generate the desired maintenance?
Submitting your exercise
Enter your answer into the text box below. Click the
Submit
Button below to submit the answer.