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).
Server Fault is a question and answer site for system and network administrators. It only takes a minute to sign up.Sign up to join this community
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).