Search code examples
sql-serverbackup

How to schedule a SQL Server 2016 database backup

How to schedule a SQL Server 2016 database backup? The backup will be run every week.

TIA

Solution

  • If you are using SQL Server Express, you can't use SQL Agent, so you must do it using a script (.bat or another) and schedule it with Windows Schedule task (or another program).

    If you have another version, you can create a Maintenance plan for a full backup and then with SQL Agent create a Job to run it.

    See this answer for more details