MS SQL Server Select Database

«« Previous
Next »»

Select your database based on your action before going ahead with any of the following methods.

Method 1 – Using SQL Server Management Studio


Example

To run a query to select backup history on database called ‘msdb’, select the msdb database as shown in the following snapshot.

MS SQL Server Select Database

Method 2 – Using T-SQL Script


Use <your database name>

Example

To run your query to select backup history on database called ‘msdb’, select the msdb database by executing the following query.

Exec use msdb

The query will open msdb database. You can execute the following query to select backup history.

Select * from backupset

«« Previous
Next »»

0 comments:

Post a Comment