I'm getting an error 1117 in SQL Server. Can I rebuild the extents somehow?

Neil Pike

March 4, 1999

1 Min Read
ITPro Today logo

A. It is recommended that you select/bcp out all the relevant dataand then recreate the objects concerned. However, if you want to attempt arebuild of the extents then make a backup first, and then try the followingafter putting the database into single-user mode first :-

dbcc rebuildextents (@db_id, @object_id, @index_id)

@db_id Id of the database
@object_id Id of the object to be rebuild
@index_id Id of the index to be rebuild

Alternatively you could just rename the object and leave it in the databasewith a dummy name - you won't be able to drop the object.

Sign up for the ITPro Today newsletter
Stay on top of the IT universe with commentary, news analysis, how-to's, and tips delivered to your inbox daily.

You May Also Like