use-revolution Digest, Vol 12, Issue 69

[Mark D. Clark]

Hi Jay,

I work for a SAN company and our product has snapshot capability  
(unlimited snaps per volume, actually). We do support VSS but MS  
doesn't just yet for SQL server. Once it does, no worries, but there  
might still be times when pausing sql and doing something different (as  
might be possible from rev) could be interesting. I was really hoping  
someone on the list might have already had experience with this.  
Unfortunately I don't have SQL server handy  so it's a bit difficult to  
work it out.  Plus, as you can imagine, this is something I am doing on  
my own time and doesn't represent my company, blah blah blah. I did  
find a couple of links about sql-dmo but haven't gone very far (no  
server to play with).

http://www.microsoft.com/technet/prodtechnol/sql/2000/books/ 
c03ppcsq.mspx#EJAA
http://doc.ddart.net/mssql/sql70/9_dmor19_5.htm
http://doc.ddart.net/mssql/sql70/startp_5.htm

mark



On Sep 20, 2004, at 4:00 PM, use-revolution-request at lists.runrev.com  
wrote:

> Message: 13
> Date: Mon, 20 Sep 2004 15:49:20 -0400
> From: "Jay Madren" <JaysLists at triad.rr.com>
> Subject: RE: sql server redux
> To: "How to use Revolution" <use-revolution at lists.runrev.com>
> Message-ID: <NDBBIGHFGLCPMCDMJOHHGELKEBAA.JaysLists at triad.rr.com>
> Content-Type: text/plain;	charset="us-ascii"
>
> Mark,
>
> I haven't investigated SQL Server snapshot backups before, but a quick  
> look
> through the docs and their web site seems to indicate that there's  
> probably
> some API or DMO call used to "freeze" the database at the time of the
> snapshot.  The MSDN site refers to some VC++ examples, but I couldn't  
> locate
> them.  If you could find them, then you should be able to determine  
> how they
> are accomplishing it.
>
> I'm curious, why do you want to do a snapshot backup instead of the  
> normal
> backup method.  I understand that it's intended for high availability
> scenarios and supposed to have minimal impact on the server, but you  
> have to
> have the right equipment to pull it off (3 way mirror or something like
> that).  Is this what you're working with?
>
> Jay Madren