Sql server 2008 database mirroring manual failover

In case your mirroring has been suspended and you have tried everything else and nothing works. Your last option is to break the mirroring and restore the mirror database and connect the client application to the mirror site.

Before proceeding with this please note that doing this will require you to rebuild the Data Mirroring again.

At the Principal Site

ALTER DATABASE SET PARTNER OFF

At Mirror Site

RESTORE DATABASE WITH RECOVERY

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s