size of transaction logs shipped via MS SQL log shipping one month ago

[Former Member]

Hi,

We have a BI 7.0 system on Windows and SQL 2005 for which a DR site is configured via (standard MS SQL) log shipping.

The logs are shipped from the PR system to the DR site.

Now it has been noticed that the transaction logs backed up and shipped have increased from around a couple of GBs to 7 GBs per day.

Actual recorded data observed over the past 10 days shows only a increase of 1/2 GBs per day.

The couple of GBs were previously observed in the past month during some manual monitoring by other team mates.

I need to check and confirm whether in the past month(s) the size of the transaction logs shipped from PR to DR was really 2 Gabs. This figure is currently only based upon the verbal inputs recieved from the team mates.

Is there any way I can find this history information recorded in any place like a log?

Regards,

Rohan.

[clas_hortien]

Hi,

yes, you can retrieve the data from the msdb database:

use msdb

select database_name, backup_size, backup_start_date, * from dbo.backupset

go

Best regards

Clas