Copying SharePoint 2010 Site Collection from Production into DTS environment via Database back up and restore
If you are running SharePoint farms then you would have come across this requirement at least once, which is to replicate a production site or site collection into Development, Test or Staging environment. There are a number of blog posts and articles on how to copy down the site or site collection without much trouble but I have not found one which worked as expected. The Database back-up and restore method is a quick and easy method or cheaper solution than commercial tools available in the market. This method works well if you would like to quickly copy content. With the content database attach method the key is to be aware that the following items which are farm related attributes, need attention as they are not copied across. Search scope and Indexes, User accounts and Managed Metadata. There are easier ways to overcome these. Search scope and indexes have to be redone and it does not take too much of your time. If your DTS environments have different users than the producti