Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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).

share|improve this question
up vote 4 down vote accepted

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).

share|improve this answer
Perfect, thanks for the quick response – TimS Mar 15 '11 at 11:20
@TimS You may also use the sqlcmd utility to run a SQL script designed to back up DBs, right from a Windows Scheduled Task -- Not as elegant as SQL Agent, but quite functional on SQL Express installs. – jscott Mar 15 '11 at 11:27
Thanks @jscott for the T-SQL option, good plan – TimS Mar 15 '11 at 11:43

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.