Badges

gestaltitbadge

follow-me-twitter

Subscribe to me on FriendFeed

Comments / DISQUS
Feedjit.com

Posts Tagged ‘veeam backup and replication’

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 Winking smile, 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:

image

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.

Read the rest of this entry »

User File Level Self Restores With Veeam Backup and Replication

Most backup and VMware  admins already know that Veeam Backup and Replication  (VBR) can do File Level Restores (FLR) for any Virtual Machine running any Guest OS and File System that VMware supports. The default process to restore the files involves using the VBR GUI for auto assembling the VM’s .vmdk from the Veeam Backup Files (without moving data to any additional storage location or starting up the restored VM), and then using the pop-up file browser to “copy to” any location. But, did you know you could allow users to browse the restored VM file system and do their own file restores? From their own desktop or the desktop of the destination system? You won’t find this information in the VBR User Guide today, but it is very easily done.

disclaimer: I am a Systems Engineer for Veeam Software

Now, with VBR version 5 a FLR Appliance can be activated, auto registered, and configured for file level restores. Although the FLR appliance is only used when you select “Guest Files (other OS)” from the Restore options, the Linux based appliance VM can mount NTFS and most other non Windows file systems. By choosing to use this appliance you have the option to enable FTP access to the restored .vmdk thus making the recovered file system(s) easily available from any desktop. Therefore, end users or application owners can just open Windows Explorer, their favorite web browser, or a FTP client to browse, find, and download their recovered files themselves. No additional software needs to be purchased, and if you use the native OS web and file browsers nothing else even needs to be installed.

This means that the only time required by the VMware / Backup admin is the few minutes it takes to click through the Veeam restore wizard and verify the FLR appliance VM is running. Of course, a few extra seconds is required to click to close the FLR GUI when the user is done.

The rest of the post shows the many screen shots of using and configuring the Veeam FLR Appliance Restore option and a few simple, end user alternatives for accessing the restored files from the remote system. 

Read the rest of this entry »

Pre-existing Snapshot Could Cause Inconsistent Incrementals Using vSphere CBT

Tom Howarth, VMware Communities Moderator and blogger at PlanetVM.net, posted this week how he was informed by a developer of a virtualization backup vendor about a scenario involving reverting to an ESX snapshot that results in corrupted incremental backups when using vSphere’s Change Block Tracking (CBT). Howarth’s post Major issue with Change Block Tracking recounts his conversation and exploration of the problem with the developer. In summary, Howarth reported “there is a major issue with the way VMware handles the indexing of the ChangeID.”

Almost a week later and after a flurry of comments from most of the vendors leveraging CBT for virtual machine backups, VMware has published a KB article on the subject.

VMware KB: Reverting to a pre-existing snapshot under specific conditions can cause incremental backups based on CBT (Changed Block Tracking) to become inconsistent

The KB Article describes the exact scenario that causes the problem:

Read the rest of this entry »

Verify Recovery Of Full VM Backups With Future Version Of Veeam

image Previously, all we knew about Veeam’s Surebackup was there was a public countdown in process. That countdown reached 0:00 early March 22, 2010 (this morning). Veeam sent emails to those who preregistered and then provided a press release shortly after. The countdown was for the introduction of a unique feature for verifying VM restores that will soon be introduced in the next version of Veeam Backup and Replication.

Here’s the information from my email for those that did not sign up to be notified:

Breakthrough Technology: Test and Verify the Recoverability of EVERY Backup

Veeam is enhancing the SureBackup™ capabilities in Veeam Backup & Replication™ with a breakthrough technology that overcomes the final obstacle of image-level backups. IT professionals will have the ability to verify the RECOVERABILITY of EVERY backup of EVERY virtual machine EVERY time. It’s never been possible before.

SureBackup introduces a new patent-pending technology that allows IT professionals to run a virtual machine directly from a compressed backup file.

By publishing the content of backup files directly to ESX hosts, you can:

  • Eliminate the need to extract backup files
  • Test and verify EVERY backup in a matter of minutes, without affecting backup windows
  • Perform recoverability testing without additional hardware or staff

The same technology also allows for item-level restore for any virtualized application, on any OS (patent-pending).

This exciting new technology will be made available in version 5.0 of Veeam Backup & Replication, scheduled for release this summer.

Sound too good to be true? Join us for a free webinar on Wednesday, March 24 at 2:00pm EDT to find out more. Live Webinar – Register Now!

Can’t wait? Go to www.veeam.com/surebackup NOW!

I was actually invited to Veeam’s pre release blogger briefing over the weekend, and the rest of this post is my notes and thoughts about what I learned during briefing.

Read the rest of this entry »

Get My Podcast On iTunes!
Support VM /ETC
Support VMETC.com

Support VMETC.com

Free Business and Tech Magazines and eBooks
@rbrambley tweets
VMTN Roundtable Podcasts
Subscribe



Add to Google Reader or Homepage
Subscribe in NewsGator Online
Add to netvibes
Add to Plusmo