Re-install MDAC 2.6

I currently have SQL 2000 SP2 and MDAC 2.6 SP2 on our
database server. I am testing the process to go to
SP3a and MDAC 2.71a.
Once at SP3a and MDAC 2.71a, I tested reverting back to
SQL SP2 and MDAC 2.6 SP2 by uninstalling SQL 2000,
reinstalling SQL 2000 and SP2. However MDAC did not
revert back to 2.6 SP2. It stayed at 2.71a.
What is the proper procedure to get back to MDAC 2.6 SP2?
"Mark Gozick" <mgozick@.diamondtriumph.com> wrote in message
news:0b9401c4ac78$39e7c4c0$a301280a@.phx.gbl...
> I currently have SQL 2000 SP2 and MDAC 2.6 SP2 on our
> database server. I am testing the process to go to
> SP3a and MDAC 2.71a.
> Once at SP3a and MDAC 2.71a, I tested reverting back to
> SQL SP2 and MDAC 2.6 SP2 by uninstalling SQL 2000,
> reinstalling SQL 2000 and SP2. However MDAC did not
> revert back to 2.6 SP2. It stayed at 2.71a.
> What is the proper procedure to get back to MDAC 2.6 SP2?
>
You might need to rebuild your server -- as I recall, there is no clean way
to remove, or down-level MDAC.
Steve

reindexing, rebuilding, etc

hi, new to sql server (2000)..in my previous database, we had to do
maintenance on a regualr basis...reindexing tables, rebuilding, etc...our
database is relatively small (8G)but the reindexing in sql server is done in
minutes, whereas in our old system it used to take up to 4 hrs...Is sql
server that fast or am I doing something wrong?
also, what routines are recommended for regular maintenance and should I do
individually or create a plan?
Thanks,
GerryUse the code found in Books Online, DBCC SHOWCONTIG for reindexing, and read
http://www.microsoft.com/technet/pr...n/ss2kidbp.mspx
first.
As for the other things:
Backup schedule and types is determined by the owner of the system.
I prefer to do DBCC CHECKDB as often as I can. I prefer to do it as often as
I do db backup. This
was, if I get a corruption, I can do a log backup, restore the most recent d
b backup and all
subsequent log backups and the corruption probably not re-introduced by rest
oring the log backup.
Your mileage will vary, so just put in some common sense into planning these
things.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Gerry M" <GerryM@.discussions.microsoft.com> wrote in message
news:8295C0D3-477A-454C-92E9-51EE95D9E435@.microsoft.com...
> hi, new to sql server (2000)..in my previous database, we had to do
> maintenance on a regualr basis...reindexing tables, rebuilding, etc...our
> database is relatively small (8G)but the reindexing in sql server is done
in
> minutes, whereas in our old system it used to take up to 4 hrs...Is sql
> server that fast or am I doing something wrong?
> also, what routines are recommended for regular maintenance and should I d
o
> individually or create a plan?
> Thanks,
> Gerry|||Thank you very much.
"Tibor Karaszi" wrote:

> Use the code found in Books Online, DBCC SHOWCONTIG for reindexing, and re
ad
> http://www.microsoft.com/technet/pr...ver/default.asp
> http://www.solidqualitylearning.com/
>
> "Gerry M" <GerryM@.discussions.microsoft.com> wrote in message
> news:8295C0D3-477A-454C-92E9-51EE95D9E435@.microsoft.com...
>|||Gerry M wrote:
> hi, new to sql server (2000)..in my previous database, we had to do
> maintenance on a regualr basis...reindexing tables, rebuilding, etc...our
> database is relatively small (8G)but the reindexing in sql server is done
in
> minutes, whereas in our old system it used to take up to 4 hrs...Is sql
> server that fast or am I doing something wrong?
> also, what routines are recommended for regular maintenance and should I d
o
> individually or create a plan?
> Thanks,
> Gerry
Hi Gerry... I have a script that I run that checks the fragmentation of
all my indexes, and rebuilds those that are badly fragmented. My site
is currently "in limbo", but you can obtain the script from Google's
cache. Search for
"www.realsqlguy.com/twiki/bin/view/RealSQLGuy/DefragIndexesAsNeeded"
Tracy McKibben
MCDBA
http://www.realsqlguy.com