maintenanace

Hi,
we have a sqlserver 2000 server which is 24*7 running .we have to do dbcc
maintenanace but our management is not accepting for that.
Luckly in sql2005 there is a new feature called mirroring.is it possible to
do dbcc maintenance in mirroring if so what is the plan..
Please be advised
Message posted via droptable.com
http://www.droptable.com/Uwe/Forum...server/200705/1Hi
"pardhiveswar via droptable.com" wrote:

> Hi,
> we have a sqlserver 2000 server which is 24*7 running .we have to do dbcc
> maintenanace but our management is not accepting for that.
I assume that you mean DBCC DBREINDEX which is an offline operation?
>
> Luckly in sql2005 there is a new feature called mirroring.is it possible t
o
> do dbcc maintenance in mirroring if so what is the plan..
Mirroring will create a copy of your database, it will not help to maintain
the indexes, but it is a means of reducing planned/unplanned downtime
especially if you are not using hardware clustering. Features such as online
index rebuilds and partitioning should help to reduce the impact of your
maintenance operations.
Check out
http://www.microsoft.com/technet/pr...nlineindex.mspx
http://www.microsoft.com/technet/pr.../2005/spdw.mspx

> Please be advised
> --
> Message posted via droptable.com
> http://www.droptable.com/Uwe/Forum...server/200705/1
>
John|||"pardhiveswar via droptable.com" <u8956@.uwe> wrote in message
news:71b635c0e76f4@.uwe...
> Hi,
> we have a sqlserver 2000 server which is 24*7 running .we have to do dbcc
> maintenanace but our management is not accepting for that.
>
What do you need to do specifically. Sometimes there are other options.

> Luckly in sql2005 there is a new feature called mirroring.is it possible
> to
> do dbcc maintenance in mirroring if so what is the plan..
No, I don't think this will work.
But the row-versioning features may help you if you're looking at rebuilding
indices.

> Please be advised
> --
> Message posted via droptable.com
> http://www.droptable.com/Uwe/Forum...server/200705/1
>
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html|||Basically our database is about 100 GB and 24*7 is up and running.as a dba w
e
need to do some maint activity like dbcc inddedfrag or rebuild indes that ar
e
out dataed.since our database is so big indexdefrag also starts blocking jus
t
like rebuild.and more over this server acts as subscriber (replication)
so i am guessing does mirroring allows to do maintenance(reindexing)with all
the above mentioned points in 2005 ?
Greg D. Moore (Strider) wrote:
>What do you need to do specifically. Sometimes there are other options.
>
>No, I don't think this will work.
>But the row-versioning features may help you if you're looking at rebuildin
g
>indices.
>
>
Message posted via droptable.com
http://www.droptable.com/Uwe/Forum...server/200705/1|||"pardhiveswar via droptable.com" wrote:

> Basically our database is about 100 GB and 24*7 is up and running.as a dba
we
> need to do some maint activity like dbcc inddedfrag or rebuild indes that
are
> out dataed.since our database is so big indexdefrag also starts blocking j
ust
> like rebuild.and more over this server acts as subscriber (replication)
> so i am guessing does mirroring allows to do maintenance(reindexing)with a
ll
> the above mentioned points in 2005 ?
No, it will give you a copy that can be used in case of failover to maintain
availability see the links I posted in my previous reply and also
http://msdn2.microsoft.com/en-us/library/ms190202.aspx
http://msdn2.microsoft.com/en-us/library/ms177412.aspx
John|||ok thanks
John Bell wrote:
>[quoted text clipped - 3 lines]
>No, it will give you a copy that can be used in case of failover to maintai
n
>availability see the links I posted in my previous reply and also
>http://msdn2.microsoft.com/en-us/library/ms190202.aspx
>http://msdn2.microsoft.com/en-us/library/ms177412.aspx
>John
Message posted via droptable.com
http://www.droptable.com/Uwe/Forum...server/200705/1