Solved

Manual backing up of SQL 2008 database on remote server

Posted on 2013-05-13
2
189 Views
Last Modified: 2013-05-17
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
Comment
Question by:Balco
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 29

Accepted Solution

by:
QPR earned 500 total points
ID: 39163845
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
 

Author Comment

by:Balco
ID: 39176516
Thanks, the power shell works well. Now jut want to put it behind a gui
0

Featured Post

Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
This video Micro Tutorial shows how to password-protect PDF files with free software. Many software products can do this, such as Adobe Acrobat (but not Adobe Reader), Nuance PaperPort, and Nuance Power PDF, but they are not free products. This vide…
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…

724 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question