May 7, 2018 at 5:00 am
Hi
Can someone please let me know how does one take backup or restore of Microsoft R services on SQL 2016
Thanks
Atulyan
May 7, 2018 at 9:40 am
atulyan.aries - Monday, May 7, 2018 5:00 AMHiCan someone please let me know how does one take backup or restore of Microsoft R services on SQL 2016
Thanks
Atulyan
Can you be more specific?
May 7, 2018 at 5:13 pm
R service is a service to run R code in the database. There aren't specific R objects to backup.
May 9, 2018 at 6:10 am
Thank you everyone for your help. Here is what I'm looking for :
1. How do I take backup
2. How to patch frequently as per the patch releases (monthly/ yearly)
3. How to recover or restore if any issues occurs
May 9, 2018 at 9:58 am
As others have said before R Services is a service and a series of set up steps on a server and SQL instance. Are you wondering how you can backup the entire setup? If so you'd need to look at taking an image of the entire server using some sort of infrastructure backup software (we use Veeam, there are others). Failover clustering is not an option or R services due to the security mechanisms used by R Services.
May 11, 2018 at 11:17 am
A native SQL SErver backup includes backup of any code or objects that run R code. Patches for SQL Server include the patches for R services.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply