The answer is no ........we cannot detach the database which is participating in replicaion ..
Consider a scenario where you have hundereds of databases replicated and you fall short of disk :D ...
Disabling/removing Replication will be costly and time consuming ...
But we can follow the simple steps below and everything will be fine ...
1.Run ALTER DATABASE database_name SET OFFLINE.
2.Move the file to the new location.
3.Run ALTER DATABASE database_name MODIFY FILE ( NAME = logical_name, FILENAME = 'new_path/os_file_name'.
4. Run ALTER DATABASE database_name SET ONLINE.
Trust me ...you are done :) ..
Comments are welcome as always ..
No comments:
Post a Comment