North East VMUG - 07/08/2014

Registration for the next North East VMUG event is now open and you can register here.  The event will be held on Thursday 7th August and will now take place at the International Centre for Life.  There are two community sessions planned as well as sessions from VMware on the vCloud Hybrid Service and PernixData on their FVP solution.  The agenda will be as follows:

11:00 - EUC Round Table
12:00 - Lunch and Registration
12:30 - Welcome and Agenda - VMUG Leadership
12:45 - Community Presentation - Duncan Simpson
13:45 - Pernix Data Presentation
14:30 - Break
14:45 - Community Presentation - James Rankin
15:45 - vCHS - Dave Hill
16:45 - Closing Statement and Raffle
17:00 - vBeers

Big thanks to PernixData and Zerto for sponsoring these events so they can be free to attend.

Gold Sponson:

Silver Sponson:

The North East VMware User Group Wants you!!!!

Do you:

• Work or are looking to work with VMware technology in the future?
• Want to improve your public speaking skills?
• Give back to the North East VMware community?
• Want free beer?

The North East VMware User Group are looking for community speakers to present at events in the North East.  Slots are normally 45 minutes long including any Q&A that the topic may generate.  The topic can be based on anything relevant to VMware and / or your experiences designing, installing, using or supporting the software stack.

These are great events to network with like minded people in the North East who work with VMware and virtualisation technology in general and a great platform to improve on your public speaking skills in a comfortable and familiar environment.  If you have an idea and would like to put your name forward then please let me know and I will put you in touch with the leaders.  There is also a mentoring program called FeedForward whereby seasoned public speakers are willing to give up their time to help you with your presentation content and give advice and tips with the delivery of the content.  Mike Laverick (Blog | Twitter) has a post regarding this.  We may be able to offer some bribes prizes for all community presenters who present at an event.

BetterSnapTool (OS X)

I thought I'd point people out to this application that I found about a month ago that gives you the snap to window functionality that was introduced in Windows 7 in OS X.  Since I moved to a Mac Book Pro 15' as my primary work device with multiple monitors I really struggled with the ability to move windows across multiple screens and constantly having to resize windows to fit.  I found BetterSnapTool on the app store and and for a small cost of £1.49 it's possibly been the best purchase I've made.

There are a wealth of options available to configure how the application works with regards to snapping to specific area's of the screen as well as right clicking on the close, minimise or maximise window buttons:

The below screen shot shows you a notepad application being dragged into the top left hand side of the screen and the application being automatically resized to fit accordingly:

If you miss the snap to windows functionality from Windows 7 then I advise you to check the application out, especially if you use multiple monitors.

Restoring a SQL Database with VDP Advanced

In a previous article I showed how to backup a SQL database with the VDP Advanced agent.  This article is going to show you how to restore a database from backup in the event that you accidentally deleted the database or want to restore over the top of the existing database.  For this test I created a new database called TestDB in simple recovery mode and created a table called dbo.Test:

I then performed an application backup of the SQL server to capture the newly created database:

Performing a restore of a deleted database

In the first example I am going to delete the database and then perform a restore from backup.  As you can see, I've now deleted the database from the SQL server:

In order to perform a restore simply navigate to the VDP plugin and click the Restore tab and navigate down the tree structure until you find the database that you wish to restore.  Check it and then click the Restore button:

Verify the database that you have selected is correct and click Next:

Leave the Restore to original location check ticked and expand the Advanced Options and uncheck the Tail-log backup option.  The tail-log backup option is only used for databases that use the full or bulk-logged recovery model.  Once finished click Next:

Verify your settings and click Finish:

The restore job should start and you can monitor this via the Tasks pane within the web client.  Once it's completed you should see the database has been restored with all data (Refresh SQL Management Studio if you left it open):

Performing a restore over an existing database

In this example I'm going to show you how to restore a database over the existing database.  This is handy if you've accidentally deleted some data or some data is potentially corrupt.  For this example I'm going to delete the dbo.Test table and then perform the restore over the top of the existing database.  As you can see the table has been deleted:

