So first you have to the database from the mirror session, then do the necessary change actions and restore the mirror session. Ex,
ALTER DATABASESET PARTNER OFF
ALTER DATABASESET SINGLE_USER WITH ROLLBACK IMMEDIATE
ALTER DATABASECOLLATE SQL_Latin1_General_CP1_CI_AS
On the mirrored database:
RESTORE DATABASEWITH RECOVERY
Error Messages:
- The database could not be exclusively locked to perform the operation.
- The operation cannot be performed on database it is involved in a database mirroring session or an availability group
No comments:
Post a Comment