473,566 Members | 3,014 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Problem in implementing mirroring

375 Contributor
Hi, All

I underwent the following Steps for creating a mirror in sql server 2005.
1. Downloaded and isntalled sp2 in principal,mirro r 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(res toring))
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:502 2" 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
2 2208
ck9663
2,878 Recognized Expert Specialist
Hi, All

I underwent the following Steps for creating a mirror in sql server 2005.
1. Downloaded and isntalled sp2 in principal,mirro r 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(res toring))
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:502 2" 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
cmrhema
375 Contributor
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,mirro r 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(res toring))
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

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

Similar topics

4
2805
by: Mulder | last post by:
Has anyone enabled log mirroring under DB2 v8 on AIX 4.3.3 or 5.? and if so are you archiving these mirrored logs to TSM? Is this possible? If so is there any sample code for the user exit and mirrored logging? Thanks
11
2017
by: hrishy | last post by:
Hi All I was just wundering is there any way of mirroring our active logs just in case of disk failures.wil db2 do it automatically for us maybe through some inititalisation parameter. regards Hrishy
6
2763
by: GGerard | last post by:
Hello Does anyone know if there's a way to mirror data from a backend database to a second database? Example: When writing data to one database it would mirror the data in a second database for backup and then if anything should happen to the first database the user could switch to the second backup database.
5
2153
by: Ryan | last post by:
I'm devlving into 2005 and specifically mirroring. Having read the following article ( http://www.microsoft.com/technet/prodtechnol/sql/2005/dbmirror.mspx ), is mirroring a sensible option as it indicates that it should not be used in a production environment, yet the SQL2005 seminars I've been to indicate that this is a worthy option. ...
5
6219
by: d.grabov | last post by:
Can anyone offer some advice on how to reduce the size of a database log. The database is mirrored on another server using the logs. Thanks
0
4390
by: serge | last post by:
I have 2 SQL Enterprise Editions running SP2 and same collation. When i try to start database mirroring I get the following error message: "The remote copy of database "ABC" has not been rolled forward to a point in time that is emcompassed in the local copy of the database log. (Microsoft SQL Server, Error: 1412)" Both SQL Server...
1
3077
by: mmark751969 | last post by:
We have a sql server 2000 sp3 server on a win2k3 server standard edition. This is on dell hardware with a dell scsi dasd enclosure directly attached. We want to duplicate the hardware and replicate or mirror the database to the backup server and do a manual or automatic failover in case of outage(more than likely manual). Wondering right...
1
1627
donilourdu
by: donilourdu | last post by:
hi, I am Doni. I am having windows 2000 Advance Server with Dynamic Volume Mirrored. Os : Windows 2000 Advance server Mirror : Simple HDD : 2 (Both 80 GB, C drive 14 GB and so on)
0
1198
by: pratimapaudel | last post by:
I need to do the mirroring of my company's production DataBase. I am not planning to setup the witness server. I am planning to do mirroring between two servers only. Can anyone tell me how long it will take? How many hours it will take to setup everything? I have to give the approximate time to complete thhis to my department manager. I...
0
7683
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
7586
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
7899
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
0
8113
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
0
6270
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
0
5215
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
0
3647
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
1
2092
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
0
927
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.