Microsoft SQL Server/Database manipulation

Creation

To create a database, its files have to be defined:

• Master Database File (.mdf)
• Log Database File (.ldf)

CREATEDATABASE[MyDB]ONPRIMARY(NAME=N'MyDB',FILENAME=N'D:\DATASQL\MSSQL10.MSSQLSERVER\MSSQL\DATA\MyDB.mdf',MAXSIZE=UNLIMITED,FILEGROWTH=1024KB)LOGON(NAME=N'MyDB_log',FILENAME=N'D:\DATASQL\MSSQL10.MSSQLSERVER\MSSQL\DATA\MyDB_log.ldf',MAXSIZE=2048GB,FILEGROWTH=10%)GO

Reading

Then to select it, it's either possible to set it at the beginning of the script:

USEMyDB;SELECT*FROMMyTable;

or to call all the objects with their full path. Eg:

SELECT*FROM[MyDB].[dbo].[MyTable];

Restoration

If the database to restore doesn't exist on the destination server, it's necessary to create it empty first. In SSMS, with a right click on Databases, New database.

The process is a right click on the database to restore, and Restore the database, select the .bak.

Otherwise in SQL it gives:

RESTOREDATABASEMyDBFROMDISK='C:\Program Files\Microsoft SQL Server\MSSQL12.SQLEXPRESS\MSSQL\Backup\2016-02-16-MyDB.bak'WITHREPLACE