Disaster Recovery rehearsal

Hi,
I am performing a disaster recovery reharsal for SQL
Server with various test cases on a Test Server. I want to
corrupt the Master Database( without deleting the .ldf)
Manually and then try to recover. Which is the best way to
do this? . also Any resources on Disaster Recovery
reharsals on SQL Servers are appreciated.
Regards
ChipHi
check out following articles about disaster recovery
http://www.sqljunkies.com/HowTo/F30B1E5F-F50F-40A8-96F2-476CEAD46C79.scuk
http://support.microsoft.com/default.aspx?scid=kb;%5BLN%5D;307775
Regards,
MD
"Chip" <anonymous@.discussions.microsoft.com> wrote in message
news:f22a01c3f111$bfee2820$a501280a@.phx.gbl...
> Hi,
> I am performing a disaster recovery reharsal for SQL
> Server with various test cases on a Test Server. I want to
> corrupt the Master Database( without deleting the .ldf)
> Manually and then try to recover. Which is the best way to
> do this? . also Any resources on Disaster Recovery
> reharsals on SQL Servers are appreciated.
> Regards
> Chip|||Do you want it to go suspect or just cause a corruption in the master
database?
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Chip" <anonymous@.discussions.microsoft.com> wrote in message
news:f22a01c3f111$bfee2820$a501280a@.phx.gbl...
> Hi,
> I am performing a disaster recovery reharsal for SQL
> Server with various test cases on a Test Server. I want to
> corrupt the Master Database( without deleting the .ldf)
> Manually and then try to recover. Which is the best way to
> do this? . also Any resources on Disaster Recovery
> reharsals on SQL Servers are appreciated.
> Regards
> Chip|||hi Tibor,
Thanks for the response. what should i do to go it to
suspect(without deleting .ldf) and how to cause a
corruption. Please suggest both ways so that I can have
two test cases in hand. :-)
Sincere Regards
Chip.
>--Original Message--
>Do you want it to go suspect or just cause a corruption
in the master
>database?
>--
>Tibor Karaszi, SQL Server MVP
>Archive at:
>http://groups.google.com/groups?
oi=djq&as_ugroup=microsoft.public.sqlserver
>
>"Chip" <anonymous@.discussions.microsoft.com> wrote in
message
>news:f22a01c3f111$bfee2820$a501280a@.phx.gbl...
>> Hi,
>> I am performing a disaster recovery reharsal for SQL
>> Server with various test cases on a Test Server. I want
to
>> corrupt the Master Database( without deleting the .ldf)
>> Manually and then try to recover. Which is the best way
to
>> do this? . also Any resources on Disaster Recovery
>> reharsals on SQL Servers are appreciated.
>> Regards
>> Chip
>
>.
>|||Chip,
To make it corrupt, you can create a table and for the table hack some value
in the sysindexes table (IAM column, for instance). You need to figure out
how to do modifications against the systems tables as I don't want to put
that information in a public place.
As for suspect, read the source code for sp_resetstatus and reverse what it
does. It should work on the master database...
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Chip" <anonymous@.discussions.microsoft.com> wrote in message
news:e98501c3f154$c22ad640$a301280a@.phx.gbl...
> hi Tibor,
> Thanks for the response. what should i do to go it to
> suspect(without deleting .ldf) and how to cause a
> corruption. Please suggest both ways so that I can have
> two test cases in hand. :-)
> Sincere Regards
> Chip.
> >--Original Message--
> >Do you want it to go suspect or just cause a corruption
> in the master
> >database?
> >
> >--
> >Tibor Karaszi, SQL Server MVP
> >Archive at:
> >http://groups.google.com/groups?
> oi=djq&as_ugroup=microsoft.public.sqlserver
> >
> >
> >"Chip" <anonymous@.discussions.microsoft.com> wrote in
> message
> >news:f22a01c3f111$bfee2820$a501280a@.phx.gbl...
> >> Hi,
> >>
> >> I am performing a disaster recovery reharsal for SQL
> >> Server with various test cases on a Test Server. I want
> to
> >> corrupt the Master Database( without deleting the .ldf)
> >> Manually and then try to recover. Which is the best way
> to
> >> do this? . also Any resources on Disaster Recovery
> >> reharsals on SQL Servers are appreciated.
> >>
> >> Regards
> >>
> >> Chip
> >
> >
> >.
> >|||Poor me.
Not a expert dba to hack and crack :-(. If it is possible
to mail the procedure, I will be greatful. I need to
perform this at any cost and send the details to my boss
with step-by-step procedure :-(. Any resources pointing to
achieve this are highly appreciated.
Chip
chipsin007@.NOSPAM.yahoo.com
>--Original Message--
>Chip,
>To make it corrupt, you can create a table and for the
table hack some value
>in the sysindexes table (IAM column, for instance). You
need to figure out
>how to do modifications against the systems tables as I
don't want to put
>that information in a public place.
>As for suspect, read the source code for sp_resetstatus
and reverse what it
>does. It should work on the master database...
>--
>Tibor Karaszi, SQL Server MVP
>Archive at:
>http://groups.google.com/groups?
oi=djq&as_ugroup=microsoft.public.sqlserver
>
>"Chip" <anonymous@.discussions.microsoft.com> wrote in
message
>news:e98501c3f154$c22ad640$a301280a@.phx.gbl...
>> hi Tibor,
>> Thanks for the response. what should i do to go it to
>> suspect(without deleting .ldf) and how to cause a
>> corruption. Please suggest both ways so that I can have
>> two test cases in hand. :-)
>> Sincere Regards
>> Chip.
>> >--Original Message--
>> >Do you want it to go suspect or just cause a corruption
>> in the master
>> >database?
>> >
>> >--
>> >Tibor Karaszi, SQL Server MVP
>> >Archive at:
>> >http://groups.google.com/groups?
>> oi=djq&as_ugroup=microsoft.public.sqlserver
>> >
>> >
>> >"Chip" <anonymous@.discussions.microsoft.com> wrote in
>> message
>> >news:f22a01c3f111$bfee2820$a501280a@.phx.gbl...
>> >> Hi,
>> >>
>> >> I am performing a disaster recovery reharsal for SQL
>> >> Server with various test cases on a Test Server. I
want
>> to
>> >> corrupt the Master Database( without deleting
the .ldf)
>> >> Manually and then try to recover. Which is the best
way
>> to
>> >> do this? . also Any resources on Disaster Recovery
>> >> reharsals on SQL Servers are appreciated.
>> >>
>> >> Regards
>> >>
>> >> Chip
>> >
>> >
>> >.
>> >
>
>.
>|||You won't, to my knowledge, find any such resources. And I don't have any
ready-made scripts as I always do them as I go along. On top for the first
one is sp_configure and the "allow updates" option. As for the second one,
you need to read the source code of sp_resetstatus and make appropriate
changes (the suspect status is in the status column if
master..sysdatabases). If this makes no sense to you, you really need to
bring someone in to do these things... :-)
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Chip" <anonymous@.discussions.microsoft.com> wrote in message
news:e9d401c3f15c$1898d3e0$a301280a@.phx.gbl...
> Poor me.
> Not a expert dba to hack and crack :-(. If it is possible
> to mail the procedure, I will be greatful. I need to
> perform this at any cost and send the details to my boss
> with step-by-step procedure :-(. Any resources pointing to
> achieve this are highly appreciated.
> Chip
> chipsin007@.NOSPAM.yahoo.com
> >--Original Message--
> >Chip,
> >
> >To make it corrupt, you can create a table and for the
> table hack some value
> >in the sysindexes table (IAM column, for instance). You
> need to figure out
> >how to do modifications against the systems tables as I
> don't want to put
> >that information in a public place.
> >As for suspect, read the source code for sp_resetstatus
> and reverse what it
> >does. It should work on the master database...
> >
> >--
> >Tibor Karaszi, SQL Server MVP
> >Archive at:
> >http://groups.google.com/groups?
> oi=djq&as_ugroup=microsoft.public.sqlserver
> >
> >
> >"Chip" <anonymous@.discussions.microsoft.com> wrote in
> message
> >news:e98501c3f154$c22ad640$a301280a@.phx.gbl...
> >> hi Tibor,
> >>
> >> Thanks for the response. what should i do to go it to
> >> suspect(without deleting .ldf) and how to cause a
> >> corruption. Please suggest both ways so that I can have
> >> two test cases in hand. :-)
> >>
> >> Sincere Regards
> >>
> >> Chip.
> >> >--Original Message--
> >> >Do you want it to go suspect or just cause a corruption
> >> in the master
> >> >database?
> >> >
> >> >--
> >> >Tibor Karaszi, SQL Server MVP
> >> >Archive at:
> >> >http://groups.google.com/groups?
> >> oi=djq&as_ugroup=microsoft.public.sqlserver
> >> >
> >> >
> >> >"Chip" <anonymous@.discussions.microsoft.com> wrote in
> >> message
> >> >news:f22a01c3f111$bfee2820$a501280a@.phx.gbl...
> >> >> Hi,
> >> >>
> >> >> I am performing a disaster recovery reharsal for SQL
> >> >> Server with various test cases on a Test Server. I
> want
> >> to
> >> >> corrupt the Master Database( without deleting
> the .ldf)
> >> >> Manually and then try to recover. Which is the best
> way
> >> to
> >> >> do this? . also Any resources on Disaster Recovery
> >> >> reharsals on SQL Servers are appreciated.
> >> >>
> >> >> Regards
> >> >>
> >> >> Chip
> >> >
> >> >
> >> >.
> >> >
> >
> >
> >.
> >|||You can always change where SQL looks for the master.mdf file. That will
put you in a DR situation when you restart it. SQL will attempt to come
online and will not be able to start. It is also fixable by changing the
regkey back. I'd practice on a lab server until you are comfortable. USE
AT YOUR OWN RISK.
Christian Smith
"Chip" <anonymous@.discussions.microsoft.com> wrote in message
news:e98501c3f154$c22ad640$a301280a@.phx.gbl...
> hi Tibor,
> Thanks for the response. what should i do to go it to
> suspect(without deleting .ldf) and how to cause a
> corruption. Please suggest both ways so that I can have
> two test cases in hand. :-)
> Sincere Regards
> Chip.
> >--Original Message--
> >Do you want it to go suspect or just cause a corruption
> in the master
> >database?
> >
> >--
> >Tibor Karaszi, SQL Server MVP
> >Archive at:
> >http://groups.google.com/groups?
> oi=djq&as_ugroup=microsoft.public.sqlserver
> >
> >
> >"Chip" <anonymous@.discussions.microsoft.com> wrote in
> message
> >news:f22a01c3f111$bfee2820$a501280a@.phx.gbl...
> >> Hi,
> >>
> >> I am performing a disaster recovery reharsal for SQL
> >> Server with various test cases on a Test Server. I want
> to
> >> corrupt the Master Database( without deleting the .ldf)
> >> Manually and then try to recover. Which is the best way
> to
> >> do this? . also Any resources on Disaster Recovery
> >> reharsals on SQL Servers are appreciated.
> >>
> >> Regards
> >>
> >> Chip
> >
> >
> >.
> >

Disaster Recovery rehearsal

Hi,
I am performing a disaster recovery reharsal for SQL
Server with various test cases on a Test Server. I want to
corrupt the Master Database( without deleting the .ldf)
Manually and then try to recover. Which is the best way to
do this? . also Any resources on Disaster Recovery
reharsals on SQL Servers are appreciated.
Regards
ChipHi
check out following articles about disaster recovery
http://www.sqljunkies.com/HowTo/F30...6CEAD46C79.scuk
http://support.microsoft.com/defaul...%5BLN%5D;307775
Regards,
MD
"Chip" <anonymous@.discussions.microsoft.com> wrote in message
news:f22a01c3f111$bfee2820$a501280a@.phx.gbl...
> Hi,
> I am performing a disaster recovery reharsal for SQL
> Server with various test cases on a Test Server. I want to
> corrupt the Master Database( without deleting the .ldf)
> Manually and then try to recover. Which is the best way to
> do this? . also Any resources on Disaster Recovery
> reharsals on SQL Servers are appreciated.
> Regards
> Chip|||Do you want it to go suspect or just cause a corruption in the master
database?
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=...ublic.sqlserver
"Chip" <anonymous@.discussions.microsoft.com> wrote in message
news:f22a01c3f111$bfee2820$a501280a@.phx.gbl...
> Hi,
> I am performing a disaster recovery reharsal for SQL
> Server with various test cases on a Test Server. I want to
> corrupt the Master Database( without deleting the .ldf)
> Manually and then try to recover. Which is the best way to
> do this? . also Any resources on Disaster Recovery
> reharsals on SQL Servers are appreciated.
> Regards
> Chip|||hi Tibor,
Thanks for the response. what should i do to go it to
suspect(without deleting .ldf) and how to cause a
corruption. Please suggest both ways so that I can have
two test cases in hand. :-)
Sincere Regards
Chip.
>--Original Message--
>Do you want it to go suspect or just cause a corruption
in the master
>database?
>--
>Tibor Karaszi, SQL Server MVP
>Archive at:
>http://groups.google.com/groups?
oi=djq&as_ugroup=microsoft.public.sqlserver
>
>"Chip" <anonymous@.discussions.microsoft.com> wrote in
message
>news:f22a01c3f111$bfee2820$a501280a@.phx.gbl...
to
to
>
>.
>|||Chip,
To make it corrupt, you can create a table and for the table hack some value
in the sysindexes table (IAM column, for instance). You need to figure out
how to do modifications against the systems tables as I don't want to put
that information in a public place.
As for suspect, read the source code for sp_resetstatus and reverse what it
does. It should work on the master database...
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=...ublic.sqlserver
"Chip" <anonymous@.discussions.microsoft.com> wrote in message
news:e98501c3f154$c22ad640$a301280a@.phx.gbl...
> hi Tibor,
> Thanks for the response. what should i do to go it to
> suspect(without deleting .ldf) and how to cause a
> corruption. Please suggest both ways so that I can have
> two test cases in hand. :-)
> Sincere Regards
> Chip.
> in the master
> oi=djq&as_ugroup=microsoft.public.sqlserver
> message
> to
> to|||Poor me.
Not a expert dba to hack and crack :-(. If it is possible
to mail the procedure, I will be greatful. I need to
perform this at any cost and send the details to my boss
with step-by-step procedure :-(. Any resources pointing to
achieve this are highly appreciated.
Chip
chipsin007@.NOSPAM.yahoo.com
>--Original Message--
>Chip,
>To make it corrupt, you can create a table and for the
table hack some value
>in the sysindexes table (IAM column, for instance). You
need to figure out
>how to do modifications against the systems tables as I
don't want to put
>that information in a public place.
>As for suspect, read the source code for sp_resetstatus
and reverse what it
>does. It should work on the master database...
>--
>Tibor Karaszi, SQL Server MVP
>Archive at:
>http://groups.google.com/groups?
oi=djq&as_ugroup=microsoft.public.sqlserver
>
>"Chip" <anonymous@.discussions.microsoft.com> wrote in
message
>news:e98501c3f154$c22ad640$a301280a@.phx.gbl...
want
the .ldf)
way
>
>.
>|||You won't, to my knowledge, find any such resources. And I don't have any
ready-made scripts as I always do them as I go along. On top for the first
one is sp_configure and the "allow updates" option. As for the second one,
you need to read the source code of sp_resetstatus and make appropriate
changes (the suspect status is in the status column if
master..sysdatabases). If this makes no sense to you, you really need to
bring someone in to do these things... :-)
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=...ublic.sqlserver
"Chip" <anonymous@.discussions.microsoft.com> wrote in message
news:e9d401c3f15c$1898d3e0$a301280a@.phx.gbl...
> Poor me.
> Not a expert dba to hack and crack :-(. If it is possible
> to mail the procedure, I will be greatful. I need to
> perform this at any cost and send the details to my boss
> with step-by-step procedure :-(. Any resources pointing to
> achieve this are highly appreciated.
> Chip
> chipsin007@.NOSPAM.yahoo.com
> table hack some value
> need to figure out
> don't want to put
> and reverse what it
> oi=djq&as_ugroup=microsoft.public.sqlserver
> message
> want
> the .ldf)
> way|||You can always change where SQL looks for the master.mdf file. That will
put you in a DR situation when you restart it. SQL will attempt to come
online and will not be able to start. It is also fixable by changing the
regkey back. I'd practice on a lab server until you are comfortable. USE
AT YOUR OWN RISK.
Christian Smith
"Chip" <anonymous@.discussions.microsoft.com> wrote in message
news:e98501c3f154$c22ad640$a301280a@.phx.gbl...
> hi Tibor,
> Thanks for the response. what should i do to go it to
> suspect(without deleting .ldf) and how to cause a
> corruption. Please suggest both ways so that I can have
> two test cases in hand. :-)
> Sincere Regards
> Chip.
> in the master
> oi=djq&as_ugroup=microsoft.public.sqlserver
> message
> to
> to

Disabled/turn off Transcation logging while performing BCP opratio

Hi,
I am doing BCP in particular database.I need to improve perfommace of BCP
opration.I found some article which provide way to minmize transcation
logging.
Please let me know how I completely disabled /turn off transaction logging
for optimized & higher performance.
Regards
Amit Samria
You can't completely turn off transaction logging but you can change your
database to use BULK logging, which works well with bcp. You can do this via
Enterprise Manager or with:
ALTER DATABASE <db name> SET RECOVERY BULK_LOGGED
Jacco Schalkwijk
SQL Server MVP
"Amit Samria" <Amit Samria@.discussions.microsoft.com> wrote in message
news:33190FE5-07CB-43E0-9690-84152EE61503@.microsoft.com...
> Hi,
> I am doing BCP in particular database.I need to improve perfommace of BCP
> opration.I found some article which provide way to minmize transcation
> logging.
> Please let me know how I completely disabled /turn off transaction
> logging
> for optimized & higher performance.
> Regards
> Amit Samria
>

Disabled/turn off Transcation logging while performing BCP opratio

Hi,
I am doing BCP in particular database.I need to improve perfommace of BCP
opration.I found some article which provide way to minmize transcation
logging.
Please let me know how I completely disabled /turn off transaction logging
for optimized & higher performance.
Regards
Amit SamriaYou can't completely turn off transaction logging but you can change your
database to use BULK logging, which works well with bcp. You can do this via
Enterprise Manager or with:
ALTER DATABASE <db name> SET RECOVERY BULK_LOGGED
--
Jacco Schalkwijk
SQL Server MVP
"Amit Samria" <Amit Samria@.discussions.microsoft.com> wrote in message
news:33190FE5-07CB-43E0-9690-84152EE61503@.microsoft.com...
> Hi,
> I am doing BCP in particular database.I need to improve perfommace of BCP
> opration.I found some article which provide way to minmize transcation
> logging.
> Please let me know how I completely disabled /turn off transaction
> logging
> for optimized & higher performance.
> Regards
> Amit Samria
>|||Hi Jacco,
I found in some article that a nonlogged bulk copy can be performed if
The database option select into/bulkcopy is set to true using sp_dboption.
Is above mentioned way same as setting recovery model using alter table.
Regards
Amit Samria
"Jacco Schalkwijk" wrote:
> You can't completely turn off transaction logging but you can change your
> database to use BULK logging, which works well with bcp. You can do this via
> Enterprise Manager or with:
> ALTER DATABASE <db name> SET RECOVERY BULK_LOGGED
> --
> Jacco Schalkwijk
> SQL Server MVP
>
> "Amit Samria" <Amit Samria@.discussions.microsoft.com> wrote in message
> news:33190FE5-07CB-43E0-9690-84152EE61503@.microsoft.com...
> > Hi,
> > I am doing BCP in particular database.I need to improve perfommace of BCP
> > opration.I found some article which provide way to minmize transcation
> > logging.
> > Please let me know how I completely disabled /turn off transaction
> > logging
> > for optimized & higher performance.
> >
> > Regards
> > Amit Samria
> >
> >
>
>|||Yes. Bulk-Logged recovery in SQL Server 2000 is similar to
setting select into/bulk copy to true in SQL Server 7. Some
operations will be minimally logged with this option or
recovery model.
-Sue
On Mon, 18 Oct 2004 04:19:02 -0700, "Amit Samria"
<AmitSamria@.discussions.microsoft.com> wrote:
>Hi Jacco,
>I found in some article that a nonlogged bulk copy can be performed if
>The database option select into/bulkcopy is set to true using sp_dboption.
>Is above mentioned way same as setting recovery model using alter table.
>Regards
>Amit Samria
>"Jacco Schalkwijk" wrote:
>> You can't completely turn off transaction logging but you can change your
>> database to use BULK logging, which works well with bcp. You can do this via
>> Enterprise Manager or with:
>> ALTER DATABASE <db name> SET RECOVERY BULK_LOGGED
>> --
>> Jacco Schalkwijk
>> SQL Server MVP
>>
>> "Amit Samria" <Amit Samria@.discussions.microsoft.com> wrote in message
>> news:33190FE5-07CB-43E0-9690-84152EE61503@.microsoft.com...
>> > Hi,
>> > I am doing BCP in particular database.I need to improve perfommace of BCP
>> > opration.I found some article which provide way to minmize transcation
>> > logging.
>> > Please let me know how I completely disabled /turn off transaction
>> > logging
>> > for optimized & higher performance.
>> >
>> > Regards
>> > Amit Samria
>> >
>> >
>>

