Kevin Remde's IT Pro Weblog
IT Pro Resources
TechNet EventsMicrosoft Security Response CenterTechNet IT Manager Community HubMicrosoft Virtual AcademyKevin’s Evaluation Download Center
IT Pro Evangelist Blogs
Blain Barton Blain Barton's Blog@BlainBar
Brian LewisMy Thoughts on IT...@BrianLewis_
Dan Stolts IT Pro Guru Blog@ITProGuru
Jennelle Crothers TechBunny@jkc137
Keith MayerIT Pros ROCK!@KeithMayer
Kevin Remde Full of I.T.@KevinRemde
Matt Hester Matthew Hester's WebLog@MatthewHester
Tommy PattersonVirtually Cloud 9@Tommy_Patterson
Yung Chou Yung Chou on Hybrid Cloud@YungChou
SQL Server 2005 Tidbit 020
“Hey Kevin… Exchange 2003 sort of takes advantage of Volume Shadow Copy service (VSS). Other things (like the file system) can use it to make quick snapshots of data. Does SQL Server 2005 have any such capability?”
There is indeed an interface definition for something called the SQL Writer. This guide (for backup application vendors) describes how you can write to this SQL Writer in order to support using the VSS framework.
So… there is hope that soon after (or maybe even, dare I say, right away when) SQL Server 2005 ships, you should be able to purchase backup applications that take advantage of VSS.
“What about good ol’ Windows Backup?”
I really don’t know about that one. Windows Backup can use VSS for the file system, and there were limitations on how it could (or couldn’t) be used for Exchange 2003.
That’s a really good question. I’ll tackle that one in a later tidbit.
Do you know the answer? Share it here, or add a comment with a link to the solution in your own blog.
Got an IT question? Give me a comment, or contact me.