Home / server / Questions / 247554
Accepted
TimS
Asked: 2011-03-16 03:11:55 +0800 CST

Does SQL Agent need to be running in order to take manual SQL backups?

  • 772

If we have a situation where SQL Agent fails to start, will we still be able to take a full manual SQL backup?

I don't mean scheduled backups and maintenance plans, just plain Right Click > Tasks > Backup (in SQL Management Studio).

sql-server disaster-recovery database-backup

1 Answers

  1. Best Answer

    To run a backup from Right Click > Tasks > Backup in SSMS you do not require the SQL agent to be running (this backup method works in SQL Express which does not allow the Agent to run).

    • 4