Posts Tagged ‘how to’
Virtually Backing Up A Physical SQL Database (vCenter, Veeam, etc.)
This post explains functionality of Veeam Backup and Replication (BaR) that you are not going to see in the User Guide. I was browsing the Veeam Forums and came across this thread – Backing up Veeam / vCentre Physical Machine which inspired me to write this post. The thread is actually about having an with an issue using with the scheduled backup of a physical vCenter server, which also happens to be running Veeam Backup and Replication, using another product.
I’ll get right to it. You can make a backup copy of physical SQL databases with Veeam BaR. Both vCenter and Veeam BaR have a SQL backend. You can’t schedule this as a job, but there are several scenarios where you could take advantage of a quick and easy, one time, manual backup – before an upgrade or patch, for example.
Although I work for Veeam, this is not necessarily an intended or fully supported usage of the product. This is an easy alternative for the VMware admin to CYA
, however.
I’ll start with a brief introduction on how the SQL U-AIR wizard is supposed to work, and then I will explain how you can use an admin switch to make a backup copy of SQL database whether on a VM or a physical server. VMware vCenter and Veeam BaR/Monitor/Reporter all have SQL back ends.
The U-AIR Up There
To do this you can use the SQL U-AIR wizard. U-AIR stands for Universal Application Item Recovery, and there are 4 stand alone .exes for the various U-AIR wizards of Veeam BaR – AD, Exchange, SQL, and Universal. All of these wizards can be installed on the Veeam BaR server or on any Windows system that can communicate with Veeam. They could be installed on an admins desktop or the SQL, Exchange, or Domain Controller servers too.
Normally, the purpose of the U-AIR wizard is to request and kick off a workflow for a Veeam vPower Virtual Lab. Once the request is approved and managed by the VMware/Veeam administrator and the “Lab Manager–like” virtual lab is ready with the fenced off, running backup copy of the VM(s), the U-AIR wizards allow for the restore from the backup copy VM to the original production VM. For SQL VMs in particular, the restore options are shown in the following screen shot:
Watch this 4 minute video to see the normal SQL restore functionality of the wizard. This video skips the workflow request, skips the wait for approval and virtual lab start up, and just shows what is possible from a backup copy of a SQL VM. I also want to mention that this is an agentless solution. You do not need to install and manage agents anywhere with Veeam BaR.
Trick The System for Physical SQL backups
You can skip the workflow process of starting and using the vPower Virtual Lab if you use an undocumented (as far as I know) Admin Switch for the U-AIR wizards. I’ll focus on the SQL U-AIR wizard for the rest of this post, but it is the same for the Exchange and AD wizards as well.
Veeam Reporter Quickstart Guide– VM IP Address Report Example
Veeam recently published a Veeam Reporter Quickstart Guide that can be downloaded here: NEW! Quick Start Guide: Veeam Reporter Dashboard
In short, It was written (by me!) in order to help Veeam customers, evaluators, and free version users understand how to create and save useful VMware reports and use the output of that dynamically updating content for day to day VI Management. This new guide helps you get up and running fast, and provides a primer for building valuable dashboards (click image to the right for a sample dashboard) from those saved reports!
This post contains information for building one of the reports from the new guide – VM Report (By IP Address)
TiVo For Your VMware Infrastructure
The Quickstart Guide gets right to the point by explaining how to create an agentless collection job that constantly updates your reports. Much like if you had a premium subscription with your cable TV provider,
Use Event Badge To Repair Broken Backpack Or Luggage Zippers
The average virtualization admin, engineer, manager, and general IT person probably goes to half a dozen events a year where they receive a name badge. I’m just guessing, but at least 2/3 of those event badges are now in the form of a necklace/lanyard. Just guessing again, but I’d be willing to bet that 99% of all the lanyards get thrown away shortly after. That same average IT person probably attends 1 or 2 big events or conferences a year where they are lucky enough to receive a backpack, computer bag, or other schwag with zippers. Unfortunately, the pull tabs on the zippers more than likely will break off leaving an awkward and often painful to pull open/closed zipper head. I’ve stopped using several otherwise very functional bags just for this reason. But, while planning for a recent vacation, an idea so simple struck me that I was amazed I hadn’t thought of it already.
I did not want to take my full computer bag on the vacation. It’s an oversized bag designed for an entire file cabinet and a night’s change of clothes. One of my old backpacks was perfect for my notebook, iPad, magazines, and the various accessories my wife and I would need on the plane and while sightseeing. When I went to grab a backpack in my basement I noticed the nail of badges hanging above them.
For some reason, I can not bring myself to throw away my event badges. I can’t tell you why. I just knew I would do something with them one day. But now I have a new purpose for them, and I am quickly reducing the bulk hanging on that nail. Besides, you never would have seen a headline like “North Georgia Man Saves Family From Burning House With A Linked Lanyard Ladder”, now would you?
So if you are like me you already have what you need to repair your luggage, backpacks, and various other pull zippers around the house. Here’s my quick how to and list of tools needed:
Install Androidx86 in a VMware Workstation VM
I was inspired to try a full install of the Androidx86 OS in a VMware Workstation VM after Eric Sloof created a video of the Androidx86 LiveCD running in a vSphere VM. I’ve documented building the VM and configuring it to run in this post. I also list some navigation tips for getting around inside Androidx86. Finally check out my video of the working VM.
Since most are probably wondering I’ll mention this now, once the VM is connected to the Internet you can download a very limited selection of Apps, but I had sporadic success with the various Apps I tried. For the few that I did get to install, I wasn’t able to get all of them running. So, use an Androidx86 VM as a way to get a feel for what an Android device is like. Maybe it will help you make a decision about buying a Tablet like the Samsung Galaxy Tab.
Browsing the web worked great. I do not test email.
Download, Create New VM, and Install Androidx86 from .ISO
Download the latest revision of the Androidx86 .ISO here:
http://www.androidx86.org/downloads.html
Build a new “typical” VMware Workstation VM (this should work just the same with the free VMware Player), and when you point the install wizard at the Androidx86 .iso the OS type FreeBSD is auto detected. I chose to install the operating system later as I did not want to invoke the auto download of the VMware Tools.
This choice forces you to manually specify FreeBSD from the next screen of the wizard.
I kept the default disk size of 8GB and to chose to store the virtual disk as a single file.
I customized the virtual hardware and did the following
- bumped the RAM to 512 mb. The Workstation wizard suggested 256 mb.
- deleted the floppy
- pointed the vCD/DVD at the Androidx86 .iso and made sure it was connected at power on.
- changed the vNIC to Bridged. NAT should work just fine too. (Note that additional networking changes need to be made later)
Once your ready, boot your new VM and choose to install to harddisk when prompted by the Android Installer.
Do It Yourself Veeam Backup and Replication, Reporter, and Business View vSphere Client Plugins
A common request since I started at Veeam Software has been for the ability to plug in Veeam’s products to vCenter and/or the vSphere Client. After all, VMware admins are used to the idea that they can go to the same interface to accomplish almost everything. VMware’s strategy to make their client expandable via a plugin architecture is brilliant, and many Technology Partners have introduced vCenter and vSphere Client plugins for their products as a result. Veeam, for whatever reasons (maybe because the developers have been focused on new game changing features!), has not created plugins to date. However, since most of the Veeam Software suite has web pages for management interfaces already, it is very simple to create plugins yourself!
This post provides unofficial, unsupported template files and a basic “how to” instructions for using vSphere Client plugins for the following Veeam web management interfaces:
- Veeam Backup and Replication Enterprise Management Console
- Veeam Reporter Dashboard
- Veeam Business View Dashboard
These plugins should work whether you are using any Veeam product versions or whether you have the paid or free versions of Monitor and Reporter. Bottom line: If you can make the Veeam web pages work correctly in a standard web browser on the system where you have the vSphere Client installed, then the plugins should work too.
You may have noticed that Veeam Monitor has been left out of the plugin list. That is because Monitor does not have a web interface. However, be sure to read the end of this post to see how you can use the vSphere Client from within Veeam Monitor. It’s “the photo negative” of what VMware admins are used to, but it accomplishes the same benefits.
Also understand, you can use the templates as a base for whatever web interface you want to pull into the vSphere Client. This is not just applicable to Veeam products.
I want to credit Carter Shanklin, Eric Sloof, and Ricky El-Qasem for originally providing information about how to create web based plugins several years ago. El-Qasem even released a handy .NET tool for auto creating and registering plugins with vCenter which involved making the resulting .xml files centrally available via Tomcat from the vCenter Server. I followed the trail of crumbs from these guys.
Download the Veeam vSphere Plugin templates
Veeam vSphere Plugin Templates (657)
The rest of this post contains basic instructions, some screen shots, and a tip for making Reporter work correctly in the vSphere Client. Finally, integrating Veeam Monitor and the vSphere Client is covered briefly.
How To Modify the Templates and Instructions for Using the Plugins
The following is the contents of the README file included in the .zip
Replication Bandwidth Calculator From Virtualize Planet
Figuring out whether you can replicate your VMs across your WAN to a DR site is never easy. There are many factors to consider, but luckily, one of my Veeam peers and a fellow VMware vExpert, Ricky El -Qasem has created a Replication Calculator to help figure it out.
From the post on the Virtualize Planet Blog: Replication Bandwidth Calculator | Virtualize Planet
ReplicaCalc
How many times do you get asked “how do I work out if VM Replication will work with my internet link” Well I wanted to demonstrate some way of providing a calculator without working it out in my head every time. So I made a Replication Calculation tool. It is assumed that you provide it with 3 values:
- Average Rate of Change.
- The Link speed – this value should reflect the upload speed at the source site or the download speed at the target if this is less. So for example if the upload at the source is 6Mbs and 10Mbs download at the target then go for 6Mbs
- Bandwidth % – which is the amount of bandwidth as % which achievable from the link speed specified.
Download and install ReplicaCalc from here > ReplicaCalc
Ricky describes the needed values in more detail in his post so be sure to read it all there. He also demonstrates how to use Veeam Backup and Replication to get the VM dynamic rate of change. The tool is useful whether using Veeam to replicate your VMs or not, however.
Thanks Ricky!
For more on this topic, I’ve blogged about using a bandwidth calculator to figure out whether your current WAN link is adequate or not for your replication jobs before.
Cost Effective Virtualization Training From Train Signal
Image of Train Signal
If you did not already know about Train Signal and their video training series then I hate to be the one to break it to you, but you have been missing out. If you read this blog or listen to the VIRTUMANIA podcast then surely you’re in the know. Train Signal is a long time sponsor here at VM /ETC (as well as at most all of the popular v12n blogs), a friend to and guest of the podcast, a returning sponsor of the VMUnderground VMWorld Warm Up Party, and always highly visible in the community with free video give aways at VMUGs, conferences and events.
I do not just blog about Train Signal because of business, however. I possess several of their videos and know several of the instructors. Train Signal is well worth the investment whether for one individual or an entire staff.
With the recent release of the vSphere Pro Series Vol 2 containing instruction provided by vExperts and recent VIRTUMANIA guests David Davis, Hal Rottenberg, Rick Scherer, Eric Siebert, and Sean Clark (Hey Rick, I got to get you on the show too!) Train Signal keeps adding great content to an already awesome collection for those looking for cost effective, at your own pace virtualization training.
What I find most amazing about Train Signal is the multiple formats available. With DVD, AVI, WMV, MP3, MP4 for iPods/iPads/smartphones, and even PDF you have the flexibility to learn where ever you are and how ever you need. Now, with instant online access via the My Training Portal as well, you don’t even have to wait for the media to be shipped to you! I was recently amazed when I was able to stream videos to my HTC EVO!
Here’s a quick list of the virtualization training series that I feel are well worth checking into. Be sure to check the free videos listed at the end of this post too!









