The transaction log for db BizTalkMsgBoxDb is full.

SQL Server returned error string: “The transaction log for database ‘BizTalkMsgBoxDb’ is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases”.

Solution:

[sql]

sp_helpdb ‘BizTalkMsgBoxDb’

ALTER DATABASE BiztalkMsgBoxDb

SET RECOVERY SIMPLE;

GO

DBCC SHRINKFILE (BiztalkMsgBoxDb_log, 1);

GO

sp_helpdb ‘BizTalkMsgBoxDb’

GO

ALTER DATABASE BiztalkMsgBoxDb

SET RECOVERY FULL

GO

[/sql]

1,210 thoughts on “The transaction log for db BizTalkMsgBoxDb is full.”

  1. I wish to show my respect for your kind-heartedness supporting those individuals that need assistance with the subject. Your special commitment to passing the message around was exceedingly practical and has in most cases allowed professionals just like me to reach their goals. Your personal valuable useful information means a great deal to me and far more to my colleagues. Many thanks; from everyone of us.

  2. Admiring the time and effort you put into your blog and
    in depth information you present. It’s nice to come across a
    blog every once in a while that isn’t the same unwanted rehashed material.

    Wonderful read! I’ve bookmarked your site and
    I’m adding your RSS feeds to my Google account.

  3. you are in point of fact a excellent webmaster. The web site loading speed is
    incredible. It sort of feels that you are doing
    any distinctive trick. Furthermore, The contents are masterpiece.

    you have performed a magnificent process on this matter!

  4. Hello there! This post could not be written any better!
    Reading through this post reminds me of my old room mate!
    He always kept talking about this. I will forward this write-up to him.
    Pretty sure he will have a good read. Thank you for sharing!

Leave a Reply

Your email address will not be published. Required fields are marked *