MS SQL DB Backup
Last updated
Was this helpful?
Last updated
Was this helpful?
In SQL Server, the database can be stored in different files and filegroups. If your database is small (100 MB or less), you do not need to worry too much about files and filegroups. But if you have a large database (in several GBs or TBs), separating the data into different files help you to optimize the performance. You can store the data files in different disks. This will also help to backup and restore the information faster because you do not need to restore the entire database but only the files or the filegroups selected.
In SQL Server, there are different types of backups:
Full Backup: It contains the entire database information.
Differential Backup: It requires a full backup and then it stores the differences between the previous backup and the current database. This backup requires less information because it stores only the differences.
Transaction Log Backup: It stores the information about the Transaction log.
In Object Explorer, connect to the desired instance of the Microsoft SQL Server Database Engine, expand the server instance.
Expand Databases box and select a user database or select a system database.
Right-click the database that need to backup, click on Tasks, and then click Back Up.
In the Back-Up Database dialog box, the database that you selected appears in the drop-down list.
In the Backup type drop–down list, select the backup type – the default is Full.
Under Backup component, select Database.
Review the default location for the backup file, in the Destination section.
To remove a backup destination, click on it and Remove.
To backup to a new device, change the selection using the Add and select destination.
Review the other available settings under the Media Options and Backup Options pages.
Click OK to start the backup. Click OK to close the SQL Server Management Studio dialog box once the backup completed successfully.
