I want to discus about SQL server Database auto backup.
Agent Activation Code:
1 2 3 4 5 6 7 8 |
sp_configure 'show advanced options', 1; GO RECONFIGURE; GO sp_configure 'Agent XPs', 1; GO RECONFIGURE GO |
For Active SQL Server Agent service:
Note To do this, click Start, click Run, and then type services.msc.
Then go to:
You locate the SQL Server Agent service and then try to start the service.
Try This: