Restoring Content Databases between Farms
Have you ever faced scenario where you would like to restore content database between production/test/dev. Here you are the steps: 1- Take SQL backup. 2- Copy backup to the other farm. 3- Attach to the SQL server. 4- from Central admin in the farm you would like to restore to go to application management then content database and select the correct web application. 5- detach the old Database and attach the copied one. Is it ready? Not yet as when you do that the sites will come with the path that was created in the previous farm i.e. contoso.com but in this farm you want it to be contoso-tst.com so how you fix it? run the following commands for each site to modify URL $site = Get-SPSite -Identity htt p://consoto.com $site.Rename(" http s://consoto-tst.com") The site is now ready.