Thanks for all replies.

Unfortunately this is a live enviroment so its not possible to take db offline and bring it back.