up vote 0 down vote favorite
share [g+] share [fb]

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

link|improve this question
100% accept rate
feedback

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

link|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
feedback

Your Answer

 
or
required, but never shown
discard

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