MS SQL Server - Truncating Transaction Log

Author

Truncating Transaction Log

ngorbunov via SQLMonster.com

2006-11-16, 7:12 pm

The database is transactional and I don't mind truncating the older
transactions as we have it all backed up but I don't want to truncate recent
transactions in the log.

So can you delete lets say transactions in the log that are older than 3
months?

Thanks,
Ninel

--
Message posted via webservertalk.com
http://www.webservertalk.com/Uwe/Fo...server/200611/1

Tibor Karaszi

2006-11-16, 7:12 pm

The transactions in the log file (ldf) are removed each time you perform a transaction log backup.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www. solidqualitylearning
.com/

"ngorbunov via webservertalk.com" <u9125@uwe> wrote in message news:69616785fba6e@u
we...
> The database is transactional and I don't mind truncating the older
> transactions as we have it all backed up but I don't want to truncate recent
> transactions in the log.
>
> So can you delete lets say transactions in the log that are older than 3
> months?
>
> Thanks,
> Ninel
>
> --
> Message posted via webservertalk.com
> http://www.webservertalk.com/Uwe/Fo...server/200611/1
>

Sponsored Links