Re: Can't start mirroring

Not setting mirror database' s recovery state as norecovery is one of the reasons of this problem. If it does not apply to your situation, then:

Are your Logins identical on your Principal and Mirror SQL Server Instances? Are they member of sysadmin fixed server role? If not, how did you configured your Logins?

Are your SQL Server servers members of a domain? If so, use domain accounts for your SQL Server service accounts.

--
Ekrem Önsoy



"Fabio Gava" <esa_ud@xxxxxxxxx> wrote in message news:%232fCqgcMIHA.4948@xxxxxxxxxxxxxxxxxxxxxxx
Ekrem Önsoy wrote:
Fabia,

It raises that error because you did not restore your database on the
mirror server in norecovery mode.

No, I did it correctly, also if I'm afraid of the "(in recovery)" label that apper close to the DB name in Management studio. Is it normal behaviour?

I tried also with a T-SQL procedure I found here:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=67626

Skipping the witness part, since I don't have any.

It fails on:

ALTER DATABASE M2
SET PARTNER = 'TCP://HP02:10112'
GO

again, with error:

Msg 1418, Level 16, State 1, Line 1
The server network address "TCP://HP02:10112" can not be reached or does not exist. Check the network address name and that the ports for the local and remote endpoints are operational.

while the counterpart on HP02 (the mirror) correctly executed.

-f


.

Relevant Pages

  • Re: Licensing for DB mirroring
    ... As long as you don't use it for anything other than a pure mirror it does not require a license similar to the way clustering works. ... Actually you do not need a license for the database server running the ... SQL Server Pricing and Licensing ...
    (microsoft.public.sqlserver.setup)
  • Re: Licensing for DB mirroring
    ... than a pure mirror it does not require a license similar to the way clustering works. ... Actually you do not need a license for the database server running the ... SQL Server Pricing and Licensing ...
    (microsoft.public.sqlserver.setup)
  • Re: SQL Server 2005, Database Mirroring and SQL Server Agent
    ... Are you saying that you are mirroring the msdb database? ... think you even could mirror msdb... ... > The SQL I put in my original post will check that it is the principle ... >> Tibor Karaszi, SQL Server MVP ...
    (microsoft.public.sqlserver.server)
  • Re: MS Access DAO -> ADO.NET Migration
    ... William Vaughn ... Microsoft MVP ... Hitchhiker's Guide to Visual Studio and SQL Server ... My migration app works building a SSCE database file with imported data ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Cluster will not fail over.
    ... > As far as the TCP/IP issue goes, you had to rebuild the cluster and were ... > able to restore the master database. ... > a cluster installation you'll have to revisit. ... >> This worked bringing up the sql server in minimal mode. ...
    (microsoft.public.sqlserver.clustering)
Loading