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 |
|
unikoman
Starting Member
32 Posts |
 Posted - 2011-02-23 : 18:24:23
|
| Hi,I'm trying to setup DB mirroring between 2 SQL 2008 servers each running enterprise edition for a DR (disaster recovery) solution. The IT provider with manages hosting has carried out the following :Cloned 3 servers:DMZ boxApplication ServerDB server (10.100.1.98) cloned and given a new IP (10.102.1.12).Both Servers have exactly the same name SQL instances and same databases.While preparing to mirror a DB I noticed something odd or maybe not ?I backed up a test db(in full mode) (both servers have exact copies of a prod, test and development dbs) copied across to the new DR server tried to restore database WITH NORECOVERY option.When a flicked back to the production db server (10.100.1.98) I found the same db in restore mode there as well!!!.I would like to understand why this is happening although I have an idea but not sure if I'm right.Does the IT company which provides these servers as VMs need to clone the SQL with a different DB instance OR is there another way for me to do this ?, such as changing parameters, changing the existing db instance, installing a new sql instance?Currently both boxes have different IP addresses and different names BUT SQL instance as previously mentioned is the same.ThanksJorge |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
unikoman
Starting Member
32 Posts |
Posted - 2011-02-23 : 23:00:47
|
| Hi TaraThanks for you reply. I carried out a test. I Created a DB on prod server and it appeared on DR server. Then I deleted the DB from the DR server and it also disappeared on the production server.Any ideas on what is wrong?Thanks |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
SQL server 2008 enterprise DB mirroring