[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 199
  • Last Modified:

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
0
Balco
Asked:
Balco
1 Solution
 
QPRCommented:
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

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

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