Hi,

This means that the transaction log is full and it is awaiting to do an operation.

run this statement:

Select log_reuse_wait from sys.databases where name='mydatabase'

post the value of log_reuse_wait column...

Yes, it is always better to specify file growth in MB than in %....estimate the how much the file growth would be and specify it in MB......

Yes, I agree with ALZDBA using the SQL servers new concept of INLUDED COLUMNS will be better. It will tremendosuly increase the performance of the engine 😀

What are you trying to connect? Please Check your firewall settings