Post reply

Database Mirroring

  • July 15, 2009 at 9:50 am

    #1025183

    I don't use any T-SQL statement for Database mirroring. I use GUI to create the endpoints....Initially i restored(only full backup) the database in principal server with recovery mode and i restored the database(both full backup and trasaction log backup) in mirror server using No Recovery mode and then i configured the principal and mirror...I used ports 5022 for principal and 5023 for the mirror.....

    Thanks for the reply

    Regards,

    Sandeep

  • July 15, 2009 at 10:02 am

    #1025200

    Does the database mirroring depends upon the structure of the tables??

    (I am still in the process of learning the DBA tasks 🙂 )

  • July 15, 2009 at 12:47 pm

    #1025282

    Use T-SQL for creating TCP endpoints and granting CONNECT permission.

    After you have created endpoints and granted permission then use Mirroring GUI.

Viewing 3 posts - 16 through 17 (of 17 total)

You must be logged in to reply to this topic. Login to reply