August 1, 2012 at 10:52 am
Hi All,
Can you please help me out from this..
Client is asking me to setup some scripts on SQl Server 2000 as follows..
Setup script to monitor necessary items, such as
1* space usage
2* DB down
for SQL Server 2000
I have script but which are only working on 2005 [when ever Database goes offline and Space usage alerts].But in SQl server 2000, I didn't get these type of scripts in any of the sites.Please help me on this..
Thanks in Advance,
Vamshi.
August 1, 2012 at 11:13 am
There is a large variety of ways to do this, but I imagine there are some constraints in your environment.
August 2, 2012 at 2:13 am
a Server being down or a Database being down does not in itself raise an alert, so your script would have to execute regularly, and check against a list of known servers, and databases on those servers.
It could be something as simple as a scheduled task, or if you have it, get MOM/SCOMM to do it for you.
I have not used SQL 2000 in quite a while, but if you have a script for sql2005, you should be able to reverse engineer it for SQL 2000 with a little googling.
Rather than ask folks here to create a script for you, why dont you post your SQL 2005 script and people can advise what you need to change to make it SQL2000 compatable.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply