SQL Server Transaction Log Full affect on FileStream [closed]

Ask Question

Asked 4 years, 7 months ago

Modified 4 years, 7 months ago

Viewed 123 times

Closed. This question needs to be more focused. It is not currently accepting answers.

Want to improve this question? Update the question so it focuses on one problem only by editing this post.

Closed 4 years ago.

These are general question I would like to receive some inputs from experts with BLOB SQL Data.

How will SQL Server Transaction Log (.ldf file) linked to SQL Server FileStream
Is it different from general structured data processing i.e., Log Records , VLFs and write ahead Logging . I mean when the Database is with FileStream will there be any additional T Log processing ? Would like to understand more !
What is the difference between T Log and $FSLOG ?
If SQL Server T Log is full and out of drive space , it affects all Database Engine related transactions including FILESTREAM correct ?
Please explain the flow of a FILESTREAM related Database engine transaction.

Best Regards

asked Apr 26, 2019 at 10:52

Learning_Learning

1,58022 silver badges47 bronze badges

Add a comment |

0