5 Ways to Make SQL Server Backups
Last time we discussed 5 backup types for SQL Server. Now I want to introduce you to five ways to make backups in SQL Server. I can’t possibly explore all the options available with each of these six methods. There is a lot to cover for even a “simple” topic like backups.
Method 1: Using the SSMS GUI to Make a SQL Server Back up
For those readers who like the SSMS GUI, there is good news. SQL Server Management Studio offers a fairly straightforward method for backing up a database. Once you connect to the SQL Server instance containing the database you want to back up, left click on the “+” sign next to the Databases folder. Then right click the name of the database you want to backup, choose Tasks, then choose the Backup option in the fly out menu.