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 |
|
ashishashish
Constraint Violating Yak Guru
408 Posts |
 Posted - 2009-02-02 : 05:42:27
|
| i Setup mirroring for a database....on my local PC for one instance on another instance on that same pc...but i donn understand that from where i get TCP port numbers mean?That my PC gives me By Default 5022 for master and 5023 for mirror all set but when i click on Start Mirroring then it gaves the error....Click Finish to perform the following actions: On the principal server instance, CREATIVE8\SQLEXPRESSModify the following properties of the mirroring endpoint: Name: MirroringListener Port: 5022Encryption: YesRole: PartnerOn the mirror server instance, CREATIVE8\SQLAModify the following properties of the mirroring endpoint: Name: MirroringListener Port: 5023Encryption: YesRole: PartnerThe error is as followThe server network address "TCP://creative8.domain.companyname:5022" cannot be reach or does not exist.Check the network address name and reissue the command.I M doin it for the first time so,,plzz if any body knows about it?Thanks in Advance.. |
|
|
heavymind
Posting Yak Master
115 Posts |
Posted - 2009-02-02 : 09:05:30
|
| Don't even try to establish mirroring between instances on the same physical computer. I tried it for 2005 and 2008 sql server with no luck.Thanks, VadymMCITP DBA 2005/2008Chief DBA at http://www.db-staff.com |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-02-02 : 09:34:21
|
quote:
Originally posted by heavymind
Don't even try to establish mirroring between instances on the same physical computer. I tried it for 2005 and 2008 sql server with no luck.Thanks, VadymMCITP DBA 2005/2008Chief DBA at http://www.db-staff.com
Huh!! I don't agree with this. I have used it several times for testing purposes. The Error above :SQL Express doesn't support Database Mirroring |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-02-02 : 09:49:55
|
sodeep is absolut right!It works fine to me on one physical computer (2 Partner, 1 Witness) on developer edition.SQL Express only supports to be Witness.Webfred
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
ashishashish
Constraint Violating Yak Guru
408 Posts |
Posted - 2009-02-03 : 03:27:52
|
| can anybody tell me plzz wat i di wrong ,,,n wat this error all about,,,,,m stuck in dis?ANy Help// |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-02-03 : 09:37:57
|
quote:
Originally posted by ashishashish
can anybody tell me plzz wat i di wrong ,,,n wat this error all about,,,,,m stuck in dis?ANy Help//
We already explained what is error? You need to use Standard,Developer of Enterprise Edition of SQL Server for Principal and Mirror DB? |
|
|
|
ashishashish
Constraint Violating Yak Guru
408 Posts |
Posted - 2009-02-06 : 01:37:45
|
Ohkk m using Developer Service Pack II Edition wid me...n Same error is here?quote:
Originally posted by sodeep
quote:
Originally posted by ashishashish
can anybody tell me plzz wat i di wrong ,,,n wat this error all about,,,,,m stuck in dis?ANy Help//
We already explained what is error? You need to use Standard,Developer of Enterprise Edition of SQL Server for Principal and Mirror DB?
|
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-02-06 : 08:50:44
|
| Both Servers(P&M) needs to be in same edition. Also did you apply transactional log backup in Mirror in NORECOVERY MODE? |
|
|
|
ashishashish
Constraint Violating Yak Guru
408 Posts |
Posted - 2009-02-13 : 08:03:23
|
Yes I did all the things in this ,,,,,,but still m not able to do mirroring proper,,,so i found a alternative to this,,,,n i do replication .,....well thanks all...N show me other way to do mirroring......Thanks,,,,quote:
Originally posted by sodeep
Both Servers(P&M) needs to be in same edition. Also did you apply transactional log backup in Mirror in NORECOVERY MODE?
|
|
|
|
|
|
|
|
|
Mirroring