November 26, 2005 at 10:50 am
When the database is operating in full recovery mode, does SQL Srvr log index creation completely in the transaction resulting in a large log? That is, does it capture the actual index pages that are created and add them to the log? If not, how does it do? Please clarify.
November 26, 2005 at 11:16 am
Also, could someone clarify one more thing: when indexes are created in the bulk-logged recovery mode, is index creation fully logged as in full recovery mode or are they minimally logged and later the changed extents for the index using BCMs appended to the transaction log backup when it is taken?
November 27, 2005 at 9:23 am
Basically, yes.
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
November 27, 2005 at 9:24 am
They're minimlly logged (just the page allocations to allow recovery/rollback to functional correctly) and then they're appended as you describe.
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply