Post reply

Need for Backup of transactional log type

  • March 23, 2010 at 11:51 pm

    #220308

    Hi All,

    In one of my SQL jobs i am dropping TEXTCATALOG created for a database and while creating the TEXTCATALOG again, i get the error

    "sysft_EIS_FullTextCatalog' cannot be reused until after the next BACKUP LOG operation". If i take the backup of Transactional Log type before re-creating the TextCatalog the problem is resolved. But i need the reason why backup is required before re-creating the TextCatalog.

    Cheers 🙂

    Mani.

  • March 24, 2010 at 3:42 am

    #1138757

    Manikandan Subramani (3/23/2010)

    Hi All,

    In one of my SQL jobs i am dropping TEXTCATALOG created for a database and while creating the TEXTCATALOG again, i get the error

    "sysft_EIS_FullTextCatalog' cannot be reused until after the next BACKUP LOG operation". If i take the backup of Transactional Log type before re-creating the TextCatalog the problem is resolved. But i need the reason why backup is required before re-creating the TextCatalog.

    Cheers 🙂

    Mani.

    Check the link might be helpful for u

    http://social.msdn.microsoft.com/Forums/en-US/commserver2007/thread/307b9141-9063-4788-9673-e23b49fe6aeb

    Edit : for post correct link

    Muthukkumaran Kaliyamoorthy
    https://www.sqlserverblogforum.com/

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply