How to schedule database backup in SQL Server Express edition?..

• alexsunny123

  SSC-Addicted

  Points: 427

  More actions

  November 14, 2020 at 12:42 pm

  #3807829

  Hello,

   

  How to take/schedule database backup in SQL Server Express edition (latest version)

  Required log backup every day with 1 hour interval (except Sunday) and full backup on Sunday.

  Pls advise the script for take above backup in SQL Server Express edition.

  As per my understanding SQL Server Agent is not available in Express edition.

   

  thanks

  alexsunny

• Cebisa

  SSC Enthusiast

  Points: 151

  More actions

  November 14, 2020 at 1:19 pm

  #3807830

  Ola Hallegren published database backup scripts

  Create util database, have script as stored procedure

  Use Windows scheduled task to run this

• November 21, 2020 at 11:05 am

  This was removed by the editor as SPAM