how about a NULL set for an answer ?

Which Isolation Level are you using to execute the command in VB.Net ?

Isolation Levels explained by Kendra Little

That is great news.

Thank you for the feedback.

Would it be possible to post a snippet of the log that hinted you towards TraceFlag 3057 ?

Are you using a Listener to connect to ?

If not, chances are your db switched to primary on the other node.

Do you have (failed) login monitoring ( xEvents )...

The question is:

• Is it still possible to produce the backup from the original database ?

  • if yes:  please do and try to restore again ( use the trace flags...

• Check the sql server ERRORLOG file
• enable trace flag 3004 to show the internal backup/restore operation and more.

  This is an undocumented TF, so remove as soon as possible !

It's always nice to provide usable object models (ddl) with sample data and the actual queries, isolation levels, ....

That is indeed the best practice

That's exactily the reason why we scan and alert for such usage (use of own database name).

Do this for as well sprocs, views, functions, ...)

"Sloppy development" like "start from object...

HTH

Please provide feedback on your progress and solution.

The number of VLFs are to be seen per database and will be handled at startup/recovery time ( of the database, as a step in the startup of the instance...

What's the TARGET_RECOVERY_TIME and recovery interval that has been configured on your databases ?

added: How many VLFs are to be handled for your databases ?

• This reply was modified 7 months, 2 weeks ago by Johan Bijnens.

Are there indications for the slow operation in the sql server errorlog files?

Is the always on node involved with the clustered sqlserver instance ?

if yes, are you using a listener...

Is this a clustered sql server instance ?

Is this a db involved in an Availability group ?

Is query_store active ?  ( did you implement trace flags 7745 / 7752 )

What's...