List Info

Thread: Greg's Weekly quickTIP: Hooray for Transactional Integrity! More




Greg's Weekly quickTIP: Hooray for Transactional Integrity! More
country flaguser name
United States
2008-04-21 16:44:17
April 21, 2008
MCP Magazine News
http://MCPmag.com
http://MCPmag.com/rss
Greg's Weekly quickTIP: Hooray for Transactional Integrity!
More

============================================================
============
THIS ISSUE SPONSORED BY:

- Free Application Discovery Tool from Sophos
http://in
fo.101com.com/default.asp?id=49016

- Fax Purchasing Decision: Fax Server or Fax Service?
http://in
fo.101com.com/default.asp?id=49017
============================================================
============

----------->>>> NOTE: GET THIS NEWSLETTER IN
HTML FORMAT <<<<-----------

You are receiving MCPmag News in text format, but you can
now receive 
this newsletter in HTML format. To change formats, go to: 

https://newsletters.1105pubs.com/nl/URMGf.do?e=nesstosharedlog.com

----------->>>> 
---------------------------------------
<<<<-----------

IN THIS ISSUE: 
- Greg's Weekly quickTIP: Hooray for Transactional
Integrity! 
- Redmond Radio: SQL Server 2008 Goes Spatial; XP SP3 Soon?
More 
- Special Offers: Office 2007 Migration; Remote Desktop
Management 

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~

GREG'S WEEKLY QUICKTIP: Hooray for Transactional Integrity!
 
By Greg Shields

Image-level backups are a great benefit gained when an IT
environment 
moves to virtualization. These single-file backups allow the
state of 
an entire server to be restored without all the
thousand-file nastiness 
required in a traditional backup. Lose one key file with
old-school 
backups and you're staring down a road of rebuilding instead
of a 
restore. Conversely, an image-level backup consolidates that
server's 
state into one nice and tidy bundle.

All this sounds fine and well until you start to dig a
little deeper 
into the processes whereby image-level backups go about
quiescing that 
server prior to a backup. You see, pretty much every
hypervisor-based 
virtualization solution has the capability to quiesce the
server prior 
to starting the backup. This "snapshotting"
mechanism ensures that the 
restored file has file system integrity.

But there's always been a problem with transactional
databases that ride 
atop that file system. Though any traditional backup tools
could quiet 
the server, none to date could reach into that server to
tell these 
databases they needed a time out as well.

The result of this omission is that although image-level
restores 
usually get your server back on-line relatively quickly,
your Exchange, 
SQL and other transactional databases have the chance to
return to 
service in an inconsistent state. This means running the
necessary 
database utilities -- like ESEUTIL for Exchange -- to bring
the database 
back to health.

Until now. I recently discovered that VizionCore's vRanger
Pro v3.2 
includes support for directly communicating with a Windows
virtual 
machine's Volume Shadow Copy Service (VSS). This
communication allows 
the backup engine to instruct the database to pause at the
correct 
point in the backup so that the database will not return
from a restore 
in an inconsistent state.

The vRanger documentation includes an in-depth discussion of
how this
works with VSS. The process is complex and yet elegant in
its 
implementation. Now, we administrators get to shout for joy
knowing 
that with the right products our virtualized databases can
maintain 
transactional integrity -- and therefore complete
restorability -- while 
we do our nightly backups.

Comment: http://mcpmag.com/columns/article.aspx?editorialsid
=2587#post

AND NOW, FOR SOMETHING COMPLETELY DIFFERENT: Greg Wants your
Very 
Best SMS/SCCM Queries 

Query creation in SMS & SCCM is an art, and building the
very best 
queries for collections and reports is key to doing SMS
& SCCM well.
Contributing Editor Greg Shields wants to showcase your very
best 
queries for an upcoming Redmond column. Help out a fellow 
administrator and get a free Redmond T-shirt to boot! 

Greg Shields, MCSE: Security, CCEA, is an independent
author, 
instructor, and consultant based in Denver, Colo. A
contributing 
editor to Redmond magazine, MCPmag.com and a popular speaker
at 
TechMentor events, Greg?s recent book Windows Server 2008:
What's
New/What's Changed, is now available at www.sapienpress.com.

gshieldsredmondmag.com

Check out MCPmag.com's column archive for more savvy tips
and tricks 
from Jeff, Greg Shields, Chris Wolf and other frequent
contributors. 
http://mcpmag.com/columns/


============================================================
============
SPONSOR: Free Application Discovery Tool from Sophos
============================================================
============
Scan your network for VoIP, IM, games and other potentially
unwanted 
applications with the Sophos Application Discovery Tool.
What's on 
your network? 

