Online Log Size

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?
0
Utf
1/25/2010 6:20:01 PM
sqlserver.programming 1873 articles. 0 followers. Follow

2 Replies
836 Views

Similar Articles

[PageSpeed] 29

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@discussions.microsoft.com> wrote in message 
news:9C912CDB-6B16-45E1-81F3-63A76C8BC2DF@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? 

0
Jeffrey
1/26/2010 2:37:09 AM
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@discussions.microsoft.com> wrote in message 
news:9C912CDB-6B16-45E1-81F3-63A76C8BC2DF@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? 


0
Uri
1/26/2010 9:41:50 AM
Reply:

Similar Artilces:

Help with online services in money Plus
Ok I have two problems. 1. I have two accounts setup to use MSN Bill Pay and I want to add a new account to this service and I don't remember how to do this and have searched all over and can't find the anwser. I have added the account online in bill pay and confirmed it but can't get the EPAY option in the account in Money Plus 2. How do you modify an account's details once you use it to pay an online bill. I have an account that I need to change the account number and it will not let me. I have another that I can't change the address. Here is what I do: ...

Very odd Modeless Dialog Window Size problem
Hello community, I have a very strange problem with the size of a modeless dialog window (it actually is a status window derived from CDialog). The dialog window is inside an own UI thread in a dll. I have written the all of the dll, but not the application calling my dll. I do not have the source of the application, neither a handle to its window. When I debug my dll, I have set the executable for the debug session in VC++, so VC++ runs the application when I press F5. In this case, the dialog window looks fine. However, when I start the application from the start menu (not from VC++), the...

log in error
When I sign in to Microsoft Money (2002) I get an error "Money is unable to verify sign in. Money will now try to log you using Work Offline sign in. Some online features, such as background banking, will be unavailable because of network problems. To use these online features, please close Money and try to sign in again later." Help! Everytime I try I get the same error message. What am I doing wrong and can anyone help? ...

Online Version
I would like an online version that is very similar to the CD ROM Version. Quicken started offering an online version only recently. This means I could start using Microsoft money from any computer. My computer was broken for a few days and I was not able to use Microsoft money. ...

Log file
I have a file on the network, which is being used and modified by multiple users. Is there any way to create a log file to track details about changes made by different users. Details like username date time etc. --- Message posted from http://www.ExcelForum.com/ You can share the workbook (Tools>Share Workbook), then turn on tracking (Tools>Track Changes). Some functions aren't available in a shared workbook though, so this option might not be feasible for you. XL: Commands and Features Unavailable in Shared Workbook http://support.microsoft.com/default.aspx?id=130560 Fe...

How can I log each email like EX5.5 did?
I have Ex2003 on Win2003. How can I log each email similar to Ex 5.5 in imcdata\in OR out\archive? Thank you, Lancer 3 ...

Form size always maximized!
Hi, I've just moved to Access 2007 and I've run into a little problem. My forms are opening in maximized - that is, they take all the screen with the name tab at the top left. I'd like to have the form smaller than maximized, but if I make the form smaller, it just shows the extra as white (the background color) and the form remains 'maximized'. If I open one of my 2003 databases, the forms are smaller, as intended. But if I create a new 2007 database form or even save the database as 2003 format, the forms have the 'maximized' format. Any ideas on how to ...

Best Work at Home Jobs Online
Online jobs are an effective way of making money online without any investment. By doing online jobs one can earn a decent part time income. Companies all around the world need employees who can do their work, so they hire people and they pay them for the work they do. But there are many problems which company owners face. Like after gaining a little experience, people start to demand more pay or they just go to some other high paying company. Just Visit : http://www.yourforexmoney.com ...

Yes/No Field Size
Is there a way to increase the size of the check box for a Yes/No field? James On Wed, 27 Jan 2010 11:54:44 -0500, JamesJ wrote: > Is there a way to increase the size of the check box for a Yes/No field? > > James Why? A Yes/No (check box) field can only have a value of -1 or 0. In other words, no, you can't. -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail Check what I had in my March, 2004 "Access Answers" column in Pinnacle Publication's "Smart Access". You can read the column on-line at http://w...

