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]
Wonderful blog! I found it while surfing around on Yahoo News.
Do you have any tips on how to get listed in Yahoo News?
I’ve been trying for a while but I never seem to get there!
Many thanks
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.
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!
Thanks for finally talking about >The transaction log for db BizTalkMsgBoxDb is full.
– pietowski.com <Loved it!
Hmm is anyone else having problems with the pictures on this blog
loading? I’m trying to figure out if its a problem on my end or if it’s the blog.
Any feedback would be greatly appreciated.
If some one needs expert view about blogging and site-building afterward i advise him/her
to pay a visit this blog, Keep up the fastidious job.
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!