Application v. Error log. Will I miss anything important?

Hi,
Will I miss anything important in MS SQL Server 2000 if I monitor only MS
Windows 2000 application event log and don't monitor SQL Server error log?
What exactly will I miss?
-- Many thanks, Oskar
A comment to my previous post.
I suppose errors with severity 19 an higher ar logged into Windows
Application log, so I shouldn't miss any of them when they happen. Is that
true? Also if in SQL Server Enterprise Manager I configure a particular
message so that it is logged, I should see it in Application event log too,
right?
-- Thanks again, Oskar.
"Oskar" wrote:

> Hi,
> Will I miss anything important in MS SQL Server 2000 if I monitor only MS
> Windows 2000 application event log and don't monitor SQL Server error log?
> What exactly will I miss?
> -- Many thanks, Oskar
>

Application v. Error log. Will I miss anything important?

Hi,
Will I miss anything important in MS SQL Server 2000 if I monitor only MS
Windows 2000 application event log and don't monitor SQL Server error log?
What exactly will I miss?
-- Many thanks, OskarA comment to my previous post.
I suppose errors with severity 19 an higher ar logged into Windows
Application log, so I shouldn't miss any of them when they happen. Is that
true? Also if in SQL Server Enterprise Manager I configure a particular
message so that it is logged, I should see it in Application event log too,
right?
-- Thanks again, Oskar.
"Oskar" wrote:
> Hi,
> Will I miss anything important in MS SQL Server 2000 if I monitor only MS
> Windows 2000 application event log and don't monitor SQL Server error log?
> What exactly will I miss?
> -- Many thanks, Oskar
>

Application v. Error log. Will I miss anything important?

Hi,
Will I miss anything important in MS SQL Server 2000 if I monitor only MS
Windows 2000 application event log and don't monitor SQL Server error log?
What exactly will I miss?
-- Many thanks, OskarA comment to my previous post.
I suppose errors with severity 19 an higher ar logged into Windows
Application log, so I shouldn't miss any of them when they happen. Is that
true? Also if in SQL Server Enterprise Manager I configure a particular
message so that it is logged, I should see it in Application event log too,
right?
-- Thanks again, Oskar.
"Oskar" wrote:

> Hi,
> Will I miss anything important in MS SQL Server 2000 if I monitor only MS
> Windows 2000 application event log and don't monitor SQL Server error log?
> What exactly will I miss?
> -- Many thanks, Oskar
>

Application and database performance benchmarks

Hi
I need to develop and implement procedures to monitor performance of sql
server 2000/2005 databases and various applications. Is there a place where I
can look at for creating benchmarks .
Thanks
--
ontario, canadaChapter 1 of Inside Microsoft SQL Server 2004 Query Tuning and
Optimization has a section on creating a baseline for your workload,
and then monitoring the workload. That would be a reasonable place to
start to study the subject.
Roy Harvey
Beacon Falls, CT
On Fri, 25 Apr 2008 10:10:01 -0700, db <db@.discussions.microsoft.com>
wrote:
>Hi
>I need to develop and implement procedures to monitor performance of sql
>server 2000/2005 databases and various applications. Is there a place where I
>can look at for creating benchmarks .
>Thanks

Anyone Use Live Vault?

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
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...
> 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[vbcol=seagreen]
> 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
>

Anyone Use Live Vault?

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...
> > 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
> >
> >
>

Anyone Use Live Vault?

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]
>