I have an employee working as a data entry operator on Windows 7 PC. I want to create backup of the data and for that I have to stop SQL server while in administrator mode, to move data files to dropbox.
my employee cannot able to stop SQL Server due to limited privileges and hence cannot create backup on its own.
I want to give access to him for only starting and stopping sql server so that he routinely creates backup of the data.
Please suggest ways, I tried Subinacl and that doesn't work on Windows 7.