SolutionCottage.com
Posted  20 Mar 2009 - 13:14:56

Category: SQL


cannot be reused until after the next BACKUP LOG operation.

Issue:
When you're trying to create a full text index on a database you get the following error message: "File 'index' cannot be reused until after the next BACKUP LOG operation.".

Solution:

  1. Right click the database.
  2. Choose Tasks / Back up...
  3. For "Backup Type" choose "Transaction Log".
  4. Perform the Back up.
  5. Try creating the index again.



Marked as helpful by 65 users




13 comments:

8/29/2016 5:25:33 PM  Khalid  wrote:

You save my time , keep it up .


5/8/2013 8:33:09 AM  ashraful  wrote:

very helpful..thanks...


8/23/2012 4:04:02 PM  ranesh  wrote:

Thanks a lot for this help !


8/23/2012 4:03:59 PM  ranesh  wrote:

Thanks a lot for this help !


8/23/2012 4:03:55 PM  ranesh  wrote:

Thanks a lot for this help !


8/23/2012 4:03:52 PM  ranesh  wrote:

Thanks a lot for this help !


4/3/2012 2:09:29 PM  Dave  wrote:

Was going crazy over this error. Thanks for the quick and simple solution! :)


3/1/2012 10:33:10 PM  Faisal Salam  wrote:

Thank you very much, worked like a charm


8/15/2011 11:46:14 PM  Don  wrote:

Yep that did the trick, thanks for your help.


5/12/2011 2:59:53 AM  sumay  wrote:

solved. Thank u so much.


2/8/2011 10:56:03 AM  Sanjeev Kumar Sah  wrote:

very useful and excellent solution


11/19/2010 5:52:16 PM  Camilo Salgado  wrote:

Excelente solución, era mas sencillo de lo que se veia el error. Gracias por el aporte


2/8/2010 10:34:42 AM  Sanchaita  wrote:

excellent explanation









© SolutionCottage 2008-2011 7/21/2017 3:37:11 AM