back up database using T-sql
USE DatabaseName; GO BACKUP DATABASE DatabaseName TO DISK = 'Z:\SQLServerBackups\DatabaseName.Bak' WITH FORMAT, MEDIANAME = 'Z_SQLServerBackups', NAME = 'Full Backup of DatabaseName'; GO