Hi Everyone,
I'm investigating a software called Live Vault (http://www.livevault.com)
whose purpose is to continuously monitor and record changes in a SQL Server
database, at the database file level, and periodically send these changes to
a remote server where they're applied to matching files. In essence, it's
kind of up-to-the-minute backup of the database.
I am unsure about how this software is going to perform and/or affect the
database and I'm very interested in hearing from anyone who has experience
with this software.
Any information, thoughts and opinions regarding this tool is greatly
appreciated.
LouHi
They do not state on their case studies exactly what OS's and Database
products are supported. Not a word about SQL Server on their site.
Ask the vendor if they have certified their product for SQL Server.
And don't forget, picking up the bits off disk, shipping them over a
connection, does induce performance limitations, and if your data were to go
corrupt on the local drive, the corruption is faithfully copied to them.
A service like this does not eliminate the need for regular Database and Log
dumps.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Louis Marchand" <lmarch@.safetrans.com> wrote in message
news:eooNWKQTFHA.4056@.TK2MSFTNGP15.phx.gbl...
> Hi Everyone,
> I'm investigating a software called Live Vault (http://www.livevault.com)
> whose purpose is to continuously monitor and record changes in a SQL
> Server
> database, at the database file level, and periodically send these changes
> to
> a remote server where they're applied to matching files. In essence, it's
> kind of up-to-the-minute backup of the database.
> I am unsure about how this software is going to perform and/or affect the
> database and I'm very interested in hearing from anyone who has experience
> with this software.
> Any information, thoughts and opinions regarding this tool is greatly
> appreciated.
> Lou
>|||Mike,
Thank you very much for your input.
I do nightly full database backups and hourly transaction log backups during
business hours every day and copy these backups onto tape each night. This
leaves a potential one-day data loss in case of catastrophic failure.
Management sees Live Vault as a way to have an "up-to-the-minute" database
backup. Our systems group has had success using Live Vault to restore basic
user files e.g. Word documents or PDF documents, that sort of thing.
However, I am very suspicious of a product that monitors live SQL Server
data files. It sounds wonderful in theory but I've always been very leary
of the kind of bit level monitoring that's required.
I am really hoping someone on the newsgroup is using or has used the product
and could give a first hand account of their experiences. If there's anyone
out there reading this, I'd love to hear your honest assessment of the
product, any problems you've had and the support you received from Live
Vault addressing problems.
Best regards,
Lou
Louis Marchand
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:etHYsWZTFHA.1384@.TK2MSFTNGP09.phx.gbl...
> Hi
> They do not state on their case studies exactly what OS's and Database
> products are supported. Not a word about SQL Server on their site.
> Ask the vendor if they have certified their product for SQL Server.
> And don't forget, picking up the bits off disk, shipping them over a
> connection, does induce performance limitations, and if your data were to
go
> corrupt on the local drive, the corruption is faithfully copied to them.
> A service like this does not eliminate the need for regular Database and
Log
> dumps.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Louis Marchand" <lmarch@.safetrans.com> wrote in message
> news:eooNWKQTFHA.4056@.TK2MSFTNGP15.phx.gbl...
(http://www.livevault.com)[vbcol=seagreen]
changes[vbcol=seagreen]
it's[vbcol=seagreen]
the[vbcol=seagreen]
experience[vbcol=seagreen]
>
No comments:
Post a Comment