SharePoint Database Migration Steps

background: The project on a SharePoint site is divided into SharePoint front end and database, the front end is placed on the physical machine, and the database is placed in the VM9 virtual machine.

Environment: Windows server R2+SP1, SharePoint server Enterprise, SQL Server r2+sp1, VM9 virtual machine

the problem: the virtual machine in fact only 70G size of files, but the virtual machine on disk space has more than 700 g, serious use of resources, on the Internet to try to use the vmware-vdiskmanager.exe–k command, The VMwareToolboxCmd.exe disk shrinkonly command is basically not useful (where the second command compresses a dozens of G virtual machine for almost more than 10 hours, resulting in a few grams of compression)

Workaround: Create a new virtual machine, install SQL Server, backup sitecollection, restore sitecollection to the new database, delete the original virtual machine.

Here is the migration process for my project:

1. Back up the Web.config,ckfinder/ckediter file on the original website

2, Backup sitecollection, command as follows:

　　Backup-spsite-identity Http://spserver-Path C: \a.bak-force

3, new virtual machine, and patch, set the virtual machine allow domain account access, set IP

4. Log in to the new virtual machine via IP with a domain account, install SQL Server R2, and patch

5. Run the SharePoint Configuration Wizard, turn off the original farm connection, and connect to the new database (typically the first time, fail, and then run once)

6, restore SiteCollection, command as follows:

Restore-spsite-identity Http://spserver-Path c:\a.bak-databaseserver spserver-databasename Wss_content-force

7. Place the DLLs in your code under the Bin folder of IIS

8. Redeploy the WSP package with the following command:

"C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\15\bin\stsadm.exe"-O deletesolution-name Jurassic.nrc.wsp-override

"C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\15\bin\stsadm.exe"-O addsolution-filename c \ Users\administrator\desktop\jurassic.nrc.wsp

"C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\15\bin\stsadm.exe"-O deploysolution-name Jurassic.nrc.wsp-url Http://sp2014-allowgacdeployment-immediate–force

9, set the maximum upload file size of the website

10. Set the list threshold

11. Reconfigure Office Web Apps

12. Testing the website

The above steps are the whole process of migrating my project, welcome to communicate with each other!

SharePoint Database Migration Steps