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 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
You should read it
- How to create a database in MS SQL Server
- SELECT command in SQL Server
- SELECT TOP command in SQL Server
- SELECT INTO command in SQL Server
- EXCEPT operator in SQL Server
- How to start and stop services in MS SQL Server
- How to delete the database in MS SQL Server
- Conditions NOT in SQL Server
- Test SQL Server with Windows PowerShell - Part 6
- Query SUBQUERY child in SQL Server
- WHERE clause in SQL Server
- UNION ALL operator in SQL Server