You can use the SQL Server Management Studio to schedule a backup log. Step 1: Click 'Maintenance Plans' and create a new plan. Step 2: Select Back Up Database Task. Step 3: Click on the newly added plan and configure the backup settings.