Post reply

Database Mirroring

  • November 3, 2012 at 10:08 pm

    #284148

    I am getting this error "Database mirroring error: status 1488, severity 16, state 1, string" when I ran this "ALTER DATABASE <mydatabase> SET PARTNER = 'TCP://<principal server>:5022'" on the mirror. Can anyone help?

  • November 4, 2012 at 4:53 am

    #1555811

    Can you supply more detail about your mirror setup?

    Can you post details of this query run against the principal

    Select name, user_access_desc, state_desc,

    recovery_model_desc

    from sys.databases

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • November 4, 2012 at 5:59 am

    #1555812

    name = abcdatabase,

    user_access_desc = multi_user,

    state_desc = online,

    recovery_model_desc = full

  • November 4, 2012 at 6:33 am

    #1555814

    Perry Whittle (11/4/2012)

    Can you supply more detail about your mirror setup?

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • November 4, 2012 at 7:06 am

    #1555815

    I don't really know what information you want me to provide but here is what I did. I took the full backup of the principal and restore it on the mirror. created endpoints on the mirror and the principal and started the mirroring process.

  • November 4, 2012 at 7:45 am

    #1555816

    What were you doing when you received this error? Have you checked the error logs on both systems to determine if they could provide you with additional information, and if so what did they provide?

  • November 4, 2012 at 9:51 am

    #1555820

    deebabat (11/4/2012)

    I don't really know what information you want me to provide

    This will do for starters

    • Did you specify a witness?
    • Synch or Asynch mirroring?
    • Are you setting up using GUI or TSQL?
    • Whay account type used for sql server services?

    deebabat (11/4/2012)

    but here is what I did. I took the full backup of the principal and restore it on the mirror. created endpoints on the mirror and the principal and started the mirroring process.

    You need a full backup and at least one log backup to initialise the mirror database.

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

Viewing 7 posts - 1 through 6 (of 6 total)

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