Currently if a non-sysadmin user who is in single user mode goes to try to backup the database, they are unable to do so. You are now requiring bookkeepers to give up control of the databases which in some cases can be the only recourse to them recovering payment from customers. This is not acceptable.
I have over 50 databases and we are sysadmins on a large number of these databases so that customers do not do something they should not. I am NOT about to give my customers access to my email remote data access as they could be opening up pandora's box. For now, I am having to backup certain databases on a weekly if not daily basis.
Backups need to be able to be done by ANY user as long as they are in single user mode. This decision has created an increased risk to companies utilizing Sage requiring them to have the sysadmin access but it also opens the company up to risk that the owners who may not completely understand what they are doing could cause major harm to their databases.
The Restore from backup should be a sysadmin only function to reduce the possibility of the database being overridden.
Christine Bricknell
