August 1, 2012 at 11:07 pm
Thanks Robert....
So 'Local System Account' is the better way to use for SQL Server service and SQL Agent service account? for mirroring.
Pradeep
August 1, 2012 at 11:21 pm
Sorry Gail thanks for your patient response.
when I'm doing mirroring i get the error:
"The remote copy of database "test" does not exist. check the database name and reissue the command. (Microsoft SQL Server, Error: 1448)"
how to fix this issue...
Pradeep
August 2, 2012 at 12:00 am
pradeep.mohan (8/1/2012)
Thanks Robert....So 'Local System Account' is the better way to use for SQL Server service and SQL Agent service account? for mirroring.
No! A non-user DOMAIN ACCOUNT is the best to use. for example: Domain\MySQLService
August 2, 2012 at 12:10 am
pradeep.mohan (8/1/2012)
Sorry Gail thanks for your patient response.when I'm doing mirroring i get the error:
"The remote copy of database "test" does not exist. check the database name and reissue the command. (Microsoft SQL Server, Error: 1448)"
The error says that the database does not exist on the server you're mirroring to. The obvious question is whether you restored a backup of the database to the mirror server. If not, you need to do that.
See Books Online, the section on setting up database mirroring or Robert's book.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 2, 2012 at 1:03 am
No, database already there in mirroring server with restoring status.
I search in a Google there might be having port issue, i did pinging and telnet also the port (5022) is opened.
Principal database running under "SQL2005 default instance"
Mirror database running under "SQL2005 named instance"
what else need to do?
Pradeep
August 6, 2012 at 10:40 pm
Can i have any help on this...?
Pradeep
August 6, 2012 at 11:05 pm
Go through the set up process again. If you get an error, post the exact error message and show us screen shots of both databases.
August 7, 2012 at 12:14 am
Robert, again I'm getting the same error. pls find the attached error screenshots.
Pradeep
August 7, 2012 at 12:39 am
Please provide the information requested or we won't help you. Those screenshots showed me a little of the information. The mirroring dialog would have been helpful except you scribbled out everything that was on there.
Let's simplify it. Please provide the output of the following 3 queries on both servers at the point where you get the error:
Select *
From sys.databases
Where name = 'test';
Select *
From sys.database_mirroring_endpoints;
Select *
from sys.tcp_endpoints
Where type = 4;
August 7, 2012 at 1:02 am
Robert, please find the attached query result for your ref.
Pradeep
August 7, 2012 at 9:41 am
Thanks! databases and endpoitns look good. Are you following all of the steps for preparing the database?
Restoring the full backup and a log backup? Are you using T-SQL to set up mirroring or the GUI? If T-SQL, are you running the ALTER DATABASE ... SET PARTNER ... command on the mirror first before the principal?
What service account are you using for SQL Server service and does it have at least Connect permissions granted on the endpoint of the other partner?
August 7, 2012 at 10:43 pm
Yes robert, restored full backup and log backup.
I'm using GUI mode.
I'm using non user domain account for SQL Server Service and agent its having full permissions.
My doubt is : Port issue, because principal server using default instance and mirror server using named instance.
Is it having any specific port to be mentioned under SQL Server Configuration >> SQL Server Network Configuration >> TCP/IP in right side.
Pradeep
August 7, 2012 at 10:53 pm
Why is the other using a named instance? Is there another instance on the same server? If so, does it have a mirroring endpoint as well? The endpoint and IP address combination has to be unique on the server. If you have two instances using the same port and IP Address, that would explain the error because only 1 instance can listen on the port and whichever one it is is the one you are conencting to.
August 7, 2012 at 11:25 pm
So, its not possible to configure mirroring on named instance ?
Yes, we have two named instance on same server (1 default, 2 named instances)
Both (Default & named instance) endpoints is 5022 (Is it need to change endpoints to named instance)
where can i need to give port number for named instance.
Explain more....
Thanks.
Pradeep
August 7, 2012 at 11:52 pm
Yes, you just need to make sure each endpoint on the server is using a different port (or different IP address).
Viewing 15 posts - 16 through 30 (of 37 total)
You must be logged in to reply to this topic. Login to reply