SCVMM 2012 now Release Candidate

September 12th, 2011 No comments
Categories: Virtualization Tags:

Free Hyper-V backup solution

January 18th, 2011 No comments

I had to find out a way to do a scheduled backup for a customer without buying the Symantec Hyper-V agent.

First I’ve used the following script to shutdown / save / pause all of my VMs.   http://capilla.codeplex.com/releases/view/29002

Then  I downloaded PSexec : http://technet.microsoft.com/en-us/sysinternals/bb897553

I now have everything to build a small batch to pause , copy over to hd and resume my VMs. I used xcopy to copy my vhd btw..

One thing to note, when working with remote systems and powershell, you’ll have to invoke cmd otherwise psexec will not process your batch file correctly.

Here’s an example of the correct syntax :  psexec \\hyperv2 cmd /c “echo . | powershell c:\script\hvcmd.ps1 “pause SCE2010″ ”

Voilà !

Categories: Virtualization Tags:

January 5th, 2011 No comments

During the holiday I finally passed the last exam (70-444) for the MCITP : Database Administrator certification.

I’m glad it’s finally behind me. Next step will be to take 70-453 to upgrade to the MCITP for SQL 2008. Should not be that hard hopefully, since I’ve been working with SQL 2008 for a while now.

Categories: General, SQL Server Tags:

How Facebook works…

January 5th, 2011 No comments

Awesome video to understand the complexity behind Facebook.

 

The comment about having 35 TB of logs everyday is simply breathtaking.

Categories: General Tags:

How to uninstall SP1 Beta from Hyper-V Server R2

December 8th, 2010 No comments

For those of you wondering how to uninstall SP1 without access to the add/Remove Program utility, here’s the command that will do it.

wusa /uninstall /kb:976932

Hope this helps !

Categories: Virtualization Tags:

Update Excel file via OPENROWSET

September 29th, 2010 No comments

I’ve been fighting with  SQL Server for a while before finding this magical command…

Here’s how to update an excel file via T-SQL

update OPENROWSET(‘Microsoft.Ace.OLEDB.12.0′, ‘Excel 8.0;DATABASE=c:\book1.xls’, ‘Select * from [Sheet1$]‘)

set col1 = ‘working now’  where col3 = ‘working’

Categories: SQL Server Tags:

How to read / write Excel file via T-SQL and SQL Server 2008

September 16th, 2010 No comments

First download this on your server : 

http://www.microsoft.com/downloads/en/details.aspx?familyid=C06B8369-60DD-4B64-A44B-84B371EDE16D&displaylang=en 

Then, create a linked server on your SQL Server 

exec sp_addLinkedServer
@server= ‘MyTest’,
@srvproduct = ‘ACE 12.0′,
@provider = ‘Microsoft.ACE.OLEDB.12.0′,
@datasrc = ‘c:\bok1.xls’,
@provstr = ‘Excel 12.0; HDR=yes’
 

Finally,  run this :  select * from MyTest[sheet1$] or this :  insert into MyTest[sheet1$] select ’1′,’2′,’3′

Categories: SQL Server Tags:

SQL 2008 evaluation upgrade problem…

September 15th, 2010 No comments

For all of you with evaluation version of SQL 2008 , be prepare to run into an issue while upgrading to the full licenced version.

For some reasons, the upgrade process cannot upgrade the client management tools.

Thanks to Jonathan for the quick fix. I’ve tested it twice and it’s working ! 

http://sqlblog.com/blogs/jonathan_kehayias/archive/2009/02/20/sql-server-2008-evaluation-edition-expiration-woes.aspx

Categories: SQL Server Tags:

September 2nd, 2009 No comments

Windows 2008 R2 + SCVMM 2008 R2 now RTM’ed

Since both products are now released, I’m planning to build a new Hyper-V cluster.

Stay tune for a complete walkthrough !

Categories: 2008 R2, Virtualization Tags:

September 2nd, 2009 No comments

Taken from http://gnawgnu.blogspot.com

I don’t usually do this…but it may help some other admins out there !!

 

 

Windows 2008 R2 backup exec and failure occurred accessing the Writer metadata – Workaround

