Context: Site collection deletion and Failover server

Nagabhushana Bs

7y963

Hi All,

I am in small confusion. After deletion also the site collection will be available in content db and it can be restored.

1) Will the deleted site collection gets delete automatically from the database? Any machanism like that....

2) We are planning to have a Failover server. I will mention the Failover db name in Manage content database (by opening the content database) at Central admin web site. So, do i need to mention Failover db name in SQL server and in other APP / Webfront end web server?

Kindly provide your valuable inputs.

-Thanks & Regards,

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Waqas Sarwar7y ago
Accepted answer
When Site Collection is deleted by central admin.
it put the site into Central admin recycle bin ( same way when you delete a document it goes into site collection recyclebin)
At this point you can restore it as it is still sit inside the content database(using restore-spdeletedsite)
if you dont do anything, it will be automatically removed after 30 days. If you want to remove it quicklly then remove from recyclebin using remove-spdeletedsites followed by to manually run the Gradual site delete job. after this site collection will be completely removed from the farm.
For Failover DB name
You need to mention it on central admin's page (manage content database), that's it.
+1
Thuyavan Ganesan7y ago
Really ? it was just repeated what I have mentioned and you marked as answer :)
anyway thanks.
0
Thuyavan Ganesan7y ago
Hi Nagabhushana,

I know it’s confusing J if you delete a site collection from central admin it just deletes the site in IIS and the association with the SQL DB and the deleted site collection is temporarily preserved in SPDeletedSite object . within 30 days if you want your site collection to be restored you will be able to do that.

To restore from this object use this cmd

Restore-SPDeletedSite

To remove the SP site collection from this object use this cmd
Remove-SPDeletedSite

Please let me know if that works

Thanks,

Thuyavan
--------------------------------------------------------------------------------------------------------------------

Your feedback is very valuable and your “likes” are energy boosters for us to keep blogging
+1