Disabled/turn off Transcation logging while performing BCP opratio

Hi,
I am doing BCP in particular database.I need to improve perfommace of BCP
opration.I found some article which provide way to minmize transcation
logging.
Please let me know how I completely disabled /turn off transaction logging
for optimized & higher performance.
Regards
Amit SamriaYou can't completely turn off transaction logging but you can change your
database to use BULK logging, which works well with bcp. You can do this via
Enterprise Manager or with:
ALTER DATABASE <db name> SET RECOVERY BULK_LOGGED
Jacco Schalkwijk
SQL Server MVP
"Amit Samria" <Amit Samria@.discussions.microsoft.com> wrote in message
news:33190FE5-07CB-43E0-9690-84152EE61503@.microsoft.com...
> Hi,
> I am doing BCP in particular database.I need to improve perfommace of BCP
> opration.I found some article which provide way to minmize transcation
> logging.
> Please let me know how I completely disabled /turn off transaction
> logging
> for optimized & higher performance.
> Regards
> Amit Samria
>

Disable Index on a Specific Partition

I'm performing incremental loads into a 13 mths partitioned table with
indexes alinged by partition. I'm trying to figure out how to disable the
indexes on a specific partition. I've researched and can't seem to fine an
option with the Alter Index Statement that would drop or disable the indexes
on just one partition(current mnth) and than rebuild the indexes for just
this one partition. Well there is a Rebuild option per partition but there
isn't one that I've come across thus far for Disable.I don't think it's possible to selectively disable or drop indexes on a
specific partition. You might instead consider switching the partition to a
separate maintenance table, drop those indexes, load, rebuild indexes and
then switch the table back in. If the target partition is empty, you don't
need to bother switching out.
Hope this helps.
Dan Guzman
SQL Server MVP
"Socrates" <Socrates@.discussions.microsoft.com> wrote in message
news:7D46AD52-ED4D-41C2-93DA-23E58CCF5A85@.microsoft.com...
> I'm performing incremental loads into a 13 mths partitioned table with
> indexes alinged by partition. I'm trying to figure out how to disable the
> indexes on a specific partition. I've researched and can't seem to fine an
> option with the Alter Index Statement that would drop or disable the
> indexes
> on just one partition(current mnth) and than rebuild the indexes for just
> this one partition. Well there is a Rebuild option per partition but there
> isn't one that I've come across thus far for Disable.

