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, [EMAIL PROTECTED] wrote:
Message: 13 Date: Mon, 20 Sep 2004 15:49:20 -0400 From: "Jay Madren" <[EMAIL PROTECTED]> Subject: RE: sql server redux To: "How to use Revolution" <[EMAIL PROTECTED]> Message-ID: <[EMAIL PROTECTED]> 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
_______________________________________________ use-revolution mailing list [EMAIL PROTECTED] http://lists.runrev.com/mailman/listinfo/use-revolution
