?
Solved

SQL Server 2008 R2 Mirroring error

Posted on 2012-03-13
6
Medium Priority
?
424 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
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 

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

Problems using Powershell and Active Directory?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

Question has a verified solution.

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

After seeing many questions for JRNL_WRAP_ERROR for replication failure, I thought it would be useful to write this article.
This shares a stored procedure to retrieve permissions for a given user on the current database or across all databases on a server.
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…
This tutorial will show how to configure a single USB drive with a separate folder for each day of the week. This will allow each of the backups to be kept separate preventing the previous day’s backup from being overwritten. The USB drive must be s…

616 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