Post reply

Database mirroring

  • July 24, 2011 at 8:18 am

    #244794

    Good day.

    I have a problem with mirroring. We have 2 live databases - one at about 90gb's and the other about 2gb.

    About 2 weeks ago, we got downtime to set up mirroring for the small db. I have set up many mirroring db's before. The certificates and everything has been set up correctly. So basically my process was:

    1. Put db in single user mode

    2. Make backup. (right click, task, backup)

    3. Copy backup over to partner server.

    4. Restore db from backup.

    5. Use following command - alter database set partner='TCP://';

    GO

    But i got the following error:

    Msg 1499, Level 16, State 1, Line 1

    Database mirroring error: status 1488, severity 16, state 1, string .

    I struggled for a while and then decided to set up a maintenance task instead of just right clicking and running backup.

    This sorted out the issue.

    Now today I have the exact same error with the large db, however, I have set up a maintenance task and followed all the procedures correctly.

    Can someone please help me out with this error as not even Google has any reliable info regarding the error.

    Thanks

    Ruan

  • July 24, 2011 at 8:19 am

    #1357534

    Apologies

    We are running SQL server 2005 Standard Edition SP3

    Ruan

  • October 23, 2013 at 9:31 am

    #1660994

    Make sure that you are executing the right name on each server. Making mistakes in the names was the cause for my problem!

  • October 24, 2013 at 2:47 am

    #1661170

    old thread !

    but anyway, here's a fix for it: http://blog.armgasys.com/?p=259

    Corrective Action

    Disconnected all clients from the Principal database

    Forced the Principal database into single-user mode

    Counted to 10 (No really, we did)

    Forced the Principal back into multi-user mode

    Created backup set for the mirror instance

    Rebuilt the mirror with no additional issues

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data/code to get the best help[/url]

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Need a bit of Powershell? How about this

    Who am I ? Sometimes this is me but most of the time this is me

Viewing 4 posts - 1 through 3 (of 3 total)

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