Checkout the part-3 of my three part article series on SQL Server Database Backups and Recovery Modelshere, in which I discussed how you can use BACKUP DATABASE and BACKUP LOG command to perform database and transaction log backup. In this article, I also shared my custom procedure (sp_BackupDatabase), which I use to perform SQL Server backups.