Backup SQL Memory-Optimized Table

Availability for the Always-On Enterprise

Backup SQL Memory-Optimized Table

Veeam Logoby mamosorre84 » Wed Sep 13, 2017 1:28 pm

Hello everyone,

I have a question: does Veeam support SQL Memory-Optimized Table (In-Memory OLTP) ?

https://msdn.microsoft.com/library/dn133186(v=sql.120).aspx

I found in some old Veeam topics only this reference about VSS timeout, nothing else.

https://www.veeam.com/kb1377

Thank you
mamosorre84
Enthusiast
 
Posts: 40
Liked: 5 times
Joined: Mon Oct 24, 2016 3:56 pm
Location: Ancona - Italy
Full Name: Marco Sorrentino

Re: Backup SQL Memory-Optimized Table

Veeam Logoby foggy » Wed Sep 13, 2017 1:58 pm

Hi Marco, memory-optimized tables are backed up like any other ones, including logs backup and various restore possibilities. Thanks.
foggy
Veeam Software
 
Posts: 15094
Liked: 1111 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson

Re: Backup SQL Memory-Optimized Table

Veeam Logoby mamosorre84 » Wed Sep 13, 2017 2:25 pm

Thank you for your reply.

Do you support also memory optimized filegroup and relative filestream Data on disk ?
mamosorre84
Enthusiast
 
Posts: 40
Liked: 5 times
Joined: Mon Oct 24, 2016 3:56 pm
Location: Ancona - Italy
Full Name: Marco Sorrentino

Re: Backup SQL Memory-Optimized Table

Veeam Logoby foggy » Thu Sep 14, 2017 2:49 pm

Veeam B&R operates with databases/tables and does not restore filegroups themselves. So corresponding filegroup should already exist on target upon table restore.
foggy
Veeam Software
 
Posts: 15094
Liked: 1111 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson


Return to Veeam Backup & Replication



Who is online

Users browsing this forum: khang1231 and 49 guests