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 SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200705/1Hi
"pardhiveswar via SQLMonster.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 to
> 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/prodtechnol/sql/2005/onlineindex.mspx
http://www.microsoft.com/technet/prodtechnol/sql/2005/spdw.mspx
> Please be advised
> --
> Message posted via SQLMonster.com
> http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200705/1
>
John|||"pardhiveswar via SQLMonster.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 SQLMonster.com
> http://www.sqlmonster.com/Uwe/Forums.aspx/sql-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 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 just
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:
>> 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 SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200705/1|||"pardhiveswar via SQLMonster.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 just
> 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 ?
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:
>> 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
>[quoted text clipped - 3 lines]
>> so i am guessing does mirroring allows to do maintenance(reindexing)with all
>> 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
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200705/1