Home Forums SQL Server 2005 Administering Restore could not start DB. RE: Restore could not start DB.
Rajesh kasturi
SSCarpal Tunnel
Points: 4007
More actions
December 26, 2008 at 3:24 am
#917729
Suresh B. (12/26/2008)use postnetgoalter index all on TempLan_Details rebuild
Suresh B. (12/26/2008)
use postnetgoalter index all on TempLan_Details rebuild
go
alter index all on TempLan_Details rebuild
The below will drop and recreate the index.
DBCC DBREINDEX (TempLan_Details , '', 70)
Rajesh Kasturi