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.
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
Was this article helpful?
Your feedback helps us improve.
Reader Comments 0
Sign in with email or Google to join the discussion.