Manual backing up of SQL 2008 database on remote server

Hi,

We have a payroll datbase called "Payroll" on a database server called "SQL" running Windows server 2008 R2 and SQL Server 2008 R2

The employee doing the payrolls works on a terminal server and needs to do a manual backup of the database "Payroll" part way through the pay run. This employee does not have admin rights to the databse server and has a basic understanding of IT.

I need a way for the employee to run a backup of the Payroll database from the terminal server, whether this is in a batch file or some other way.

Thanks
BalcoAsked:
Who is Participating?
 
QPRConnect With a Mentor Commented:
They could run a local powershell script
http://andrewmorgan.ie/2011/12/14/backup-and-restore-sql-databases-using-powershell/

You could add the user to the SQL role db_backupoperator so they could do this task without having sysadmin rights
0
 
BalcoAuthor Commented:
Thanks, the power shell works well. Now jut want to put it behind a gui
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.