Good idea! I don't think we will have an opportunity to test it as whole environment will be rebuild soon.

Thanks,

Igor

Thank you Steve! That makes perfect sense to me.

Igor

Yelena,

Thanks for your comments!

Igor

By the way, this was AllLinks table in STS_Content_TFS database. As you could guess, this is one of the TFS databases 🙂

Hello Paul!

First of all, let me thank you for maintaining your blog! I read it every day. Great information!

I did manage to fix an error by rebuilding clustered...

Although, Microsoft says problem should be fixed in SQL 2000 SP1. I am running SP4. I am puzzled.

I think that's what describes my problem:

http://support.microsoft.com/kb/282229/EN-US/

I am trying to script out my server/database objects: jobs, operators, etc. I was just providing a sample script that aslo reproduces the issue.

Thanks,

Igor

Thanks Michael!

I found the answer. The key is @force_reinit_subscription. Once I set it to 0, changes were replicated without need to rerun snapshot agent.

Thanks,

Igor

Hello kestak!

I had this resolved. It turned out that database mail extended stored procedure called from main stored procedure was in turn blocked but it. Main...

Deepak,

My original questions was about perfomance/IO footprint of simple vs. bulk-logged modes it comes to backups. I do understand the implications on data loss.

Thanks,

Igor

Sugesh,

I am comparing IO footprint between bulk-logged and simple recovery modes. As BOL states:'...Unless a backup is running, minimal logging is used under the simple recovery model. '. That made...

Sugesh,

Client configuration hasn't changed. It was working fine for quite a while. i have found article suggesting that SQL Server might generate this error while having many concurrent connections:

http://support.microsoft.com/kb/937745

I think I found the answer:

http://blogs.sqlservercentral.com/blogs/michael_coles/archive/2006/08/09/695.aspx