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_filesPeek 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