The BACKUP DATABASE is the command used to create a full database backup. How to create full database backup using T-SQL This allows for the simplest form of database restoration, since all of the contents are contained in one single backup.Ī full backup must be done at least once before any of the other types of backups can be run-this is the foundation for every other kind of backup. Having a full backup, you will be able to easily restore a database in exactly the same form as it was at the time of the backup.Ī full backup creates a complete backup of the database as well as part of the transaction log, so the database can be recovered. This is a complete copy, which stores all the objects of the database: Tables, procedures, functions, views, indexes etc. It is the foundation of any kind of backup. There are other backup types available as well:Ī full backup, as the name implies, backs up everything. This understanding would, in turn, help us decide our backup-and-restore strategy.įollowing are the most common types of backups available in SQL Server: In this article, however, we are going to focus on the types of backups that are available to us, and understand how to pick what we need, and what aspects we base that decision on. SQL Server backups, in itself, is a vast subject so vast, there are multiple books written about them.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |