SCVMM 2012 now Release Candidate
Grab it here !!
Grab it here !!
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à !
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.
Awesome video to understand the complexity behind Facebook.
The comment about having 35 TB of logs everyday is simply breathtaking.
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 !
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’
First download this on your server :
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′
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 !
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 !
I don’t usually do this…but it may help some other admins out there !!
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
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.
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.