Saturday, September 5, 2009

t-sql



SQL SERVER %26ndash; FIX %26ndash; ERROR : Cannot drop the database because it is being used for replication. (Microsoft SQL Server, Error: 3724)
I have set up replication at many different organization. One error I quite commonly face is after I have removed replication I can not remove database. When I try to remove the database it gives me following error. Cannot drop the database because it is being used for replication. (Microsoft SQL Server, Error: 3724) Fix/Workaround/Solution: The solution is very simple. Create the empty database with the same name on another server/instance first. Take full back of the same and forced

Blog Content

No comments:

Post a Comment