Enjoyed this post? Check out our guide on "Top 10 DMVs Every DBA Should Know" next.
-- Perform the backup BACKUP DATABASE ProductionDB TO ProductionDB_Backup WITH FORMAT, MEDIANAME = 'SQLServerBackups', NAME = 'Full Backup of ProductionDB'; GO ms sql server management studio