Advanced VM SQL Server Backup & Recovery - Webinar

the broadcast is now starting all attendees are in listen-only mode hello and welcome to this featured webinar advanced vm sequel server backup my name is Rick van over and I'm a product strategy specialist here at beam software and I'm happy to talk to you about this topic today this is a very important topic to many virtual machine administrators as well as DBAs and this one actually speaks well to some experiences I've had in my professional experience so I'm pretty sure everyone will benefit here today as we get started I want to go through a few housekeeping items first of all if you have any questions find the question panel on the GoToWebinar screen I'll do my best to answer the question during the webinar but I might have to hold it until the end secondly this webinar is being recorded so you're going to get a copy of this webinar for replay and a link at the PowerPoint slides that will be sent to you as a follow-up email and of course all the replays of webinars can be found at Vimy comm on the videos page so let's get started this is a pretty deep and complicated topic and I can really talk all day about but I do want to be mindful of your time so let's get started one of the first things I want to talk about is why or why not virtualizing sequel as of as a workload is a good idea and we'll talk about that and there actually are quite a few considerations there but I think one of the challenges we have is making sure we can protect sequel server accordingly as we go virtual so I'm going to talk at length about how the Veen backup engine works most importantly how does it restore work I want to make sure all of our restore situations can be addressed with Veeam with virtualized sequel servers but I'm pretty sure I have some options on the restore that you didn't even think you could do with Vee much less a virtualized sequel server so I'm pretty sure somebody's going to walk out of here a little bit surprised to what they see my job here to tell you how veeam can help you with that so let's go ahead and get started I think one of the first things I want to do is this kind of level set sequel servers of very critical workload there's a lot of things that go into it meaning applications are really driven by it and chances are if you have sequel server it's important secondly I think I'd also be remiss if I didn't say that all sequel server VMs are not created equal and I could really say that about every virtual machine meaning no storage no networks no backup windows no expectations those are all different across the different environments that we all work on so I think it's important that we all kind of level set that everyone's requirements are different but what we can do may help us meet those requirements and expectations and there are a number of things that will point us down that route the first of which is how we do our backup ok so if you are like me you kind of grew up if you will doing backups as sequel server agent jobs or sequel server maintenance plans right I'm going to talk about those but I'm also going to talk about possibly doing something additional to that VSS is a is a part of the story part of the conversation that we'll talk about here today I think that VSS is great framework to leverage I mean windows gives us this framework to use for things like backups let me show you some cool things you can do with it but then also you have to remember the fine points like having adequate backups in terms of frequency and making sure logs are taken care of so these are some of the the big picture things that are going to lead my direction of what we're going to talk about here today in regards to the backup and most importantly in regards to the restore so let's start with that first question I posed why or why not virtual my sequel now last time I looked at the calendar it is 2013 I probably shouldn't have to convince too many of you that virtualization is a good idea but I understand there are some workloads you may have held off on and I don't have all of the answers specifically licensing all right night you know that really varies from organization to organization but the good news is we have a lot of resources to help us out virtualization today in 2013 has really advanced in terms of resources so what I mean by that is if you want to find the best practices to virtualize sequel server on VMware or hyper-v I'm convinced those materials are out there secondly there also are a lot of resources specific Devine Devine forms come to mind and we'll talk about that here in a second but basically you have a resource a support network including you know vendor issued best practices and even with veeam we have some kb/s we have some requirements Docs we also have how-to guides for the sequel tools that we have so when you put all those together I'm convinced that the resources are there you might need one more thing and I hope that the concept of the virtual lab and some of the sequel's specific things you can do really make that journey to a virtualized sequel server and option for you today so the first thing I want to talk about is the key to how veeam does its backups and honestly a lot of other products Veeam does what's called an image-based backup now it's not a very complicated thing it really is the whole virtual machine there is however a lot of technology that goes into it so when I talk about some of the different backup and restore options I think it's also important especially because we're talking about very specific things like sequel databases it's also important that I highlight what is not capable or any gotchas right so I think now's a good time to bring up the first of those so an image-based backup is an entire encapsulation of the virtual machine that includes its relative configuration and components in the VMware or hyper-v virtual infrastructure it includes the operating system and includes the applications and therefore the data okay that's loosely speaking what an image-based backup is in the context of how we're going to talk about it with v but it's important to note it is not simply copying the VM decays or VHDs so it's more advanced than that and it also is not simply taking a Shadow Copy or just picking up and copying the sequel MDS and LDS so it's not just a you know robocopy through the file system in the in the world of veem it's also important to note that there are actually 26 different recovery options from this agentless backup now I use the word agentless here because this image works at the virtualization level we do not install an agent inside the guest virtual machine so let's take a look at how that looks here on the bottom right so this is a simple graph from our free product beams.if which is part of backup free edition and this actually just says it really well we take the VM that's running and we back it up and we put it onto a disk resource we have a number of different restore scenarios those are three of the restore scenarios there are 23 additional ones and one of them is very much just specific to sequel server and we're going to talk about some of the other ones that apply to sequel as well so that's an image-based backup and again it's not a simple copy of files it really is an image of that VM I also want to talk about probably the biggest gotcha or thing that might be missing from you know what the DBA or the virtual machine administrator may expect from their backup of a sequel database and that's point in time restore I got to be really clear Vigne cannot by itself do a point in time restore why is that because the way we take that image-based backup is very much based on the point in time of that image-based backup now let's do a little bit of a reality check I would bet many of you as sequel server DBAs or even virtual machine administrators have deployed or watched the DBA deploy sequel server agent jobs and maintenance plans that do those point in time backups from a bak and a TR n file right those are those jobs that are set up you know every day do the full bak a and then every two hours possibly then do log truncation that way you could go back to 109 p.m. in 13 seconds if you really needed to but how many times have you actually done that now if there's an expectation in your organization to have that recoverability you actually still can do that with beam we just simply still have to do those jobs I actually think it's a great idea to go ahead and do that if you have that requirement and that expectation of that type of restorer but some of the image faced back up benefits that I'll show you probably will convince you that beam is also part of the picture and specifically there's things like a file copy job or putting those maintenance plan backups agent job backups putting those on a different drive letter those can really help you make veem and those types of jobs work together so let's look at that real quick so if you want to do them both and I'm convinced a lot of people still will if you're like me you probably deploy your sequel servers much like the figure on the left so if we have a virtual machine let's just assume we've deployed three virtual disks and again in this example it doesn't matter if it's VMware or hyper-v so v HD or VMDK file doesn't matter so basically you have the operating system that sequel application and the last drive is the data drive and possibly even an additional drive for like sequel log files you get the picture now Veen can protect that box perfectly and consistently and give you an incredible amount of Recovery Options but what I'm recommending is actually putting those sequel server agent jobs onto a different volume now you could put them on the same disk resource that the virtual machine is on but let me tell you why I think that can help you if they're put outside of it first of all you can actually get more Recovery Options so by having the backups off of that virtual machine if you had to fully rebuild the virtual machine meaning you lost the storage resource those backups don't go with it those point in time restores Veen can bring that whole virtual machine back very quickly but if those sequel server agent jobs are located out-of-band if you will you can then get the image back very quickly and then dial the time up exactly to where you need it that's one scenario now the other benefit that this provides is actually your backup window would shrink because if you look at the profile of these workloads the operating system the data the application on the left and then over on the right the sequel agent jobs you actually might have the most change rate over on the right by having that change rate outside of the VM that's really going to help increase the speed of the incremental backup so you actually get a lot of different benefits by doing it that way you can of course stack them all up I recommend separating but you still can get all the good features that VM provides that includes a virtual lab capability we're going to talk about that I'm actually going to also show you that in action pretty sure you'll like that point in time recovery so if you have those sequel server agent jobs or sequel server maintenance plans going to another volume can still download those back whole virtual machine image recovery that's sometimes very important to a lot of people as well as instant VM recovery our patented technology that lets us boot the entire virtual machine up that whole image directly from the backup if this virtual machine on the Left is 2 terabytes that might take a while to copy over this technology can boot it up in merely minutes so I did use a term agentless and whenever I'm talking to virtual machine administrators they love it they love to hear that but then I talk to application people then they start asking me questions questions come in three main categories what about log truncation what about application consistency and what about granular recovery the good news is with Veen we actually can address all three of those situations let's first talk about log truncation so I believe since the first edition Veen has included this application where processing it's a step of the backup job which is highlighted by some of the screenshots here below that will actually properly prepare the log from a log truncation standpoint during the backup so over in the top left you'll see that the transaction logs are pruned on a successful backup this is a great technique so that if you really go down the agentless backup route you can make sure that your logs are properly maintained because you all know that if you don't take care of the logs they're not going to take care of themselves for them for you secondly when it comes to application consistency back to that mentioning of VSS VSS is a framework where applications the operating system and backup applications can communicate for things like recovery techniques and more importantly backups we have our own VSS extension here that integrates into that framework that the operating system running sequel provides so that we can properly prepare not just the operating system not just the file system but also the application we can correctly prepare all three of those for the backup and that is that fourth option of the Veen backup wizard in this example it is VMware but it's the same for both hyper-v and VMware this engine will interact with the guest virtual machine and once it quiesce is the virtual machine with this step of the backup job we then communicate to the virtual infrastructure level then we'll do that hyper-v shadow copy or a virtual machine snapshot of this VM once that step is done we then resume through VSS and then start our data mover process I'll skip over that for now but if you have any questions drop them in the panel here but basically those two things can properly prepare the virtual machine for the backup and then most importantly can we do granular recovering the answer is yes so the good news is is that we can do all three of those big things from this agentless backup so I did get a question from Matt hopefully the audio is okay now sorry about that and roderick has a question do we have a plug-in for sequel backup so good question Roderick and actually it's well timed here on the screen so we don't have an agent that does the backups for us okay that's important to set for it I do have a tool where I can let restores be done on the database server or not on the database server I'm going to show you that tool as we get into the interface here in a second so let's talk about some of the specific restore options I talked about the backup agentless image based works at the virtual machine infrastructure level for both VMware and hyper-v off the top of my head I came up with seven different restore scenarios that you can do for a sequel server VM I did mention it there 26 restore scenarios for the whole product here are seven of them let's go through them real quick the first one is the coolest honestly that's the U air universal application item recovery this is a great way to reduce item level restores of that sequel server database now specifically for sequel server we have a wizard so I realize some of you don't have sequel server exclusively what I mean by that is you might have mostly sequel you might have some Oracle and my sequel and you might even have some that are on Linux that's fine the way sequel server the sequel server wizard works is that it does those item level restores for sequel but we also provide a framework that you can use your own native tools so I'm going to show you that but standby you'll see it but basically we have wizards force equal exchange active directory files we have something like that for a SharePoint which uses a sequel database and then secondly we have the virtual lab which you can get in with anything so the next restore scenario is what we're calling file level restore now that is inside of a guest virtual machine and what I mean by that is I can restore just the MDF if my DBA wants to pick up last night's backup with a sequel database here you go I can put this file wherever you want it I can also extract the virtual disk so if I have a disk with multiple VMs I'm sorry multiple databases attached to that virtual disk be it HD VHDX or VMDK i can actually extract that whole disk file and attach it to a virtual machine sequel DBA maybe their dev box or back to the production possibly little caution here if you do that then it's immediately visible to the virtual machine but that might enable the DBA to be needlessly consuming extra copies of the database and consume extra storage so give some thought to that but it is an option and of course we can do our whole VM restore techniques and that actually exists in two flavors the first of which is rebuild that image what I call whole VM restore I think it might be called entire VM restore in the UI but the other option is that instant VM recovery that will allow the whole VM to be restored from our backup file directly so you actually boot it up from the backup storage we don't actually have to copy the whole 2 or 4 terabytes or whatever it is back to a production store data store aka the weight is gone it can be as quick as one or two minutes to do that depends on the size of the VM depends on the storage and a lot of other factors but it's an incredibly fast restore technology we were the first to have it and we're actually just issued a patent for this technology we also have the replica capability so if you have a replicated infrastructure we can failover that virtual machine that's running sequel right from our replicated VM and then the last one is what I'm calling shared flr it's a play on the second one up here the file level restore and I actually heard this one from our tech support team that's one of the things I love about the office I mean I sit right next to them and I could hear them talking about some things and this was the greatest trick of all basically when you do a file level restore you can actually point to a UNC path and get an MDF directly and I'm going to show you that one so a couple of quick questions have come in let's go ahead and go through these real quick so Bradley asks are there additional license fees for using the agentless features good question Bradley I will to double-check but everything I'm showing you I believe is available in at least the enterprise if not the enterprise plus edition I don't know if the standard interface has the virtual lab so that might be the only thing that isn't available in Enterprise Edition so if you have enterprise or Enterprise Plus Bradley you're good that's a short answer loosen asks what impact does disabling application-aware processing cause we currently have issues where it causes the backups to fail a good question loosen now there's a lot of things that can go into them maybe giving you issues first of which could be storage IO load second of which could be the way the proxies are communicating I'd hope that you've checked in with support or the Veen forums for some guidance but basically the impact is that the sequel database is not properly prepared so Rob asks is the whole VM restore in a crash consistent State no it is actually in an application consistent state hopefully that answers those questions and Chris I'm almost there I am going to talk about that good time and that is the gotchas us screen again I wanted to talk about the things you can do but I also want to make sure that we don't get any situations where you might hit a gotcha so Kristin asks about a pass-through disk an RDM that's a VMware technology that allows a virtual machine direct access to a storage resource so the short answer is virtual mode our DMS are supported with Ving but physical mode our DMS are not and let me tell you why as part of our process when I mentioned that when we quiesce the database we take the hyper-v shadow copy or the VMware snapshot we can't take a VMware snapshot of the virtual machine if there's a physical mode RDM so actually you can't even do it in the vSphere client so there are a couple of gotchas the other one is using the I scuzzy initiator in guest so if you have some storage that you've provisioned over an ice cozy network and you have a virtual machine that instead of having the entire database live as VMDK or VHD you're actually presenting IQ and targets to the guest that is not part of the virtual machine so definitely watch for those two gotchas now again there is a great set of resources one is Avene forms and what other people in the community are doing so a couple other questions came in Brian's and Ron and Brian and Ron I will answer those later or towards the end but James had asked are there any gotchas with sequel 2012 Express actually James I believe that is fully supported both definitely back up and I believe so on the restore I checked a release notes of the sequel tool but I believe that that is the case now I'm going to go into the interview or not the interview but how about the interface and I'm going to talk about the features we have for the backup and restore but I wanted to show you this little message here this pops up when the virtual lab is ready but through the magic of television and in the interest of everyone's time here I've already prepared the lab so basically right here is the message you get this has already happened you can see the screenshot is actually from a while ago but I wanted to just show you that because when we go into the interface and the interest of time I've already prepared that so this is being back up in replication if you haven't seen it before welcome but let's talk about first knitting the backup basically a couple people had asked about that I want to show you the backup job here look real quick so basically I've given the Virtual Machine backup job a name and I can identify virtual machines to backup now I'm only backing up this one sequel server but if I wanted to add say every VM on a host I could do that if I wanted to add every VM that's located on a datastore for one particular host I could do that so think of these like containers any construct in vSphere cluster resource pool folder data store and in even vCloud director V amps virtual data center virtual organizational virtual data centers even System Center clusters ok in hyper-v hyper-v hosts all those constructs can function like a container great way to do all your VMs so that you're not missing any but let's just keep this example here nice and easy I'm going to skip over this notion of the proxy because it's really different than what we want to talk about here today but where we put our backups or any disk based backup resource pretty much anything I'm actually putting them on the V Drive here which is why it's a Windows Server 2012 deduplicated volume if you if you have a you know medium or small size data profile Windows Server 2012 is actually a great profile to put your backups on your Veen backups in particular the deduplication you can get is actually pretty good that's actually just going to check real quick and see what I'm getting here in terms of d-dude savings and them it's not reporting yet it's almost full but maybe not so good but this is not a very big volume I was actually in between labs due to version 7 coming out here soon but nonetheless we're generally storage agnostic and I got some NFS safes all kinds of different places but I'm actually putting this on the scene this is actually the local disk that the beam servers on now I did talk about that application we're processing so I've gone ahead and turned it on here but basically I've dropped in a user name and I have those options for the success of the backup job ok that will make sure that the log is truncated that the virtual machine is properly quiesce and that will make sure that the granular restore capabilities are good for this VM and the last thing here is the schedule pretty flexible scheduler I'm just going 10 o'clock every day I could say every 4th Saturday or could go every hour it could go after some other backup job you get the point pretty flexible scheduler and then of course if I have something i if that says maybe you know what that's the busiest type time of my week I can't do my backups then I can even exclude the backup job from running in a certain time okay that's the backup engine let's jump over to the sequel server dB so this particular system I'm going to try and make it quiet here see how I got okay I am a pretty brave soul this particular system here sequel oh one is actually running my production VMware datacenter vCenter database I should say this database is live it's running the environment here that is my V Center this is the real deal I've got let's see what I have 419 VMs and a whole bunch of busy busy hosts this database runs from here alright so I do trust this technology watch this so I'm going to go over this sample database here I have this small table table one I don't have much in it I'll give you that okay I have four little rows here but this is a production workload I'm going to go ahead and delete this database okay or this table out of my test database so you can pretty clearly see that that's gone now I did mention to you that I have gone ahead and started my virtual lab it is ready let's go ahead and open it and do a recovery technique so what's going to happen here is my virtual lab is ready I'll show you the steps here in a second but I want to go ahead and restore that table let's go ahead and restore that from the backup now I can actually restore it back into the database where it came from or I can actually export it out as a script DBAs might love it same thing with the schema and these query results if I want to run a query against my old database I have the capability here I'm going to go ahead and restore that data that I just destroyed so now what it's going to do it's actually going to query the virtual lab this backup in production I'm going to show you how that works in a VMware environment here in a second I'm going to talk about Veen sample database in the term of what I had from backup and what I'm going to put back into production then it's going to do a quick little comparison it's going to see what's running over here and what do I have running in this virtual lab now it's quickly going to see that that table one is is available in what we backed up and it's going to find that table I think it was called table underscore one let's see what it comes back with table underscore one now I only had one table I could have multiple in this view but there is only one and basically if I wanted to like to change the name so maybe restore it or something like that that might make sense kind of like the way you do files but in this case I'm going to maintain the name of that file so let's go ahead and see what it comes back with here again it has to interactively check the virtual machines that are running both in production and from our backup alright the new name is table underscore one same as it was before now depending on when this backup was taken right there might be different partition schemas or final groups and use in the way you've set up sequel so let's look at the file group I only have one but you get the point that if you have multiple file groups you can actually put that table back to where it goes in sequel talk I'm going to just try it with it well it's definitely going to go there but I'm going to do that and it summarizes the options and then watch this it's going to restore that table it's given me a success theme and if I wanted to I could then restart the wizard but that's the only interactive one with this wizard watch this tables back okay that's not really that cool all right you know what that's that's where an agentless backup you know pretty much anything can do that right well let's make it really cool so I mentioned that it's a virtual lab so if I go over here in the VMware environment let's take a look at this host in the single instance cluster and honestly this host is uh yeah I use it a lot it's pretty busy it's not a memory I'm sure you guys can relate that production database is right here SS a sequel o1 it's running my production V Center database actually running what you're seeing right here over here in this virtual lab I have a instance SSA - sequel oh one with a long wid that is the sequel database running in the virtual lab over here this is a network proxy appliance that we use to man Aitch access to that virtual lab this is my production network this is my virtual lab network so if I go over here you'll see that this particular virtual machine has the same IP address 10 0 20 49 as the production database who is on the table he's on the production network but this one is not this is on the virtual lab network so this duplicate IP is totally made okay because it's an isolated interface here in this particular port group doesn't even go to any configured ports so not to get too far in the VMware weeds for you but you see these virtual labs they don't connect anything ok that being said let's so Jim asks do I have to recover the whole VM to do this lab no that's option one with the wizard that I showed you but what I wanted to show you is because this is in this lab watch this this is amazing I'm going to connect so here's my production database server sequel o1 veeam I'm actually going to connect in that virtual lab there's a masquerade IP I'm going to skip over the networking but remember it was ten zero that's the masquerade IP address for the virtual lab I do not have a domain controller in there so I'm going to go ahead and drop in my sequel server off and look at this now I'm looking at last night's database in the virtual lab so if I look over here I can expand this table here look at this I can run a query over here or run my native management tool this is much like what I would do if it was my sequel for example I would skip the wizard and open up the virtual lab and get in with my native tool if this were Oracle that would be toad if it was my sequel would be another tool etc because basically this virtual lab here is brokered access and there's a rule that says who can get into it just to be sure here so if I go into this right here I mentioned a virtual network proxy Masquerade IP address it's set right here non-persistent this goes away after phim is done with its thing this route goes away so that 10 to 5 to network goes away but basically I can get in with my my native tool here's an example for the DBAs out there let's say you change the stored procedure but you don't know what you changed but you know you broke it how do you get it back this interface right here where I'm looking down here at the virtual lab from last night's backup and up here at the production database right now I can safely look at what it was without having to pull all that storage back in fact this is only taking a couple of megabytes or gigabytes probably the RAM plus a little bit of changes as all of this is requiring for this to run I do not have to pull back all if it was a multi terabyte database do not have to pull all that back and in this particular environment this virtual lab was ready to go and let's take a quick look here doing some quick math math here I started it at 11:27 a.m. or it was finished at 11:27 and I started it somewhere around that it's about it was ready in 10 minutes there we go eleven thirty nine so it was ready in about ten minutes it moves pretty Swift it depends on your storage okay but basically I'm able to look in the last night's backup right here just like that okay well that's cool let's disconnect that connection but I want to see another way of doing it so I have this virtual lab okay maybe you don't like the virtual lab 2v2 Jim's question I don't want to have to power and on in an isolated environment that's fair let's go ahead and do this so let's dismiss that lab and let's watch what happens over here so this job instantly went to stopping you may notice that the one that's selected and if I go over here you'll see that these are powered off watch this virtual machine it's going to go away that sequel server VM is gone then the network proxy appliance is now powered off there's housekeeping going on down there at the bottom and now we're back to like nothing ever happened okay but how can i still restore I can go into the restore menu this particular example is of a VMware virtual machine talked about restoring individual VM decays but let me show you this particular trick this is the windows file system here from that sequel server DB I can expand that sequel server there it is I can pick a restore point I'll just pick the most recent one and basically what's going to happen here is I'm actually going to browse into the file system of that VM so let me show you what I mean by that so I have actually represented the entire file system with this virtual machine in this view and the way this database is set up this is where my content is right here in data so what I can actually do if I want to let's do that pretty handy well actually I was wrong database if I wanted to do that I could do that pretty handily but watch this this is done and dusted let's go ahead and close that but watch this so if I wanted to look at that path that I just looked at this view is actually a cute little window into our back these are effectively shortcuts to the virtual disk that we have encapsulated in that restore point so I can actually get this UNC path right here I can send that over to my DBA and say hey how about this this is all from last night will that help you write so the time stamp on that is right here here's a sample one if you just want to log you can copy those watch this I can put it in here it's a simple example I can put it over here I can go over here is the DBA whoops not a new database but I could attach a database I can browse to that file that I just put in place of course no one would ever put it in there my documents but you get the point I now have a usable I think I do there yes I actually can do it okay now well no one would ever do that in production you get that but I need the log file but basically I could put that in there and and then attach that database straightaway so I'm not a log file is populated not so but basically you get the point that I could do that just like that anyways I'm not really sure why that Oh same name that's why that's a feature of sequel server so anyways you get the point if that database wasn't there I can I could attach it that easy if I wanted to use my native tools I can do that I can do file level recovery all kinds of features right from this agent let's back up now there's also probably the coolest feature is what we call instant VM recovery now I did mention that this is this particular one is my production sequel server database running vCenter I do want to keep it up our tech support team is using it but I'm going to show you the coolest feature right here that's what we call instant VM recovery so watch this I'm actually going to find that virtual machine from the backup I took and I'm actually going to power it on from the most recent backup directly from the backup file so if I right clicked and deleted my sequel server if I selected that option right there that would have it up very quickly I haven't deleted it but what I will do is show you what happens if you go through the menu now I'm going to go ahead and put it in the same place I'm just not going to I'm not going to overwrite the one that's there so basically I've given it a name I've EMR for instant VM recovery I'm going to tell my rights to go to the direct attached storage just because that's got a lot of transient space I'm not going to connect to the network because the production one is still there but if I had a real disaster I need to do that I need to get this VM up now so I would hit that power on button and watch this I should get a message that the original VM is actually still connected let's see link in here so basically I'm going to actually get that virtual machine back up and running very quickly right from the backup resource this particular VM is running on the tin tree it is only a hundred-and-something gig but no matter what your storage is moving that type of storage might take a long time so this particular technique will actually publish this virtual machine directly on the host and booted up right from the backup file so there it is I've EMR the instant VM Recovery virtual machine has been inventoried you see that the rights are being sent to the direct attached storage the data store is not the tin tree the you store is the Veen backup data store I actually have a special data store in VMware where I have a window into my backups and just like that this VM has been powered on so a couple people have asked you know is it crash consistent now I want to pull up an interesting point it does start up here but that's ok because we did properly prepare the VM but windows did not log event log was shutdown someone do that real quick and then this virtual machine will power up and be back up and running in moments that is instantly in recovery those are some of the some not all just some of the ways you can restore a sequel server with VM and I'm convinced you probably can't do all of that with the tools you may be using right now so I hope that the interactive demo here really can kind of give you some insight to some of the other things you can do with V and this is again my production VMware data center database there it is it's ready to go it's off the network so it's not going to interfere but you can quickly see if we instantiated it directly from the backup how cool is that anyways that concludes the interactive demo of beam backup and replication here now where we are with beam or modern data protection we like to think that things like this specifically for our sequel server these are a modern approach to protecting your VMware and hyper-v environments this is modern native protection built for virtualization powerful easy to use and affordable our version 7 Avene backup and replication really builds on this with a lot of market leading features I'll just go through this real quick but basically we have enhanced support for vCloud director this is really important from it's building modern data centers listen to our customers tape support is coming if you use SharePoint oh my goodness you have to see this tool we have the sequel stuff that I just showed you but we also have a great way to recover from SharePoint databases and some new virtual lab capabilities including what I just showed you available for hyper-v it's a great time to be with me great time to back up your databases okay let's go to the QA I have a lot of questions in the queue I appreciate that you guys have been a great crowd let's see what I can do with the Q&A now here so um let's see here Rob asks how are those situations supported for a restore well Rob you know I would actually just reiterate that using VSS is what we are doing for our backups we are not actually using a snapshot reversion for our backups so I'd love for you to give this a try try to break it I think I think you're like what you see Mike asks does veeam only still do virtual machines or can we do physical machines ah Mike I'd love to be able to tell you that we can do physical but right now there's still only hyper-v and VMware virtual machines so um Brian asks a great question how does beam compare to another product and I'm not going to name the product but I guarantee you nobody can do the virtual lab nobody can do that UI wizard nobody has had instant VM recovery as quickly as we have so I think that uh you know that should answer itself but you know what Brian if you have a very specific question let me know but basically you have to give this a try and if you go to VM comm you can download a free copy of V or the trial edition of a fully functional product and you can check it out on your own because I like to think that you know don't listen to me actually make your own decision on a backup product when it comes to the competitive choice I realize there's a lot of choices out there I do understand that but when it comes to virtual machines I really want to think that we're the best so Mike asks another question and actually Mike that's a great point about the two terabytes snapshot limit so for those of you using VMware you may know that if you have a VMDK exactly equal to two terabytes a VMware snapshot is not supported on those types of virtual disks the VMDK needs to be two terabytes - 16 K okay no VSS mike does not get around that issue but I would encourage you to size them down 16 K a couple people have asked about webinar replay and slides you should get an email with these uh as a follow-up if not you can send me an email I'm just going to put it down here for everyone if you want it I'll go ahead and send it to you right away today to send me an email I'll get you that and also Veen comm forward slash videos Wilfredo s will also have audio ya fiend comm forward slash videos we have all the webinars for replay it'll be this recording for your viewing pleasure and share with your friends something to do for Friday night if you ask me Paul asks very good question Paul is there an easy way to give a restored VM a new cid or a duplicate name excellent question Paul do you remember when I did the instant VM recovery there is an option it's a restore to original location or restore to a new location if I did that original location the whole thing is put back including the constructs in the VMware environment same for hyper-v in fact in hyper-v when you restore you can optionally keep that Sid or you can create a new one with VMware if you put it back exactly the way it was all that stuff is retained so it makes sense Paul hopefully so let's see here Nick asks Cyn the data in the sequel server is sensitive in nature do I have an option to encryption encrypted Nick are transfer to the storage resource does not encrypt we transfer from the source VMware encrypted and then to our repository we manage that but then when we write on a volume I encourage you to use an OS encrypter we do not provide a direct static encrypter for for backup Brian asks can you replicate to a hot site at a distant location absolutely the replication engine is actually very advanced Brian I encourage you to check that out actually there's a lot of good material on that it's very I think there's an incredible number of features with replication because really it's everything that backup has plus the ability to run it off-site so definitely check that out so the answer is yes assuming you want to do anything I showed you here today rederick asks for a sequel backup do you have the ability to do object level recovery down to the table view or stored procedure yeah you could open up sequel server management studio and if you just needed a line of a stored procedure yes you could David asks any issues backing up vCenter we have a KB on how to backup V Center if you're using version 6.5 or earlier our version 7 is coming out very soon but one of the things we've done is just built that KB into the processing engine so from version 7 no problems version 6 just look at the KB for a couple of tweaks christian asks can you run a vm from a cloud backup source like measure no i cannot run a vm from I can put a backup in the cloud and I can even do some of the recovery techniques I've shown you but no I cannot manage it being run in the cloud rhetoric asks does Veen provide compression actually we do we provide both compression and deduplication so street numbers you can get anywhere from 6 to 10x storage performance just with beams storage efficiencies brian asks can can we what about exchange you sold me on sequel yes actually exchange has a pretty cool story as well check out beam Explorer for exchange uh Nick you know I I don't know on your question about VMware View but I will tell you if it's a linked clone they're not supported so hopefully that helps you because again we can't call the VMware snapshot ok um I apologize for not answering all the questions interactively with text I think it's actually more beneficial if I actually just ask the question so everyone can hear final call for Q&A and as I wrap up I do want to encourage you go to VM comm we've got a lot of material the forum's the vblog I right there and my team writes there and also Twitter Twitter is a great resource if you have a question throwing out the bean throw it out to me we'll see if we can find it in the forums give you an answer off the top of our head and of course we've got technical support your local bean partners our version 7 at go team comm 4/7 Wow it's it's the biggest thing I've ever seen I'm really excited um actually no changes specifically for sequel server other than it's now available for hyper-v for the virtual lab capability but I really encourage you to check that out very soon ok last two questions came in here uh Matt asked a sequel back-end need uh to be a VM for SharePoint yeah actually if yeah massive we do need a SharePoint for the beam explorer for sharepoint does need to be a virtual sharepoint database and virtual sharepoint web server actually for that matter Arielle asks what about Unix yeah actually any supported VMware hyper-v virtual machine um you know what Phil sequel mm might be supported I'd have to check the release notes I know it will be supported for the U air and virtual lab I just don't know if it the UN lizard would be restored but the whole MDF the backup I believe so I just don't know if the wizard but I check the release notes ok everyone that concludes our webinar I really appreciate everyone taking the time out of their busy day stay tuned to veeam comm for some great news this week and with that thanks for attending today's featured webinar

Channel: Veeam

Views: 25,995

Keywords: SQL, Backup & Recovery, data protection, agentless backup, item recovery, Microsoft SharePoint

Id: eqOp4HcfNn8

Length: 51min 42sec (3102 seconds)

Published: Fri Sep 11 2015