SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 High Availability (2008)
 Backups
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

keithv
Starting Member

2 Posts

Posted - 06/25/2013 :  22:13:55  Show Profile  Reply with Quote
Not sure if this is the right spot for this post so apologies if it's in the wrong spot. Please move it as necessary.

We have SQLExpress running on our DC. It handles data for our admin assistant. How can I set her up to do full database backups without giving her remote access to the DC? Lots of detail is appreciated as I've not dealt with SQL before.

sgondesi
Posting Yak Master

India
194 Posts

Posted - 11/11/2013 :  12:06:45  Show Profile  Reply with Quote
hai.

what do you mean by DC?

--
Thanks and Regards
Srikar Reddy Gondesi,
BTECH-IT 2013 Passed Out,
Trainee for SQL Server Administration,
Miracle Software systems, Inc.
Go to Top of Page

keithv
Starting Member

2 Posts

Posted - 11/11/2013 :  13:42:30  Show Profile  Reply with Quote
Domain Controller
Go to Top of Page

jeffw8713
Aged Yak Warrior

USA
798 Posts

Posted - 11/11/2013 :  14:01:40  Show Profile  Reply with Quote
I would create a stored procedure that performs the backup command, with the procedure setup to create a dated file. I would also add to the procedure a step following the backup to remove old backup files.

Then, grant execute access to that stored procedure and the user can then execute the procedure as needed.
Go to Top of Page

sgondesi
Posting Yak Master

India
194 Posts

Posted - 11/12/2013 :  03:33:01  Show Profile  Reply with Quote
sorry i dont know about domain controller.
I just had knowledge in taking backups and assigning access to members.

--
Thanks and Regards
Srikar Reddy Gondesi,
BTECH-IT 2013 Passed Out,
Trainee for SQL Server Administration,
Miracle Software systems, Inc.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000