I have checked percent_complete and Estimated_COmpletion_time for my large table during index creation. It shows both columns are zero.

Is there any other way can find the index progression?

Hi,

I am having the same issue with my subscriber lately. However, My Subscriber is in simple recovery model. Still the log file is getting full. Even if try shrinking...

😛

I have got the answer a few minutes ago.

BTW, SQL server does not start as tempdb recreation during startup use model settings. SO it's risk of not having backup for...

What is the impact if model db is crashed?

If tuf file missing makes logshipping does not work properly. Why can't we just take the full backup and restore on secondary and start the functionality as usual.

Let me...