Two primary vaccines for coronavirus disease 2019 (COVID-19) have been rolled out in the mass vaccination campaign that started simultaneously with the spread of the delta variant. To explore the vaccines’ effect on reducing viral load and disease severity, we conducted a retrospective cohort study in Thai patients aged ≥ 18 years who were confirmed COVID-19 positive by RT-PCR. Compared to unvaccinated patients, Ct values and the number of severe cases among vaccine regimens were analyzed. Ct values of vaccinated patients were not significantly different from unvaccinated patients, despite an increase of Ct values in a booster dose. The adjusted odd ratio for prevention of delta-related severe diseases was 0.47, 95% CI: 0.30–0.76 and 0.06, 95% CI: 0.01–0.45 after receiving one dose and two doses, respectively. No severe illness was found in booster-vaccinated individuals. Focusing on the vaccine types, one dose of ChAdOx1 nCoV-19 gave significant protection, whereas one dose of CoronaVac did not (0.49, 95% CI: 0.30–0.79, p = 0.003 vs. 0.28, 95% CI: 0.04–2.16, p = 0.223). Two-dose vaccination showed robust protective effects in all subpopulations regardless of vaccine type. Vaccinations with two primary vaccines could not reduce viral load in patients with COVID-19, but could prevent severe illness.