I have a SQL Server 2005 Enterprise Edition database table that has 768,526 rows in it with no primary key or clustered index. This database's logs are getting shipped to a disaster recovery server on an hourly basis. I need to create a clustered primary key constraint on this table; however when testing in my staging enviornment the log file gets full or I run out of disk space. What is the best approach for creating this index?
April 4, 2012 1:55 PM
April 17, 2012 7:17 PM