Prev: Table variable populated from stored procedure [SS2000]
Next: DataBase Backup Question
From: CLM on 25 Jan 2010 13:20
I've got a 40G SS 2005 table without indexes that I need to add a clustered
index to. I know that if I do a standard index addition, it will write out
about 40G to the log and I was hoping to avoid that. If do the ONLINE option
for building this clustered index, will it write out significantly less to
the log by any chance?
From: Jeffrey Williams on 25 Jan 2010 21:37
Nope - but, you can try changing the recovery model to BULK-LOGGED and
seeing if that reduces the amount of data recorded in the transaction log.
Remember to change the recovery model back to full after the index has been
rebuilt.

Note: the transaction log backup following this action will be very large,
probably about 40GB. Even though the transactions are not fully logged,
they still need to be backed up.

"CLM" <CLM(a)discussions.microsoft.com> wrote in message
news:9C912CDB-6B16-45E1-81F3-63A76C8BC2DF(a)microsoft.com...
> I've got a 40G SS 2005 table without indexes that I need to add a
> clustered
> index to. I know that if I do a standard index addition, it will write
> out
> about 40G to the log and I was hoping to avoid that. If do the ONLINE
> option
> for building this clustered index, will it write out significantly less to
> the log by any chance?

From: Uri Dimant on 26 Jan 2010 04:41
CLM
You can download a whitepater named OnliIndexs that describes in details
what is going on

I hope you are not going to create a wide CI and have plenty free space on
disks



"CLM" <CLM(a)discussions.microsoft.com> wrote in message
news:9C912CDB-6B16-45E1-81F3-63A76C8BC2DF(a)microsoft.com...
> I've got a 40G SS 2005 table without indexes that I need to add a
> clustered
> index to. I know that if I do a standard index addition, it will write
> out
> about 40G to the log and I was hoping to avoid that. If do the ONLINE
> option
> for building this clustered index, will it write out significantly less to
> the log by any chance?


 | 
Pages: 1
Prev: Table variable populated from stored procedure [SS2000]
Next: DataBase Backup Question