By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,377 Members | 1,279 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,377 IT Pros & Developers. It's quick & easy.

Problem in implementing mirroring

100+
P: 375
Hi, All

I underwent the following Steps for creating a mirror in sql server 2005.
1. Downloaded and isntalled sp2 in principal,mirror as well as witness servers
2. Created a new database named it as FinalMirror
3. Right clicked on the database Tasks-backup-BackupType--Full--Ok created FinalMirror.bak
4. Right clicked on the database Tasks-backup-BackupType--Transactional Log--Ok created FinalMirror-Transaction Log Backup(both of the files are under the same name FinalMirror.bak)
(Also Tried to create backup seperately as final1.bak and finaltrans.trn)
5. Copied this finalmirror.bak from my system to the Mirror Server.
It was stored in the Principal server in the following location
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup

6. Right click on Mirror Server Database--Restore Database --Manually wrote down the ToDatabase
7. Selected from device and selected the added the copied backup file
8. Performed a restore --select the relevant backup--checked the checkbox on restore

(Did it individually for backup and transactional log)
(Tried with finalmirror.bak for backup and transactional log also tried final1.bak and finaltrans.trn)
9. On the left panel selected the Options and choosed NO RECOVERY
(In the mirror database its displayed as FinalMirror(restoring))
10.performed mirroring and for witness unchecked the "encrypt option"

Mirroring on process

but after I click the start mirroring button in the Mirror server the database is shown as FinalMirror(In Recovery)



It ends up with an error 1418

"The server network address "TCP://dddd.abcdIT:5022" can not be reached or does not exist"



I have set the norecovery option too.



where am i going wrong
please help

regards
cmrhema
Apr 6 '08 #1
Share this Question
Share on Google+
2 Replies


ck9663
Expert 2.5K+
P: 2,878
Hi, All

I underwent the following Steps for creating a mirror in sql server 2005.
1. Downloaded and isntalled sp2 in principal,mirror as well as witness servers
2. Created a new database named it as FinalMirror
3. Right clicked on the database Tasks-backup-BackupType--Full--Ok created FinalMirror.bak
4. Right clicked on the database Tasks-backup-BackupType--Transactional Log--Ok created FinalMirror-Transaction Log Backup(both of the files are under the same name FinalMirror.bak)
(Also Tried to create backup seperately as final1.bak and finaltrans.trn)
5. Copied this finalmirror.bak from my system to the Mirror Server.
It was stored in the Principal server in the following location
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup

6. Right click on Mirror Server Database--Restore Database --Manually wrote down the ToDatabase
7. Selected from device and selected the added the copied backup file
8. Performed a restore --select the relevant backup--checked the checkbox on restore

(Did it individually for backup and transactional log)
(Tried with finalmirror.bak for backup and transactional log also tried final1.bak and finaltrans.trn)
9. On the left panel selected the Options and choosed NO RECOVERY
(In the mirror database its displayed as FinalMirror(restoring))
10.performed mirroring and for witness unchecked the "encrypt option"

Mirroring on process

but after I click the start mirroring button in the Mirror server the database is shown as FinalMirror(In Recovery)



It ends up with an error 1418

"The server network address "TCP://dddd.abcdIT:5022" can not be reached or does not exist"



I have set the norecovery option too.



where am i going wrong
please help

regards
cmrhema

Try creating the two database manually first. Test the connection between the two servers, manually. If you can connect to the two servers manually, there's something wrong with your mirroring config, not just the db.

-- CK
Apr 6 '08 #2

100+
P: 375
Try creating the two database manually first. Test the connection between the two servers, manually. If you can connect to the two servers manually, there's something wrong with your mirroring config, not just the db.

-- CK
I can very well connect the two servers manually. Once again putting forth the steps that would enable the readers to analyze my problem and reply



I underwent the following Steps for creating a mirror in sql server 2005.
1. Downloaded and isntalled sp2 in principal,mirror as well as witness servers
2. Created a new database named it as FinalMirror
3. Right clicked on the database Tasks-backup-BackupType--Full--Ok created FinalMirror.bak
4. Right clicked on the database Tasks-backup-BackupType--Transactional Log--Ok created FinalMirror-Transaction Log Backup FinalMirrorlog.trn

5. Copied this finalmirror.bak,FinalMirrorlog.trn from my system to the Mirror Server.
It was stored in the Principal server in the following location
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup

6. Right click on Mirror Server Database--Restore Database --Manually wrote down the ToDatabase
7. Selected from device and selected the added the copied backup file
8. Performed a restore --select the relevant backup--checked the checkbox on restore
9. On the left panel selected the Options and choosed NO RECOVERY
(In the mirror database its displayed as FinalMirror(restoring))
10. Underwent the above two process 8 and 9 for transaction log
11. performed mirroring
Mirroring on process

but after I click the start mirroring button ,

I have the error 1418
Error: 1418 - Microsoft SQL Server - The server network address can not be reached or does not exist. Check the network address name and reissue the command. The server network endpoint did not respond because the specified server network address cannot be reached or does not exist.

in the Mirror server the database is shown as FinalMirror(In Recovery)


Now i tried out to netstat command
When i gave netstat -a
I could not see any of the servers other than mine
then i tried out netstat -abn
There were many details but none of the servers of the mirror or witness reflected

What is the problem?
Kindly help

Regards
cmrhema
Apr 15 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.