How to choose a database in MS SQL Server

You can select the database to manipulate in one of the ways below.

You can select the database in MS SQL Server to operate in one of the ways below.

Method 1: use SQL Server Mangement Studio

Run the query to select the backup history on the database named msdb, select msdb as shown in the image below.

How to choose a database in MS SQL Server Picture 1How to choose a database in MS SQL Server Picture 1
Choose from the database backup section

Method 2: Use T-SQL Script

Use 

Run the query to select the backup history on the database named msdb, select msdb by executing the following query

Exec use msdb

This query will open the msdb database. You can run the following query to select the backup history.

Select * from backupset

Previous article: How to create a database in MS SQL Server

Next lesson: How to delete the database in MS SQL Server

4.2 ★ | 5 Vote