jeudi 19 février 2015

Is It possible to a rebuild Index with out taking instance offline?

I have this one index that's 85.71% total fragmentation and 55.35% page fullness...why not lets start with an index rebuild, but I get this error.


Can this be done without taking my instance offline?



TITLE: Microsoft SQL Server Management Studio
------------------------------

Rebuild failed for Index 'idx_last_success_download'. (Microsoft.SqlServer.Smo)

For help, click: http://ift.tt/1ALkNN3

------------------------------
ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------

Lock request time out period exceeded. (Microsoft SQL Server, Error: 1222)

For help, click: http://ift.tt/1ALkO3i

------------------------------
BUTTONS:

OK
------------------------------

Aucun commentaire:

Enregistrer un commentaire