Is possible to attach the same Content DB in two sites in Same farm

Is possible to attach the same Content DB in two sites in Same farm.

Issue: I am getting many questions from the SharePoint community that” Is possible to attach the same Content DB in two sites in Same farm”

Solution: I say answer as Yes and No.

1)   We can attach but, The expected behavior as the Site Collections have the same GUID, so the second website which has same content attached  will not be able to see all data of them. In this case we can consider the below steps to overcome this.

2)   Restore the Content Database to a Web Application on another farm

3)   Use Backup-SPSite/Restore-SPSite which assigns a new GUID to the Site Collection so you can 'duplicate' it within the same farm

4)   Use Export-SPWeb/Import-SPWeb

 


I hope the above information will help you to resolve the issue, in case of any queries/questions regarding the above mentioned information then please let me know. I would be more than happy to help you as well as resolves your issues, Thank you.