SQL Server Daily Backup: How to solve problems for beginners (ii)

Before the automatic backup process has been completed, the next step is to discuss the issue of creating a completed backup that cannot or cannot be performed automatically.

I. When your SQL Server Agent is displayed (disable Agent XP)

Right > My Computer > Management >

Locate the SQL Server Agent service to start it, and after successful startup, right-click the service > properties to change the service to automatic.

Two. The service has been started this setting is also automatic but not automatically executed

Double click or click Edit to enter the following user interface

Tick enabled in this screen and click OK. At this point the process is over and your automated backup is ready to execute. To test if the backup was successful, you can set up a short test backup yourself.

SQL Server Daily Backup: How to solve problems for beginners (ii)