Perform exactly the same steps as per the previous example and then monitor the job to ensure it completes successfully and then referesh the view in SQL Management Studio and you should see the returned data:

If you are experiencing any issues with the restore then check out the log files on the client at the following location:

C:\Program Files\avp\var

Below is an example of a log file with a successful restore:

<logheader platform="Windows Server 2012 Datacenter Server Edition (No Service Pack) 64-bit" process_id="avsql" version="7.0.182-99" tz="GMT Daylight Time" />

--------------------------------------------------------------------------------------------------------
-----  START avsql log 2014-04-25 10:54:41 GMT Daylight Time  [7.0.182-99 Windows Server 2012 Datacenter Server Edition (No Service Pack) 64-bit-AMD64]
--------------------------------------------------------------------------------------------------------

2014-04-25 10:54:41 avsql Info <5008>: Logging to C:\Program Files\avp\var\MOD-1398419682252-3006-SQL.log
2014-04-25 10:54:41 avsql Info <6673>: CTL listening on port 56549
2014-04-25 10:54:41 avsql Info <10684>: Setting ctl message version to 3 (from 1)
2014-04-25 10:54:41 avsql Info <16136>: Setting ctl max message size to 268435456
2014-04-25 10:54:41 avsql Info <17376>: Working on stand alone environment.
2014-04-25 10:54:41 avsql Info <7838>: - Adding user exclude "*/tempdb"
2014-04-25 10:54:42 avsql Warning <14282>: Option "Handle SQL services automatically" can only be used with option "Restore system databases."
2014-04-25 10:54:42 avsql Info <18824>: Compare hostname 'sql01.m80arm.local' with current machine hostname 'sql01'.
2014-04-25 10:54:42 avsql Info <7062>: Targets count 1
2014-04-25 10:54:42 avsql Info <7063>:     target[0] = '(local)/TestDB/f-0'
2014-04-25 10:54:42 avsql Info <7065>: Working on target '(local)/TestDB/f-0'
2014-04-25 10:54:42 avsql Info <14293>: Creating a database task for '(local)/TestDB/f-0' (hcount 328)
2014-04-25 10:54:42 avsql Info <14245>: Creating a thread pool with 1 worker threads.
2014-04-25 10:54:42 avsql Info <14248>: Executing task: (local)/TestDB/f-0 --> vd_streams[1]
2014-04-25 10:54:42 avsql Info <14250>: VDI SQL Instance: 
2014-04-25 10:54:43 avsql Info <14266>: Executing the data transfer task: (local)/TestDB/f-0.stream0
2014-04-25 10:54:43 avsql Info <9552>: Spawning 'C:\Program Files\avp\bin\avtar' (avtar --case_sensitive="false" --max-streams="1" --cacheprefix="avsql_t0" --ctlcallport="56549" --ctlinterface="3006-MOD-1398419682252#1" --check-stdin-path="false" --logfile="C:\Program Files\avp\var\MOD-1398419682252#1-3006-SQL.avtar.log" --vardir="C:\Program Files\avp\var" --bindir="C:\Program Files\avp\bin" --sysdir="C:\Program Files\avp\etc" --acnt="/clients/VDPApps/sql01.m80arm.local" --id="restoreonly" --ap="****************" --server="vdp.m80arm.local")
2014-04-25 10:54:43 avsql Info <6686>: Process 2552 (C:\Program Files\avp\bin\avtar) for workorder MOD-1398419682252#1 started
2014-04-25 10:54:43 avsql Info <10684>: Setting ctl message version to 3 (from 1)
2014-04-25 10:54:43 avsql Info <16136>: Setting ctl max message size to 268435456
2014-04-25 10:54:43 avsql Info <7732>: Waiting for avtar to finish
2014-04-25 10:54:43 avsql Info <6688>: Process 2552 (C:\Program Files\avp\bin\avtar) finished (code 0: success)
2014-04-25 10:54:43 avsql Info <6446>: SQL VDI transfer of '(local)_TestDB_MOD-1398419682252-3006-SQL' to '(local)/TestDB/f-0' successful
2014-04-25 10:54:43 avsql Info <14275>: There is no more tasks to process.
2014-04-25 10:54:43 avsql Info <14271>: Waiting for worker threads to finish ...
2014-04-25 10:54:43 avsql Info <16256>: Creating process summary ...
2014-04-25 10:54:43 avsql Info <16257>: Inserted task: 1, completed: 1, aborted: 0.
2014-04-25 10:54:43 avsql Info <7271>: Final summary generated subwork 1, cancelled/aborted 0, snapview 1, exitcode 0
2014-04-25 10:54:48 avsql Info <6451>: avsql returning with exitcode 0

