Join Adam Wilbert for an in-depth discussion in this video Creating backups in SSMS, part of Database Foundations: Administration.
- Creating backups of your database is easy, and it only has a minimal impact on the daily operations of your database. Though, they can take a while to complete, running a backup will not delay any running processes, or have a measurable impact on operational work loads. In order to create a backup of your database, simply go to the data base, right click on it, point to tasks, and then come down to backup. Once we've determined our recovery model and the backup type that we want to perform, we can come down here to this destination section. We can chose to either backup to a disk or backup to a URL.
I'll chose the disk option, and then you would press the add button over here to add in a new location where you want the backup to appear. Let's go ahead and just accept this default, which is going to go into my sequel server folder, inside of the backup folder, right over here. I'll press cancel and we'll just accept the default location there. On the left-hand side, we also have some additional pages we could take a look at. Under media options we have the ability to override the existing backups, or we could append the backup to the existing backup set. We can also backup to a new media set and erase all existing backup sets here.
We have some options down here, that we can verify the backup when we're finished. So, let's go ahead and turn that one on. We can perform a checksum before writing to the media, or we can continue on if it receives any errors. Let's go ahead and just turn on this first check box right here, and take a look at the backup options page. On this page we get to name the backup, right over here. So, this will be the name of the database inside of the backup. We can also set an expiration for the backup, if we'd like. And we could turn on compression or encryption for our backups. Let's go ahead and just accept all of these defaults, and I'll come back up to the general page, and then I'll come down and press OK button right here.
After the backup is completed we'll get the message that says the backup of the database was completed successfully. I'll go ahead and press OK. And now we've successfully backed up the H+ Active database. Since creating backups is so easy, there's no excuse for not protecting yourself and your data. It's a simple task that should be performed regularly.
Note: This course will also prepare certification candidates for the "Administer a database" domain of the Microsoft Technology Associate (MTA) Exam 98-364, Database Administration Fundamentals.
- Securing the database server
- Understanding Windows authentication vs. SQL Server authentication
- Assigning fixed server roles and fixed database roles
- Granting object-level permissions
- Understanding ownership claims
- Creating backups
- Restoring a database