Scheduler task permissions

Apr 23, 2010 at 2:04 PM

What permissions needs user for who windows scheduler performs ExpressMaint task?

Coordinator
Apr 23, 2010 at 2:51 PM

Sysadmin to SQL Server instance and Modify (Read/Write) to Backup and Report directories. Also the SQL Service account for the instance being backed up needs Modify (Read/Write) to the backup directory as this the account under which SQL Server will write the backup file.