December 31, 2009 at 6:06 am
Hi,
I have used "ALTER DATABASE database_name SET PARTNER FORCE_SERVICE_ALLOW_DATA_LOSS".
But it gives the error 1404.
The Command failed because the database mirror is busy. Reissue the command Later.
How to do the failover ?
December 31, 2009 at 6:48 am
Have you tried "ALTER DATABASE database_name SET PARTNER FAILOVER"?
December 31, 2009 at 7:17 am
Is the operating mode of the mirror in Synchronous mode? To perform a manual failover the database needs to be in Synchronous mode - High safety without automatic failover. You can view what mode the mirroring session is in by right clicking on the database in management studio, go to properties, and click on Mirroring.
January 3, 2010 at 6:13 pm
I've experienced this before, could've been due to sql service account password reset after the mirroring was established.
Resolved by restarting the instance that had the password changed, which was luckily in my case was the secondary sql instance.
Simon
Simon Liew
Microsoft Certified Master: SQL Server 2008
January 23, 2010 at 9:30 am
Viji-1080779 (12/31/2009)
Hi,I have used "ALTER DATABASE database_name SET PARTNER FORCE_SERVICE_ALLOW_DATA_LOSS".
But it gives the error 1404.
The Command failed because the database mirror is busy. Reissue the command Later.
How to do the failover ?
Hi l!
I've just visited this forum. Happy to get acquainted with you. Thanks.
__________________
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply