June 23, 2014 at 3:35 am
Running this query in DR server to start SQL mirroring but encountered an error below.
Query:
use master
go
alter database test set partner= N'TCP://HOSTNAME.DOMAIN.GROUP.INTRANET:5023'
go
Error:
Msg 1452, Level 16, State 6, Line 2
The partner server instance name must be distinct from the server instance that manages the database. The ALTER DATABASE SET PARTNER command failed.
Can someone help me to resolve this problem? Thanks!
June 23, 2014 at 7:32 am
With what little I know about mirroring, this may be one of those. You have to point to a database that is NOT in the same instance. Whether or not the instance name on the destination server can be the same as the instance name on the source server, I don't know, so here's the Books Online article on establishing mirroring:
http://technet.microsoft.com/en-us/library/ms188712(v=sql.110).aspx
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
June 23, 2014 at 7:49 am
1) What are the FQDNs of both your primary and secondary servers?
2) can you set up a linked server for testing and connect between them that way?
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply