Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Sql logs Truncation

  Asked By: Tessa    Date: Apr 17    Category: Sharepoint    Views: 583

I have truncated the logs for my databases in sharepoint.

Is it OK to also truncate the :

FBA database
Share services
the sharepoint admin site



3 Answers Found

Answer #1    Answered By: Fidel Crane     Answered On: Apr 17

It is okay to truncate  the logs  of any databases  you don't plan on doing
"point in time" restores of. The ones you mentioned fall into that
category. Set those databases to "Simple" recovery mode. Then backup
each of their transaction logs with truncate. You have to back them up
before they'll truncate properly.

Answer #2    Answered By: Akshara Sanghavi     Answered On: Apr 17

I truncated the logs. We presently dont do point in time restores.

I was able to run a truncate  only which saved me from backing the
logs up.
Kind of strange that if you run stsadmin to backup sites that you
still need to manaual do the backup on the logs  to truncate.

but it is time to go to another backup solution other than stsadmin.
I am iaiming for doc ave.

Answer #3    Answered By: Aishwarya Dixit     Answered On: Apr 17

I think if you do farm level backups with STSADM (or Central Admin)
your logs  will be truncated. I'm not 100% positive though.

Didn't find what you were looking for? Find more on Sql logs Truncation Or get search suggestion and latest updates.