Abstract
In this chapter, you’ll find recipes covering several methods of backing up a database using T-SQL. This chapter is in no way meant to be a comprehensive source for database backups but rather provides greater insight into the problems or limitations you may encounter. This chapter will outline the different types of backup methods using T-SQL as well as how to query the msdb database to find information about backup information.
This is a preview of subscription content, log in via an institution to check access.
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
© 2012 Jason Brimhall
About this chapter
Cite this chapter
Brimhall, J., Dye, D., Gennick, J., Roberts, A., Sheffield, W. (2012). Backup. In: SQL Server 2012 T-SQL Recipes. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4302-4201-7_26
Download citation
DOI: https://doi.org/10.1007/978-1-4302-4201-7_26
Published:
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4302-4200-0
Online ISBN: 978-1-4302-4201-7
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books