Disable Index on a Specific Partition

I'm performing incremental loads into a 13 mths partitioned table with
indexes alinged by partition. I'm trying to figure out how to disable the
indexes on a specific partition. I've researched and can't seem to fine an
option with the Alter Index Statement that would drop or disable the indexes
on just one partition(current mnth) and than rebuild the indexes for just
this one partition. Well there is a Rebuild option per partition but there
isn't one that I've come across thus far for Disable.I don't think it's possible to selectively disable or drop indexes on a
specific partition. You might instead consider switching the partition to a
separate maintenance table, drop those indexes, load, rebuild indexes and
then switch the table back in. If the target partition is empty, you don't
need to bother switching out.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Socrates" <Socrates@.discussions.microsoft.com> wrote in message
news:7D46AD52-ED4D-41C2-93DA-23E58CCF5A85@.microsoft.com...
> I'm performing incremental loads into a 13 mths partitioned table with
> indexes alinged by partition. I'm trying to figure out how to disable the
> indexes on a specific partition. I've researched and can't seem to fine an
> option with the Alter Index Statement that would drop or disable the
> indexes
> on just one partition(current mnth) and than rebuild the indexes for just
> this one partition. Well there is a Rebuild option per partition but there
> isn't one that I've come across thus far for Disable.

Disable Index on a Specific Partition