Nothing tramples the joy of playing with a new operating system faster than finding out that your vendor is being a deadbeat and hasn’t put out a compatible release yet. You’d think that out of the army of programmers that Symantec has that they’d have at least one technet or msdn subscription and that they’d have started working out compatibility issues in the meager half year that the betas were available. I was also amused to find that on their forums some of their staff didn’t realize that the RTM was out yet for Windows 7 and 2008 R2… But I digress.

So you’re using Backup Exec 12.5 and trying to backup a Windows 2008 R2 RTM server using the Advanced Open File option and you get this error:

V-79-57344-65225 – AOFO: Initialization failure on: “\\MyServerName\System?State”. Advanced Open File Option used: Microsoft Volume Shadow Copy Service (VSS).
Snapshot provider error (0xE000FEC9): A failure occurred accessing the Writer metadata

  • Option 1: Wait a month or so till a hotfix comes out.
  • Option 2: Wait until Backup Exec 2010 comes out with official support for R2.
  • Option 3: Fix the VSS issue that’s causing it in the first place!

During the installation of Windows 2008 R2 RTM, it creates a Recovery Partition that’s about 100MB. When the AOFO agent kicks in, it works with the VSS providers in the operating system to create snapshots. However, VSS really doesn’t like those tiny partitions like the 100MB System Reserved (Recovery) partition. So at this point you have two choices.

  • A) Wipe the partition out. (Note, if you used Diskpart to setup the drive instead of the windows 2008 setup program, this won’t exist anyway.)
  • B) Find a workaround for the VSS snapshot.

I didn’t really want to do option A yet as I’m not fully sure if that’ll have any impact down the line so I decided on option B.

I got pretty familiar with the VSSADMIN command while working with Hyper-V and backups so I knew that it could be used to redirect VSS snapshots to larger partitions. The problem I ran into is that it didn’t like the fact that the System Reserved partition didn’t have a drive letter. So I did the quick fix and used Disk Management to assign it a random drive letter – in this case P:

Then a quick drop to a command prompt and run vssadmin list volumes

C:\Users\Administrator>vssadmin list volumes
vssadmin 1.1 – Volume Shadow Copy Service administrative command-line tool
(C) Copyright 2001-2005 Microsoft Corp.

Volume path: P:\
Volume name: \\?\Volume{a2b716d3-8c1f-11de-a5ed-826d6f6e6973}\
Volume path: C:\
Volume name: \\?\Volume{a2b716d4-8c1f-11de-a5ed-826d6f6e6973}\
Volume path: D:\
Volume name: \\?\Volume{75c2418c-8c0e-11de-ae3c-001143dd2544}\

You’ll note there’s an entry for all your partitions. Now we set up a ShadowStorage for P:\ (100MB partition). ShadowStorage basically sets aside space on a volume to store snapshots of a volume. In this case I’m going to store snapshots of P: on D:

vssadmin add shadowstorage /For=P: /On=D: /MaxSize=1GB

And you have to put a MaxSize so I picked 1GB.

Now run vssadmin list shadowstorage to confirm the link has been set up.

C:\Users\Administrator>vssadmin list shadowstorage
vssadmin 1.1 – Volume Shadow Copy Service administrative command-line tool
(C) Copyright 2001-2005 Microsoft Corp.

Shadow Copy Storage association
For volume: (P:)\\?\Volume{a2b716d3-8c1f-11de-a5ed-826d6f6e6973}\
Shadow Copy Storage volume: (D:)\\?\Volume{75b2419c-8c5e-11de-af3b-001143dd23
44}\
Used Shadow Copy Storage space: 0 B (0%)
Allocated Shadow Copy Storage space: 0 B (0%)
Maximum Shadow Copy Storage space: 1 GB (4%)

If you have any other volumes configured for Shadow Copies you’ll also see them listed there. (i.e. If you enabled “Previous Versions” for a file share, etc)

At this point you’re done. I was able to do a successful backup of the server with the AOFO (Advanced open file option) enabled after making this change. My backup seemed a bit slow but it is an older server so I can’t be sure if speed was a machine issue or an R2/Symantec issue.

Categories: 2008 R2 Tags: