T-SQL code
BACKUP:
USE myDatabaseName
GO
BACKUP DATABASE myDatabaseName
TO DISK = ‘C:\filePath\myDatabaseName.bak’
NAME = ‘The name of the back up.’
RESTORE:
RESTORE databaseName
FROM DISK = ‘C:\filePath\backupFilename’
T-SQL code
BACKUP:
USE myDatabaseName
GO
BACKUP DATABASE myDatabaseName
TO DISK = ‘C:\filePath\myDatabaseName.bak’
NAME = ‘The name of the back up.’
RESTORE:
RESTORE databaseName
FROM DISK = ‘C:\filePath\backupFilename’