February 27, 2012 at 6:38 am
My setup
I have 2 machines (say Server1 and Server2) on which I run separate instances of MS SQL Server. The MDF file and associated log file for my database called Disso is saved on a dropbox folder. The idea is that I can then access the same database from both servers and any changes made through one is synchronised. I can successfully access the database from both machines.
My issue
I have tried adding a record to a table in the database through Server1 (using Management Studio), but when I refresh the database on Server2, the change is not reflected. The reverse doesn't work either.
What am I missing here, please?
Many thanks.
February 27, 2012 at 6:45 am
To be blunt, there's no way that will work. SQL requires full control over the files while the database is open. Also, the two files work in sync, if your sync did work and could copy the mdf while the database was open, if the mdf was ever copied before the ldf, the database would go suspect on the spot.
Even expensive SAN replication techniques don't have both databases active at a time.
Have you considered replication, transactional if one database is the master or peer-to-peer if they're equal.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 27, 2012 at 7:38 am
Thank you sir!
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply