-
after reload database and log
Hi all,
I have the following problem when I try to load back the database backup and transaction
log backup.
1. load last database backup ( it helps me to restore data and transaction log )
2. load transaction log backup ( since I have made log backup every 2 hours, so
I restore all of them, they helps me to re-execute the transaction )
3. the database is exactly what it should be
4. I backup the current state
5. After backup, I perform some transactions
6. after 2 hours, do the transaction log backup
7. I found that the it does help me backup log but it DOESN'T truncate the log
8. I even cannot truncate them by using enterprise manager. The logs seems dead
on the server
All the transactions have committed yet. I don't think they are belongs to uncommitted.
So, do you know why? Am i doing any wrong steps.
Much Thanks.
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
|
|