Ok, I'm gonna get some weird looks for this, but It's something I want to do. I have two servers on the internet, I want to open an internet port just for each others IP, and do a SQL Server 2008 mirror over the internet.
The data isn't that important. No SS#, no credit cards, nothing like that. So this doesn't have to be overly complex.
1) Is mirror blocking? I don't want the primary server to be waiting on the secondary server to commit the data. Will it queue up stuff to synchronize? The DB is big, and there is a lot of activity, if it has to wait for it to sync up on the secondary, this wont work?
2) Even though security is not a huge concern, what are the flaws? The SQL DBs will only be open externally to each other, and is there any danger of sniffs?
Thanks in advance.