smtp log
how is this person able to relay through my smtp virtual server when relay restrictions are "only the list below" and "unchecked allow all computers...." and ip address is on connection filtering deny list? #Software: Microsoft Internet Information Services 6.0 #Version: 1.0 #Date: 2006-08-25 13:56:39 #Fields: date time c-ip cs-username s-sitename s-computername s-ip s-port cs-method cs-uri-stem cs-uri-query sc-status sc-win32-status sc-bytes cs-bytes time-taken cs-version cs-host cs(User-Agent) cs(Cookie) cs(Referer) 2006-08-25 13:56:39 68.236.221.208 static-68-236...

increase icon size in quick acess tool bar, Word
how do I increase the size of the icons on the quick access toolbar in word. The icons are too small to see. All you can do is decrease the resolution of your monitor, or use the magnifying tool in the Accessibility options in Windows. On Feb 11, 9:12=A0pm, blanik <bla...@discussions.microsoft.com> wrote: > how do I increase the size of the icons on the quick access toolbar in wo= rd. > The icons are too small to see. ...

how to make cells automatically format to entered text size?
hello, i am new to excel and i would like to have it resize the cells automatically to the size of the text i entered. i know if i click on a cell and do format - line break it does it for one cell. but how can i have excel do this automatically for every cell in every workbook? thanks Frank Barenhorst email: frank.barenhorst@mailshelter.de Frank Hit CRTL + A to select all cells. Format>Alignment>Wrap Text. To make this the default for all new workbooks and sheets.... Open a new workbook. Customize as you wish. File>Save As Type: scroll down to Excel Template(*.XLT) and...

Online reconciling
During the set-up process of money, it asks for which my online bank id and password. I type it in and get an error message to the effect, " check id and password, not able to connect". Can anyone help me? ...

Unable to connect to online quote server
I'm not getting quotes this morning, is anyone else seeing this problem? Same here. Probably too much traffic. <g.m.cox.mail@gmail.com> wrote in message news:2fb8ba8a-9eab-4c3d-91a7-c63317d1e034@e38g2000yqa.googlegroups.com... > I'm not getting quotes this morning, is anyone else seeing this > problem? Having the same problem here. The message I get when checking msn network status is: HTTP Error 404.0 - Not Found Also it refers to IIs services problem and that the site does not exist. I can post the whole page is anyone is interested. JC <g.m.cox.mail@gmail....

Turn off circular logging on moving mailboxes
Hi all, I am going to move exchange 2000 mailboxes to exchange 20003 SP2 servers. I check KB328810 and it mentioned to turn off circular logging. Do need to turn off circular logging on the souce (exch2K) servers or target server(exchange 2003 servers)? Thanks a lot. Do you have circular logging enabled now? The KB actually mentions turning circular logging ON if you don't have enough disk space on your transaction log drives. >For every gigabyte of data that you move, an additional gigabyte of >transaction logs is used. Therefore, verify that you have >sufficient fr...

Online Documentation
I would like to know if there is a web site out there where have implemented online documentation on the WEB using VISIO. For example, displaying a diagram (workflow) where you click a shape and you are taken to another diagram or some kind of text document. I am just curious if there is such a thing. Thanks. ...

Date/ Phone log
I needed to create a spreadsheet for a phone log for my company. What it needs to do is when a long distance call is entered in, well say column B. Then the date and time the call was made needs to appear in column A. I've tried several different approaches but none work. Thanks for your help, Greg Take a look at http://www.mcgimpsey.com/excel/timestamp.html BTW - saying you've tried several different approaches but none work isn't particularly helpful - *what* methods did you try, and what didn't work? In article <AE61899F-B6C1-4BE0-9239-AA6B7602245F@micro...

