Home Forums SQL Server 2005 Backups How to I backup the database without Agent XPs enabled? RE: How to I backup the database without Agent XPs enabled?
magasvs
SSCertifiable
Points: 7660
More actions
June 12, 2010 at 9:18 pm
#1179570
You wouldn't be able to use SQL Server Agent to run jobs. SQL Server Agent will not start without this parameter enabled. You can create sqlcmd backup scripts and run Windows tasks instead of SQL Server Agent jobs.