0

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

TimS
  • 338
  • 2
  • 3
  • 13

1 Answers1

4

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

Sam Cogan
  • 38,736
  • 6
  • 78
  • 114
  • 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