Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

SQL Server 2008 R2 Mirroring error

Posted on 2012-03-13
6
Medium Priority
?
421 Views
Last Modified: 2012-03-26
I am using the Wizard to create the mirroring. the error that I am getting is attached.

Thank you
0
Comment
Question by:iscivanomar
  • 3
  • 2
6 Comments
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 37718051
the error that I am getting is attached.
Please try again.
0
 

Author Comment

by:iscivanomar
ID: 37722282
0
 
LVL 75

Accepted Solution

by:
Anthony Perkins earned 1000 total points
ID: 37722387
Have you gone through these steps:
Troubleshooting Database Mirroring Deployment
http://msdn.microsoft.com/en-us/library/ms189127.aspx
0
Learn Veeam advantages over legacy backup

Every day, more and more legacy backup customers switch to Veeam. Technologies designed for the client-server era cannot restore any IT service running in the hybrid cloud within seconds. Learn top Veeam advantages over legacy backup and get Veeam for the price of your renewal

 

Author Comment

by:iscivanomar
ID: 37722506
No, I have not gone through these steps. The database mirroring was working but I break it.  I have the users, port, endpoint, but I forgot to prepare the database for mirroring. When I break the mirroring, I tried to recreate it with out preparing. Let me try again.

Thank you
0
 
LVL 10

Assisted Solution

by:Ramesh Babu Vavilla
Ramesh Babu Vavilla earned 1000 total points
ID: 37723492
hey just check my blog. it helps you in mirroring

http://sqlservr.blog.com/category/high-availability/

check user credentials for altering the database

SELECT role_desc, state_desc FROM sys.database_mirroring_endpoints
0
 

Author Closing Comment

by:iscivanomar
ID: 37768748
THANK YOU GUYS, IT HELP'S
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
After seeing many questions for JRNL_WRAP_ERROR for replication failure, I thought it would be useful to write this article.
This tutorial will walk an individual through the steps necessary to enable the VMware\Hyper-V licensed feature of Backup Exec 2012. In addition, how to add a VMware server and configure a backup job. The first step is to acquire the necessary licen…
This tutorial will walk an individual through the steps necessary to install and configure the Windows Server Backup Utility. Directly connect an external storage device such as a USB drive, or CD\DVD burner: If the device is a USB drive, ensure i…

916 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question