Home
Wifi Tips
Fix Computer
Windows 10
Windows 11
Artificial Intelligence
Space Science
Strange story
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
You've just finished reading the article "How to choose a database in MS SQL Server" edited by the TipsMake team. You can save how-to-choose-a-database-in-ms-sql-server.pdf to your computer here to read later or print it out. We hope this article has provided you with many useful tech tips and tricks. You can search for similar articles on tips and guides. Thank you for reading and for following us regularly.
Samuel Daniel