--------------------------------------------------------------------------------------------------------
----- END avsql log 2014-04-25 10:54:48 GMT Daylight Time  (1 warning, 0 errors, 0 fatal errors)
--------------------------------------------------------------------------------------------------------

Backing up SQL Databases with the VDP Advanced SQL Agent

In this article I'm going to show you how to backup SQL databases using the VMware Data Protection Advanced SQL agent.  The first thing you need to do is download and install the SQL agent on your SQL server (If using SQL 2012 then please refer to this blog article).  The SQL agent can be downloaded from the Configuration tab within the VDP plugin and you have the choice of either the 32 or 64bit version:

Once downloaded simply copy it the SQL server and install as per any other application.  I'm not going to go through this process as we've all done time many times before.  Once installed you should see the Backup Agent service:

Now go back to the VDP plugin within the web client, select Backup and then create a new backup job:

Select Applications and click Next:

Select the option for Selected databases to perform database backups rather than a full server backup and click Next:

Drill down and select the database(s) that you require or select the server to backup all databases on the server and click Next.  If your using SQL 2012 you may need to grant the local System account permission.  You can find out how to do this here:

Select any additional backup options and click Next.  For this example I'm just going to leave all the defaults but the VDP 5.5.5 admin guide explains them in more detail:

Configure the required schedule and click Next:

Select the required retention policy and click Next:

Give the backup job a suitable name and then click Next:

 Verify that all the information is correct and click Finish to create the job:

Once the backup job has been created it should appear in the list of jobs:

Now you can either leave the job to run at it's next scheduled time or manually run the job by selecting the job and then Backup Now -> Backup All Sources:

Leave the job to run for a few minutes and then refresh the screen and hopefully it should have completed successfully.  You can also monitor the job via the log file within the configuration tab or via the web client tasks pane.  Once the job has completed successfully verify that the backups are actually there by clicking on the Restore tab and navigating to the server and databases:

VDP Advanced SQL Agent Permissions

I've been playing around with the VDP Advanced appliance recently and can across this little gotcha when using the SQL agent to backup individual databases.  After downloading and installing the agent on my SQL server and creating a new application backup job when it came to selecting the databases I would only see the default three which were master, msdb and tempdb:

After searching for a while I was unable to find anything relating to this error and the VDP 5.5.5 Admin Guide doesn't mention the fix.  I assumed it would be a permission problem so I added the vCenter service account to the local administrators group to ensure it had full access to SQL.  This didn't resolve the issue, I then checked the Backup Agent service which was running as the Local System user and realised that it obviously didn't have permission to SQL.  I changed this account to run as the vCenter service account and then created the backup job again and hey presto:

I removed the vCenter service account from the local administrators group and added it to a global SQL administrators group just to tidy things up.  Remember this is my lab environment so I'm comfortable with the vCenter service account having those permissions.

Update - 23/04/2014

The VDP 5.5.5 Admin Guide does actually advise you regarding this issue on Page 145 as this is applicable to SQL 2012:

VMware vForum 2014

Just a quick post to let you know that VMware's vForum UK dates have been announced and the agenda released.    The UK locations will be in Manchester and London and more information and dates can be found below:

London
11th June 2014

Wembley Stadium
Wembley
London
HA9 0WS

Agenda

Register

Manchester

8th July 2014

Manchester Central

Windmill Street

Manchester

M2 3GX

Agenda

Register

Hopefully I'll be either a booth babe for the day or presenting so if you see me, come up and say hi.