Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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?

share|improve this question
add comment

2 Answers

up vote 0 down vote accepted
  • Two servers can't access the same file simulaneously
  • SQL Server doesn't allow databases on network shares

If the DFS is a "local disk" to the server than you may be able to use DFS. However, you can't have a 2nd SQL Server using it.

Typically, you'd have one SQL Server with several clients (weg a web farm) connecting to it.

If you ask because unless you have some serious reporting requirements on a busy server, just have one SQL box.

If you want this for DR purposes, then look at database mirroring

share|improve this answer
    
Thanks for answer. What do you mean "local disk"? We have disk array connected by SAS to both servers. We want to be able to start our application with the same data if first server will go down. –  Sasha Jun 17 '11 at 9:59
    
local means it appears in "Computer management". If you want this failover, then look at clustering. –  gbn Jun 17 '11 at 10:07
    
Thanks... But I don`t know is it possible to use clustering when DB and application are on the same servers... –  Sasha Jun 17 '11 at 10:16
add comment

There is a lengthy discussion on using file servers as the storage for SQL databases in KB304261. The bottom line is: don't do it unless you know exactly what you are doing.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.