I'm performing incremental loads into a 13 mths partitioned table with
indexes alinged by partition. I'm trying to figure out how to disable the
indexes on a specific partition. I've researched and can't seem to fine an
option with the Alter Index Statement that would drop or disable the indexes
on just one partition(current mnth) and than rebuild the indexes for just
this one partition. Well there is a Rebuild option per partition but there
isn't one that I've come across thus far for Disable.
I don't think it's possible to selectively disable or drop indexes on a
specific partition. You might instead consider switching the partition to a
separate maintenance table, drop those indexes, load, rebuild indexes and
then switch the table back in. If the target partition is empty, you don't
need to bother switching out.
Hope this helps.
Dan Guzman
SQL Server MVP
"Socrates" <Socrates@.discussions.microsoft.com> wrote in message
news:7D46AD52-ED4D-41C2-93DA-23E58CCF5A85@.microsoft.com...
> I'm performing incremental loads into a 13 mths partitioned table with
> indexes alinged by partition. I'm trying to figure out how to disable the
> indexes on a specific partition. I've researched and can't seem to fine an
> option with the Alter Index Statement that would drop or disable the
> indexes
> on just one partition(current mnth) and than rebuild the indexes for just
> this one partition. Well there is a Rebuild option per partition but there
> isn't one that I've come across thus far for Disable.