Increasing logging information for IMC
After I increased the log size for the IMC in Exchange 5.5 I had repeated problems with the servce becoming inconsistent. I reverted back the settings but still IMC crashed every few days. Is it possible these events to be related or I should look in some other causes. Thank you ...

Attachment size becomes much bigger from Office 2000 to Office 200
Problem: When a user sends an attachment from Office 2000 to Office 2003, the attachment size becomes much bigger. Such as a 5MB attachment will turn out to be a 60MB attachment. It happens only on Word and Excel document. However, there is no problem when sending an attachment from Office 2003 to Office 2000. Try resaving in 2003 format. This is a guess but Excel may be trying to hedge it's bets by saving in 2000 format, xp format, 2003 format, etc all in one file because it is unsure of which format to choose thereby vastly enlarging the size of the file. If you save with ...

log files pour in on sundays
Every sunday, the log files on my exchange 2000 box fill up. It only happens on sundays. I backup mon-friday and there may be 20-30 log files, but on sundays there or about 4000. has anyone had experience with this? Thanks, Matt HAVOK <> wrote: >Every sunday, the log files on my exchange 2000 box fill up. It only >happens on sundays. I backup mon-friday and there may be 20-30 log >files, but on sundays there or about 4000. has anyone had experience >with this? What's different on Sunday? Do you have anything scheduled to run then that doesn't run on the othe...

File Sizes
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 My company has an excel spreadsheet to track payroll for 88 guys. It has autofilters to sort by job code. It has the seven days of the week. It has colum for bonus work and one for incentive pay. It totals the pay for the week. Simple. However, now that I am required to save the file to our shared drive 20 miles away on the network, the 2.7 mb file size is a pain. Is there a way to hold the basic structure of the sheet but send only the data to a file that would be smaller? ie... 200 k. Martin -----BEGIN PGP SIGNATURE----- Version: PGP 8...

Online Tool
Greetings I currently have Outlook 2003 and I would like to be able to modify my calendar from school / class / library etc. Is there an Online - Calendar that automatically synchronizes with outlook? Something like Yahoo Calendar ( but i'm not sure if Yahoo Calendar can synch. to outlook ) Thank you -- Emory Carsten You can try Microsoft Office Outlook Live to see if that is what you need.http://www.slipstick.com/outlook/mool.htm --� Milly Staples [MVP - Outlook] Post all replies to the group to keep the discussion intact. All unsolicited mail sent to my personal account w...

What are COMPAPI, DtaStor and PT enties in log
In examining WindowsUpdate.log I noticed the following entities. COMAPI, AU, PT, Agent, DnldMgr, Handler, DtaStor Near as I can figure: AU = Automatic Update WU = Windows Update Agent = WU Agent DnlMgr = WU Download Manager Handler = WU Install 'handler' : Actually installs the update But I'm not sure on the following; COMAPI = ? DtaStor = ? PT = ? Does anyone know what the COMAPI, DtaStor and PT entities are? I found the answer in MS Article 902093. How to read the Windowsupdate.log file http://support.microsoft.com/kb/902093 "MrSoft...

Where can I find online appointment scheduling template?
Hello everyone. I'm looking for a template for publisher 2003 that allows a client to setup a date and time for a hair appointment online. For example; The client goes to the webpage and keys in the following: 1. Name 2. Date 3. Time 4. Hair style they desire. 5. Then either an email is sent to the shop or there is an online database that allow the hair stylist to login and see who's scheduled to see them for the next week, 2 weeks month etc. Thanks to all that comment, ...

Limiting size of posts in NGs
Happy New Year all - Is there any way to limit size of posts in NGs to 500 Kb?? One of the NGs I co-moderate sent this out (we're trying to help users know how to limit size if they use OE): "Effective immediately the new size limit for any post is 500 Kb. All newsreaders add almost 40% to the original file size when posted (either embedded or attached). Consequently a 360Kb post will post as 493 Kb. Anything larger than 500 Kb will be rejected." Thank you - again. -- Happiness is not something you experience, it's something you remember (Oscar Levant).&q...