Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
raylward102
Starting Member
4 Posts |
 Posted - 2009-12-23 : 00:20:36
|
| 'm very new to SQL. We recently upgraded from pervasive to SQL 2005 for accpac advantage series accounting software. We set up the SQL2005 with standard options. AFter everything was setup perfectly; we decided to replicate the install at another site(in a another state connected by vpn). After setting up the remote server (both servers belong to the same domain) I backed up a database from server A and restored it to server B. After restoring the backup on server B; I began to test the accessiblity of the data. Thats when I noticed that I could create a customer in the database stored on server B; and at the same time; go and see that newly created customer appearing in my SQL DB on server A. I did not intentionally set up up mirroring, but seem to have that kind of thing happening. I don't want mirroring!!! I set up default SQL server configurations for both servers. Is this because the DB's on both servers have the same name, in the same domain. I'm totally freaked out here. I did't check to see if the first server updated the second. I was already scared when I saw it happen the from b to a. ANy idea's please!! |
|
|
raylward102
Starting Member
4 Posts |
Posted - 2009-12-23 : 18:24:50
|
| solved my own problem....the accpac database utility was still pathed out to the remote server.........cool way to mirror the db though....except for the slowness. |
 |
|
|
|
|
|
2 sql2005 servers across vpn appear to mirror eac