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.
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.