20,212 questions
Sqlserver does not support two instances using the same database files. With a SAN you can configure failover. But only one server can access the files at the same time.
How to access SQL 2014 database from common san storage
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(108.80000000000001, 67%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDN%3C/text%3E%3C/svg%3E)
DINAGARAN N
0
Reputation points
We are using windows 2012 in server A with SQL2014 in SAN Storage with "DATABASE1". For specific purpose we are using another windows 2012 server B on another network with SQL 2014 with "DATABASE2". Server A and Server B are connected with Fibre cables to SAN switch. Now we want to do both push and pull the SQL DATA from Server B to SQL Database in Server A and vice versa.
From server B I am attaching server A Database (Since the MDF and LDF files are stored in SAN storage). I am able to attached and insert some new DATA. But when i go to Server A and check the data, the inserted DATA has not updated.
Please suggest.
Windows for business Windows Server User experience Other
SQL Server Other
14,494 questions
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Anonymous2023-07-10T07:53:08.67+00:00 Hi @DINAGARAN N
You can take a look at the answers below. If it can help you, please accept it.
-
Anonymous
2023-07-26T07:52:32.2+00:00 Hi @DINAGARAN N
We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it doesn't work, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.
Sign in to comment
2 answers
Sort by: Most helpful
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(211.20000000000002, 61%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBS%3C/text%3E%3C/svg%3E)
Bruce (SqlWork.com) 77,686 Reputation points Volunteer Moderator2023-07-08T16:34:06.32+00:00 -
Erland Sommarskog 121.4K Reputation points MVP Volunteer Moderator2023-07-08T20:58:05.8833333+00:00 But only one server can access the files at the same time.
Actually, that is not 100 % true. If a database is read-only, you can attach to multiple servers. It's called Shared Scalable Database or some such. It has been in the product since SQL 2000, if memory serves. I don't think it is very commonly used. And in any case, it is not an option in this particular case.
Sign in to comment -
-
Erland Sommarskog 121.4K Reputation points MVP Volunteer Moderator
2023-07-08T20:55:43.6566667+00:00 It seems that you are working with different copies of the database files. Because you from server B would try to access the files of server A, you would find them locked, and the whole operation would fail. (And if the SAN would permit you to ignore the locks, it would be even worse - you would have corruption galore, because as Bruce says, this is not supported.)
If you absolutely think this is a fantastic idea, you first need to set the database OFFLINE on server A, attach it to server B, detach, and then set them online on Server A again. But it is not the best of ideas, and I am not sure that it is even supported. (Then again, SQL 2014 is soon of up support itself...) Better to use one of the established methods: linked server, SSIS package etc.