Solved

SQL Server 2008 R2 Mirroring error

Posted on 2012-03-13
6
412 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 250 total points
ID: 37722387
Have you gone through these steps:
Troubleshooting Database Mirroring Deployment
http://msdn.microsoft.com/en-us/library/ms189127.aspx
0
Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

 

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:sqlservr
sqlservr earned 250 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

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

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

In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
OfficeMate Freezes on login or does not load after login credentials are input.
This tutorial will walk an individual through locating and launching the BEUtility application and how to execute it on the appropriate database. Log onto the server running the Backup Exec database. In a larger environment, this would generally be …
This tutorial will walk an individual through the process of transferring the five major, necessary Active Directory Roles, commonly referred to as the FSMO roles to another domain controller. Log onto the new domain controller with a user account t…

823 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