RESTORE and CREATE a Backup

You will need to be using master.

USE master;

Backup

One-off backup

BACKUP DATABASE DbName
TO DISK = N'D:\SqlBackups\DbName_FULL_$(ESCAPE_SQUOTE(DATE))_$(ESCAPE_SQUOTE(TIME)).bak'
WITH COPY_ONLY, CHECKSUM, STATS = 10;

Restore

View all Database Files

SELECT * FROM sys.database_files

Peek inside Backup

-- Shows what backups are inside the file
RESTORE HEADERONLY FROM DISK = N'C:\<location>\DbName.bak'

-- Shows the file names in the backup
RESTORE FILEISONLY FROM DISK = N'C:\<location>\DbName.bak'

Restore a Full Backup

-- Restore the db and put files in the correct location
RESTORE DATABASE DbName
FROM DISK = 'C:\<location>\DbName.bak'
WITH MOVE 'DbName'     TO 'C:\<dataLocation>\DbName.mdf',     -- data file
		 MOVE 'DbName_log' TO 'C:\<dataLocation>\DbName_log.ldf', -- log file
		 RECOVERY; -- Bring the db online... NORECOVERY keeps it offline