There are two physical servers on which we want to install MS SQL 2008 and our application. Our application is using DB in separate *.mdf file. Our application works only on one server at the point of time.
Can we create this file (*.mdf) on the DFS? Will this file be the same if we start our application on second server?