November 8, 2012 at 7:28 pm
We have production issue.
Our ReportServer database is causing blocking. The dbcc inputbuffer results show: "ReportServer.dbo.WriteLockSession;1" and "ReportServer.dbo.CreateChunkSegment;1".
Does anyone know how to solve this issue?
Thanks in advance.
November 9, 2012 at 2:13 am
November 12, 2012 at 1:57 am
Hi Everyone,
I cannot restore the transaction logs after restoring the full backup.
It shows the transaction log is too early to apply. I have the following scheduled jobs to take backup files.
10:30 PM - Full Backup
11:00 PM - Transaction log
12:00 AM - Transaction log
Can't restore the 11:00 PM transaction log.
The database has mirrored database also.
Hope to hear from you SQL pro.
Thanks in advance.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply