Explanation:Detach the database from the source server, copy the database files to the destination server, and attach the database at the destination server. 8. Which of the following stored prcoedure is used for detachment of database ?
A. sp_replicationdboption
B. sp_replicationdb
C. sp_replicationoption
D. All of the mentioned
Answer:A
Explanation:Detach the database from the source server, copy the database files to the destination server, and attach the database at the destination server. 8. Which of the following stored prcoedure is used for detachment of database ?
A. sp_replicationdboption B. sp_replicationdb C. sp_replicationoption D. All of the mentioned
Explanation:If you cannot use sp_replicationdboption, you can remove replication by running sp_removedbreplication.