February 23, 2011 at 3:17 am
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 box
Application Server
DB server (10.100.1.98) cloned and given a new IP (10.102.1.12).
Both Servers have exatly 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.
I would like to undestand why this is happenning 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 adresses and different names BUT SQL instance as previously mentioned is the same.
Thanks
Jorge
February 25, 2011 at 1:39 am
Hi,
check if the server name of the sql server have been also renamed.
Check this with select @@servername.
It should be <Servername>\<Instancename>.
If the servername differs from the machine name rename it with following script and replace old_name, new_name and instancename:
sp_dropserver 'old_name\instancename'
GO
sp_addserver 'new_name\instancename', local
GO
Check again if the @@servername is now set correctly.
After this you can try again mirroring ... 🙂
Greets
pitcher
[font="Arial"]Kind regards,
Patrick Fiedler
Consultant
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply