Dear All, I have doubt about DFS , Presenlty we are using DFS file sharing it is working fine. I have doubt abt SQL Database . Excample we have two SIte A,B can i replicate Site "A" SQl online databse to remote site "B" ? incase this site " A" online database down can i use remote site " B" databse with out any data loss related with SQL transection? i don't want 0 error ? is it possible . Regards Subash

Hi, DFS is not suited for databases in general, due to the nature of the file construction of dbfiles, and the advantages of DFS are lost because RDC's efficiency is based on linear changes to the files. it's most likely you would find the share would rarely, if ever, be in replication "sync". other methods are available and more suitable, depending on your goal (DR or HA or NLB/clustering or whatever): http://technet.microsoft.com/en-us/library/ms152531(v=sql.100).aspxDon

To use DFS for that, I would put a dump/backup file zipped that would be replicated. An automatic task could do it every hours in exemple. Like Don tell, for a true online sync use the SQL built-in replication.MCP | MCTS 70-236: Exchange Server 2007, Configuring