Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
keithv
Starting Member
2 Posts |
 Posted - 2013-06-25 : 22:13:55
|
| 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
200 Posts |
Posted - 2013-11-11 : 12:06:45
|
| hai.what do you mean by DC?-- Thanks and RegardsSrikar Reddy Gondesi,BTECH-IT 2013 Passed Out,Trainee for SQL Server Administration,Miracle Software systems, Inc. |
 |
|
|
keithv
Starting Member
2 Posts |
Posted - 2013-11-11 : 13:42:30
|
| Domain Controller |
|
|
|
jeffw8713
Aged Yak Warrior
819 Posts |
Posted - 2013-11-11 : 14:01:40
|
| 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. |
|
|
|
sgondesi
Posting Yak Master
200 Posts |
Posted - 2013-11-12 : 03:33:01
|
| sorry i dont know about domain controller. I just had knowledge in taking backups and assigning access to members.-- Thanks and RegardsSrikar Reddy Gondesi,BTECH-IT 2013 Passed Out,Trainee for SQL Server Administration,Miracle Software systems, Inc. |
|
|
|
|
|
|
Backups