Adding non-clustered indexs to a 100 million record table SQL2005

I am about to attempt to add a compisite index to a 30 gig    100million record table while online.

You guys see any pitfalls in doing this?  I am certain this will not affect my transication log at all. Well 99% sure.    
soccerman767Asked:
Who is Participating?
 
Chris MangusConnect With a Mentor Database AdministratorCommented:
As I mentioned in your other question, this is a very heavy duty operation and I wouldn't attempt it online.  Also, if you are in FULL recovery mode it WILL affect your transaction log.
0
 
radcaesarConnect With a Mentor Commented:
No Issues, go ahead. But your create index will put a exclusive lock during its execution and I may leads to unavailability of the table at that time. So Its better to go offline for some time and perform it.

Also find some guidelines

http://msdn.microsoft.com/en-us/library/ms179325(v=SQL.90).aspx
0
 
soccerman767Author Commented:
This database is set to simple recovery mode
0
 
Alpesh PatelAssistant ConsultantCommented:
not an issue
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.