trasnaction log started stays block by full backup for 2 hrs

[alex]

Hello everybody..

I have 40 GB database with following
backup plan
1. transaction log backup every 15 min
2. full backup on disk once every day

Scenario
Full backup started at 2 AM
transaction log started at 2:15 AM

Full backup complited at 4 AM
transaction log backup
complited at 4:03 AM

Here is my questions
Up to what point of time I will have
transaction log ?

When I use sp_who2 I can see that transaction log backup blocked by full backup process

thank you

Alex

[MAK]

of course it will block cas' both are backups on same database.

your process should be

1. Full backup start @ 2 AM
2. Tranlog backup should start @ 4:10 AM

If you are so scared the you might lose data in those two hours then change the schedule to 1 full backup every week and tranlog backup every hour for 7 days.

or use differential backup.

[alex]

Thank Mak.

I do log shipping for this db +
management want to have full backup
everyday and minimum lost data

So, in my case transaction log will
stated only when when full backup
complited and data in tran log will
be backed up to 4 AM ?

Database size 38 GB (37.880 MB data + 20 MB log)with autoshrink option ON
and
Full backup create 36 GB backup file.
is it normal ?

[rmiao]

You should start log backup after full backup complited, 36gb full backup size sounds fine.

[alex]

thank a lot rmiao.

Is any harm of leaving everthing as is?
trn log backup is just waiting
for full backup to complete,
the is is no timeout issue.

Alex

[rmiao]

Sure, you can leave it.