-
trasnaction log started stays block by full backup for 2 hrs
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
-
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.
-
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 ?
-
You should start log backup after full backup complited, 36gb full backup size sounds fine.
-
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
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|