-
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
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
|
|