Post reply

Report Server Blocking

  • November 8, 2012 at 7:28 pm

    #393570

    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

    #1557497

    Connect - SSRS Blocking

  • November 12, 2012 at 1:57 am

    #1558053

    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

Cookies on SQLServerCentral

This website stores cookies on your computer.

These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.

To find out more about the cookies we use, see our Privacy Policy