Search This Blog

Friday, January 7, 2011

Does DPM Clear transaction Log when Backup?

 

The answer is Yes. A lot of people said that transaction log is only clear when perform full backup.

Well , when using DPM you can perform incremental backup on recovery point to clear the transaction log. Here is what you should do

SQL Server database

1. Change the database recovery model to Full. Use SQL Management Studio, select each database and go to Options. Change Recovery to Full.

1

On DPM Server

1. If previously you have protected, please stop the protection and reconfigure the protection of the database server.

2. Once you have complete that, every recovery point will truncate the transaction log.

3. Try create a recovery point , and you will see Full and incremental options

image

To know more, please click here