Tell me more ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.
up vote 0 down vote favorite

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

1 Answer

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
1  
@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

 
discard

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.