How to useT-SQL Script or Restore Database in SQL

The following can be the basic syntax for creating a database in MS SQL Server.

Restoring a database using a T-SQL script can be done in SQL Server Management Studio (SSMS) by executing a series of SQL commands. Here are the steps to restore a database using T-SQL script:

1. Open a new query window in SSMS by clicking on “New Query” in the toolbar.
2. Type the following command to restore a database from a backup file.
3. Replace “DatabaseName” with the name of the database you want to restore, and “C:\Path\To\BackupFile.bak” with the path to the backup file on your server.

Syntax:

Create database <yourdatabasename>

Prerequisite – Introduction of MS SQL Server

Databases are a collection of objects like tables, views, stored procedures, functions, etc. In MS SQL Server, two sorts of databases are available.

1. System databases
2. User Databases

System Databases

System databases are created automatically once we install the MS SQL Server. Below is a list of system databases –

1. Master
2. Model
3. MSDB
4. Tempdb
5. Resource (Introduced in the 2005 version)
6. Distribution (It’s for the Replication feature only)

User Databases

User databases are created by users (DBAs, and testers who have access to create databases).To create a database, the below methods could be used –

1. SQL Server Management Studio.
2. Transact-SQL.