Re: Can't start mirroring

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: The remote copy of database is not recovered far enough to enable database mirroring.
    ... How about taking a up to date transactional log backup from the primary and restore it in norecovery mode to the mirror database and then finalize the setting up your database mirroring operation? ... on my mirror server, I then received the error "The remote copy of ...
    (microsoft.public.sqlserver.replication)
  • Re: Backend Exchange migrate to New Hardware (Server)
    ... Exchange mailbox stores and Exchange public folder stores. ... When you use Backup to restore Exchange databases, ... Storage Engine to restore Exchange database files and their ...
    (microsoft.public.exchange.setup)
  • Backup and Restore Files
    ... What is the best way to backup and restore a runtime database file? ... pszDisplayName As String ...
    (microsoft.public.access.gettingstarted)
  • Re: Transaction Log ??
    ... we used to simplify our database restore process: ... every database got their respective backup folder. ... -- get logFileName, FirstLSN, LastLSN list ...
    (microsoft.public.sqlserver.security)
  • Re: PARTIAL SQL Server RESTOREs
    ... DROP DATABASE mywind_part ... ALTER DATABASE mywind ADD FILEGROUP new_customers ... -- A full database backup is performed. ... RESTORE FILELISTONLY lists the database ...
    (microsoft.public.sqlserver.server)