July 24, 2011 at 8:18 am
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
Apologies
We are running SQL server 2005 Standard Edition SP3
Ruan
October 23, 2013 at 9:31 am
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
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