Managed World

I have a question on the Transactional NTFS support in Windows 2008.

I am working on a server side application which currently uses C# .NET 2.0 and Win 2003 server. The system writes the info to the SQL server 2005 database and writes the corresponding info on to the network attached file storage. The information from these 2 different data stores need to be in sync at all the times. This is a classic use case where DB and file system operations need to happen as one atomic operation inside a transaction.

Until now, not being able to make these 2 operations as one transactional atomic unit was turning out to be a challenge and then I came across references on Transactional NTFS (TxF) support in Vista and Win 2008 server at http://msdn.microsoft.com/msdnmag/issues/07/07/NTFS/default.aspx?loc=en. Upgrading from Win 2003 to Win 2008 seems promising for our system because of the TxF support. I have couple of questions on TxF usage on Windows 2008 server.

- We are using network attached file storage. Is TxF supported in a distributed transaction use case like ours where file IO operations are done on the network attached file storage (remote file storage)?

- The MSDN documentation at http://msdn2.microsoft.com/en-us/library/aa365677.aspx says that distributed transactions against remote file systems is not supported for Vista. What about Windows server 2008?

I will really appreciate your response.

-amit