Link to home
Create AccountLog in
Avatar of Balco
Balco

asked on

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
ASKER CERTIFIED SOLUTION
Avatar of QPR
QPR
Flag of New Zealand image

Link to home
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
See answer
Avatar of Balco
Balco

ASKER

Thanks, the power shell works well. Now jut want to put it behind a gui