Thanks Gail... logicinside22 please use Jeff's recommendation. If it fixes great else use other steps.

Source: I fixed similar issue in SQL 2012 for DB participating in AG.

Hmm... I was under impression that if log backup are taken in due interval (maybe 2 mins or so depending on application) before tlog gets full in that case database...

Hi Sam,

There are few differences but will hardly be used in day to day life. I would not consider then new functionality or difference between SSMS 2012 and 2014, It's...

2nd with MICHAEL DEPAULA

I did similar thing to do this work.

I know sometime business requirement is to see column data at specific place when user do select top 100 *...

Are you still on SQL Server 2000??? This was a know issue in SQL Server 2000 - What causes this issue is if a row gets deleted by spid 1...

This issue is caused if log back is not taken before tlog file get full. There are 2 ways to correct this issue. I am putting xxx please replace it...

Try these 2 way and share if it works...

1st way

USE master

CREATE LOGIN [NT AUTHORITY\SYSTEM] From Windows with default_database = [master], DEFAULT_LANGUAGE=[us_english]

2nd way

If this account is missing under Security/Logins then please...

Hi Lk,

I created 4 publications. 1 for table's with 1 Million or more records, 1 for table's with 500,000 to 999,999 records, 1 for table's with 0 to 499,999...

To achieve this i would create multiple publications for articles of same DB that way can limit number of atricles to be reinitilize rather than whole thing

Sanjiv

thanks for sharing this info!!!