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
Discover more
MS SQL Server SQL Server select databases mssqlShare by
Samuel Daniel
Update 25 May 2019
You should read it
- 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
- The Quiet Details That Make a Sports Betting Platform Feel Reliable
- Instructions on creating toy set images with ChatGPT AI
- How are AI agents changing the journalism industry?
- How to create a database in MS SQL Server
- Ways to log in database on MS SQL Server
- Manage MS SQL Server with Management Studio