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
- How to back up and restore a Microsoft SQL Server database using SSMS
- Use the ALTER DATABASE command to migrate DATABASE in SQL Server
- Create Active Directory accounts from the Exchange database (Part 1)
- SQL Server setup is always available
- What is MS SQL Server?
- Network basics: Part 3 - DNS Server
- How to Set Up a Microsoft SQL Server Database in Docker on Linux
- Microsoft Windows PowerShell and SQL Server 2005 SMO - Part 9
- Learn about the role concept in SQL Server
- Ways to log in database on MS SQL Server
- Compare the performance of MongoDB and SQL Server 2008
- Microsoft Windows PowerShell and SQL Server 2005 SMO - Part 10
- Use and manage Database Mail
- How to install SQL Server database