• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 201
  • Last Modified:

Manual backing up of SQL 2008 database on remote server


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.

1 Solution
They could run a local powershell script

You could add the user to the SQL role db_backupoperator so they could do this task without having sysadmin rights
BalcoAuthor Commented:
Thanks, the power shell works well. Now jut want to put it behind a gui
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.

Join & Write a Comment

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now