SQL Server Performance

newbie question regarding mirroring

Discussion in 'SQL Server 2005 Database Mirroring' started by shankbond, Jun 24, 2010.

  1. shankbond New Member

    Hi,
    I was trying to do a database mirroring( for learning purposes). But the mirroring process failed.
    I am currently having sql server 2005 developer edition, installed in physically two different machines.
    It gives me an error that there is some error : with the network address I have specified.
    Note: I have created these settings through SSMS.
    The network address is as TCP://<machine>:5022
    for both the mirror and principal.
    Also, if possible can some one please help me restore the mirrored database in the previous state:
    I mean: I had to restore it with the current back up with recovery on.
    It is still in Restoring state
    I hope You get my point.
    Please reply as soon as possible.
  2. ghemant Moderator

    Hi,
    you can use restore database <yrdbname> with recovery .
    Can you post the detailed error message you are getting!!
  3. satya Moderator

Share This Page