Comprehensive data protection for all workloads
Post Reply
VladV
Expert
Posts: 223
Liked: 25 times
Joined: Apr 30, 2013 7:38 am
Full Name: Vlad Valeriu Velciu
Contact:

Outsource DB recovery tasks to DBA

Post by VladV » Mar 10, 2015 11:09 am

Sorry if this has been discussed or if the information is in plain site but I am having trouble finding it.

I am looking for a way to offload the recovery tasks for our databases to our DBA. Is there a remote console or a controlled way in doing so without granting remote desktop capabilities to the backup server?

Thanks.

dellock6
Veeam Software
Posts: 5893
Liked: 1715 times
Joined: Jul 26, 2009 3:39 pm
Full Name: Luca Dell'Oca
Location: Varese, Italy
Contact:

Re: Outsource DB recovery tasks to DBA

Post by dellock6 » Mar 10, 2015 11:13 am

Hi Vlad,
you can use Enterprise Manager and create a new user there, with only Restore Operator rights, and assign him the rights to only restore SQL items.
The DBA will be able to log into the web interface, search for available DBs (without even knowing the name of VMs running them...) and start restores from here. I've presented on this topic at VeeamON 2014, you can see the video here:

http://go.veeam.com/veeamon-free-sessions

Look for session VT-09.

Luca.
Luca Dell'Oca
Principal EMEA Cloud Architect @ Veeam Software

@dellock6
https://www.virtualtothecore.com/
vExpert 2011 -> 2020
Veeam VMCE #1

VladV
Expert
Posts: 223
Liked: 25 times
Joined: Apr 30, 2013 7:38 am
Full Name: Vlad Valeriu Velciu
Contact:

Re: Outsource DB recovery tasks to DBA

Post by VladV » Mar 10, 2015 3:14 pm

Hi Luca, thanks for the input and great VeeamOn session. Was hoping that there was another solution besides Enterprise Manager, something like SQL explorer remote.

One thing though regarding permissions. Is there any way in restricting a Domain Admin to be only able to restore? It seems that even if I add the user as a restore able one, it gets overridden by the group.

Regards

dellock6
Veeam Software
Posts: 5893
Liked: 1715 times
Joined: Jul 26, 2009 3:39 pm
Full Name: Luca Dell'Oca
Location: Varese, Italy
Contact:

Re: Outsource DB recovery tasks to DBA

Post by dellock6 » Mar 10, 2015 4:46 pm

Yes group has priority over single users, but is a BDA also a domain admin????
Luca Dell'Oca
Principal EMEA Cloud Architect @ Veeam Software

@dellock6
https://www.virtualtothecore.com/
vExpert 2011 -> 2020
Veeam VMCE #1

VladV
Expert
Posts: 223
Liked: 25 times
Joined: Apr 30, 2013 7:38 am
Full Name: Vlad Valeriu Velciu
Contact:

Re: Outsource DB recovery tasks to DBA

Post by VladV » Mar 10, 2015 4:50 pm

In our company, yes. It is a small infrastructure that needs to be managed. He is more a domain admin than DBA but it is enough as the DB is maintained by the app provider.

dellock6
Veeam Software
Posts: 5893
Liked: 1715 times
Joined: Jul 26, 2009 3:39 pm
Full Name: Luca Dell'Oca
Location: Varese, Italy
Contact:

Re: Outsource DB recovery tasks to DBA

Post by dellock6 » Mar 10, 2015 4:56 pm

Another option is to have the enterprise manager not joined to the domain and use local admins, but then any login to domain resources will fail, like for example the SQL server joined in a domain.
I understand your situation, but domain admins are not designed to be limited accounts...
Luca Dell'Oca
Principal EMEA Cloud Architect @ Veeam Software

@dellock6
https://www.virtualtothecore.com/
vExpert 2011 -> 2020
Veeam VMCE #1

VladV
Expert
Posts: 223
Liked: 25 times
Joined: Apr 30, 2013 7:38 am
Full Name: Vlad Valeriu Velciu
Contact:

Re: Outsource DB recovery tasks to DBA

Post by VladV » Mar 10, 2015 5:05 pm

OK, thanks.

Post Reply

Who is online

Users browsing this forum: Google [Bot], RGijsen and 68 guests