So, if replication is there, better to try other methods instead of detaching db. As per Books Online, if this stored procedure does not work, you need to use sp_removedbreplication stored procedure, which removes all the replication objects in the database. In order to perform the detach operation you would need to disable the publishing option using the sp_replicationdboption stored procedure. Well Paul, you wouldn't be able to detach a publisher database. If the DB's are huuuuuuge I would go for the full backup\restore diff trn option, I've never considered replication so I'd be interested to hear your experiences of it. Mohammed - care to share more information on that one-liner? Why would you want to avoid detach\attach, I've always considered this an excellent way of migrating databases that are small enough to copy (note copy and not move :-P). If replication is there, better to avoid detach\attach
0 Comments
Leave a Reply. |