Abstract
At this point, you have now created a backup and performed a restore of the example database. You have also covered the different methods to back up and restore the database. However, there is no real plan for regular maintenance and detection and reporting of problems in the database strategy. Any jobs for backup of the database or transaction log that I have demonstrated so far are held as single units of work called steps. Not only that, but also there is nothing in place that will look after the data and indexes held within the database to ensure that they are still functioning correctly and that the data are still stored in the optimal fashion. Without a process that runs regularly, you would need to perform all of this by hand regularly and check the results each time. What a waste of time, and boring to boot!
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Author information
Authors and Affiliations
Rights and permissions
Copyright information
© 2015 Robin Dewson
About this chapter
Cite this chapter
Dewson, R. (2015). Database Maintenance. In: Beginning SQL Server for Developers. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-0280-7_9
Download citation
DOI: https://doi.org/10.1007/978-1-4842-0280-7_9
Published:
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4842-0281-4
Online ISBN: 978-1-4842-0280-7
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books