Выполните "DBCC OPENTRAN", и он скажет Вам spid, который имеет самую долгую рабочую транзакцию в базе данных. Обязательно выполните его в контексте рассматриваемой базы данных.
I don't know of any server level options per se, but a few options might works.
Modify the model DB so that it has the backup operators role assigned to a group with your user in it.
Run a t-sql script nightly that loops through each db and assigns the role.
Also, just to re-affirm, see here... https://dba.stackexchange.com/questions/28472/is-there-a-backup-operator-role-in-microsoft-sql-server-2008