Tell me more ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.
up vote 2 down vote favorite

I need to move a test SharePoint 2010 site collection and database to a new server (and new database). I want to make sure that I keep user security and all document versions. Does backup/restore keep all document versions automatically, or do I need to use import/export with the -includeusersecurity and -versions syntax?

share|improve this question

2 Answers

up vote 3 down vote accepted

Backup-SPSite will move all your data and rights and create corresponding records in the content DB. Import-Export is not so good way for you, you can use it only for web, not for site collection, but it also will move all your data and security, if you will set corresponding flags, it has a lot of options. Previous approach is also possible, you can attach your content DB to the new location, it will move all your data and security, but I use Backup-SPSite most often.

share|improve this answer
I tested with this and it worked well. It kept all of the data and rights. I'm primarily a programmer, so I am more comfortable with PowerShell than with SQL backups and detaching/reattaching databases. – LCountee Nov 9 '11 at 20:25
up vote 3 down vote

The way I would do this is to move the site collection into its own content database. Then copy that database and attach it to the new farm.

  1. In Central Admin add a new content database to the web application
  2. Use the Move-SPSite CMDLET in PowerShell to move the site collection to the new content database
  3. Make a SQL backup of the content database
  4. Restore the SQL backup to the SQL server of the new farm
  5. Attach the content database to a web application on the new farm
share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.