Recovering from a mkreplica –export failure
If mkreplica –export fails, your database may be left in a locked state. To resolve this problem, unlock the schema repository and user database.
About this task
To unlock the schema repository and user database:
Procedure
- Unlock the schema repository with the installutil unlockschemarepo command.
This command has the following syntax:
installutil unlockschemarepo db-vendor server database dbo-login dbo-password connection-options
Connection options:
For example, to unlock the SQL_SERVER schema repository database test_master_sitea on server QE_TEST1:
where multisite is the dbo-login and dbo-password for the test_master_sitea database.installutil unlockschemarepo SQL_SERVER QE_TEST1 test_master_sitea multisite multisite ""
- Unlock the user database with the installutil unlockuserdb command.
This command has the following syntax: installutil unlockuserdb db-vendor server database dbo-login dbo-password connection-options
Connection options:
For example, to unlock the SQL_SERVER user database test_user_sitea on server QE_TEST1:
installutil unlockuserdb SQL_SERVER QE_TEST1 test_user_sitea multisite multisite ""
where multisite is the dbo-login and dbo-password for test_user_sitea.