http://i
nfo.101com.com/default.aspx?id=49016 
============================================================
============

REDMOND RADIO for Week of April 21 
Hosted by Michael Domingo

Take a quick listen to what made news last week in the world
of 
Redmond and IT:

* SQL Server 2008 Goes Spatial 
* XP SP3 Release Rumored Soon 
* Project Albany Goes Up Against Google Apps 
* PCI Publishes Customer Data Secuity Guidelines 

Plus, listen to find out how to enter the weekly Redmond 
T-Shirt Giveaway:


http://mcpmag.com/webcasts/mcpradio/radio.asp?id=288 

iTunes/iPodder listeners: Download the show automatically by
pointing 
your applet at http://mcpmag.com/rs
s/podcasts/. 

Problems listening to the podcast? Write to mdomingo1105media.com 
and describe the problem to get help. We want you to listen
if you 
want to hear it! 

============================================================
============
SPONSOR: Fax Purchasing Decision: Fax Server or Fax
Service?
============================================================
============
Whether you want to upgrade an existing fax server or
integrate 
production faxing with an application, using an automated
fax solution 
can help you better manage fax activity. This paper outlines
key 
factors to consider when determining whether to go with a
fax server 
or fax service. 

Get it today. http://in
fo.101com.com/default.asp?id=49017
============================================================
============

SPECIAL OFFERS FOR MCPMAG.COM READERS: 

** White Paper: "Migration to the 2007 Microsoft Office
System: 
   A Roadmap for Success"
   
This white paper examines the issues presented and best
practices for 
migration to the 2007 Microsoft Office system.

Now in the Tech Library! 
ht
tp://mcpmag.com/techlibrary/resources.asp?id=476

** Webcast: "Extending the Reach of Desktop Management
to...Everywhere!" 

In this free webcast, Greg Shields will talk about the
problems of 
remote management outside the LAN and how today's needs can
be met 
with technologies like Intel's VPro and the Kaseya
Management System. 

On-Demand Webcast -- Watch it Today! 
http://i
nfo.101com.com/default.aspx?id=48403

** Discounts on Windows 2008/Books at Amazon.com

Now that Windows Server 2008 is available, there are gobs of

resources to help you deploy at Amazon.com. Check out
"Introducing 
Windows Server 2008" http://tinyurl.com/3ca5k9 by Mitch Tulloch and 
the Microsoft Windows Server Team (Microsoft Press) and
"Windows 
Server 2008 Unleashed" http://tinyurl.com/3ca5k9 from Rand Morimoto 
et al. (Sams). Dozens more at deep discount at Amazon.com. 

You can also order Windows Server 2008 Standard Edition with
5 CALs 
http://tinyurl.com/3yk9qx along with the Windows Server 2008 
Resource Kit http://tinyurl.com/2l7w7m , both at less than retail. 

More Windows Server 2008 resources at Amazon.com. 

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~

FREE MAGAZINE OFFER
Sign up today for a free yearly subscription to Redmond
magazine! Each 
issue brings you hands-on problem-solving advice, tactical
tips, 
real-world reviews, news analysis and strategic insights.
Start or 
continue your FREE subscription now! 
https://subscribe.1105pubs.com/sub/MI?WP=N
EWFREE&TC=1&P=enews1
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~
NEWSLETTERS
Sign up now for all of our FREE newsletters.

https://newsletters.1105pubs.com/nl/URMG.do?pc=R07NL
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~

CONTACTING MCPMAG.COM:

NEWSLETTER FEEDBACK: Michael Domingo, Editor
Contact: mdomingo1105media.com 

ADVERTISERS -- Want to sponsor this newsletter? Contact 
Matt Morollo at mmorollo1105media.com

Microsoft Certified Professional Magazine
Redmond Media Group
16261 Laguna Canyon Road, Suite 130 
Irvine, CA 92618-3608
Phone 949-265-1520
Fax   949-265-1528

Newsletter problems: RED1105service.com    

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~
UNSUBSCRIBE OR CHANGE E-MAIL ADDRESS:
https://newsletters.1105pubs.com/nl/URMGf.do?e=nesstosharedlog.com
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~

To review our Privacy Policy, visit our Web site at 
http://www.1105
media.com/privacy.aspx

Copyright 2008 1105 Media, Inc. MCPmag.com News may only be

redistributed in its unedited form. Written permission from
the editor 
must be obtained to reprint the information contained within
this 
newsletter. mdomingo1105media.com

[1]

about | contact  Other archives ( Real Estate discussion Medical topics )