July 14, 2010 at 3:24 pm
I have a single instance of SQL 2005 with 5 databases with mirroring turned on on all the databases.
Today I had to do some maintenance on one of the databases and so, I removed mirroring for that database, did what I had to do but, now when I try to re-enable mirroring for that database....I get the following error:
"Alter Failed for Database"
"The Database is being closed before mirroring is fully initialized:
Microsoft Server Error: 1414"
AUTO CLOSE is set to false
I searched on google but couldn't find a solution.
Please help.
Thanks & Regards,
Anish
July 14, 2010 at 8:43 pm
Take the latest log backup and apply on the mirrored database. Then reconfigure mirroring. Hope it will work.
July 14, 2010 at 8:47 pm
Thanks Sumit for your reply.
I tried that bust still no show!!!
But, I did manage to fix the problem by restarting the SQL instance on the mirrored server.
Cheers!
Anish
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply