Choose the backup type (full/differential/transaction log), and Add a path as you need. Right-click the database you want to back up in Object Explorer, choose Tasks > Back Up.Ģ.
Launch SSMS and connect to your instance. To use Microsoft SQL Server Management Studio backup database, the easiest way is using the backup GUI.ġ. You can pick the way you like, or use another SQL backup software that can schedule backup multiple databases simply and intuitively. Also, it is not applicable to SQL Express editions either. ◉ SQL Server Agent: It can also automate backups with high flexibility, but you need to fill in the backup script yourself as the core step. However, it is only available for non-Express editions and is relatively cumbersome to operate. ◉ Maintenance Plans: It allows you to backup multiple databases at once, and add a schedule to automate the task. But with effective scripts, you can perform some more advanced operations easily. ◉ T-SQL script: You need to know basic T-SQL commands beforehand, and any small mistake may lead to operation failure. ◉ Backup GUI: This feature is easy to operate without using scripts, but only one database can be backed up at a time, and the operation cannot be automated. So before you start, I’d like to briefly introduce and compare them for your reference: SQL Server Management Studio Backup Database GuideĪs you probably know, there are multiple backup methods in Microsoft SSMS (SQL Server Management Studio), each with its own advantages and disadvantages.
0 kommentar(er)
