SOLVED
Home

Sharepoint Online - Site backup / export

%3CLINGO-SUB%20id%3D%22lingo-sub-89897%22%20slang%3D%22en-US%22%3ESharepoint%20Online%20-%20Site%20backup%20%2F%20export%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-89897%22%20slang%3D%22en-US%22%3E%3CP%3EHi%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20options%20do%20we%20currently%20have%20to%26nbsp%3Bexport%20a%20Site%20in%20Sharepoint%20Online%3F%3C%2FP%3E%3CP%3EScenario%26nbsp%3Bis%2C%26nbsp%3Bneed%20to%20export%20an%20existing%20Production%20site%20to%20reuse%2Fimport%20it%26nbsp%3Bto%26nbsp%3Bour%20testing%20environment%20under%20a%20different%20site%20collection%20on%20Sharepoint%20Online.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20unable%20to%20use%20the%20%22Save%20as%20template%22%20option%20since%20the%20site%20is%20using%20the%20Publishing%20feature.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20is%20everyone%20getting%20around%20this%20Sharepoint%20Online%20limitation...to%20duplicate%20or%20copy%20an%20existing%26nbsp%3Bsite%20to%20another%20location%20for%20Testing%20ect%20%3F%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-89897%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAdmin%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESites%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-225428%22%20slang%3D%22en-US%22%3ERe%3A%20Sharepoint%20Online%20-%20Site%20backup%20%2F%20export%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-225428%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F2452%22%20target%3D%22_blank%22%3E%40John%20Tsalamandris%3C%2FA%3E%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EA%20bit%20late%2C%20but%20I've%20just%20posted%20an%20article%20you%20may%20find%20interesting%20for%20your%20search.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%0A%3CH2%20class%3D%22PageTitle%20lia-component-common-widget-page-title%22%20id%3D%22toc-hId--1326605099%22%20id%3D%22toc-hId-1707442239%22%20id%3D%22toc-hId-1707442239%22%20id%3D%22toc-hId-1707442239%22%20id%3D%22toc-hId-1707442239%22%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FSharePoint%2FSharePoint-Online-Backup-Strategies-for-a-Cloudy-Day%2Ftd-p%2F225418%22%20target%3D%22_blank%22%3ESharePoint%20Online%20Backup%20Strategies%20for%20a%20Cloudy%20Day%3C%2FA%3E%3C%2FH2%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-172484%22%20slang%3D%22en-US%22%3ERe%3A%20Sharepoint%20Online%20-%20Site%20backup%20%2F%20export%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-172484%22%20slang%3D%22en-US%22%3EHi%20John%2C%3CBR%20%2F%3E%3CBR%20%2F%3EOptions%3A%3CBR%20%2F%3E1)%20ShareGate%3CBR%20%2F%3E2)%20if%20only%20template%20then%20PnP%20powershell%20%3CBR%20%2F%3E%3CBR%20%2F%3ERegards%2C%3CBR%20%2F%3EVishwa%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-133858%22%20slang%3D%22en-US%22%3ERe%3A%20Sharepoint%20Online%20-%20Site%20backup%20%2F%20export%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-133858%22%20slang%3D%22en-US%22%3E%3CP%3EYou%20can%20use%20any%20other%20third%20party%20migration%20tool%20or%20manually%20migration.%20If%20PowerShell%20scripts%20achieved%20your%20requirement%26nbsp%3Bthen%20convert%20into%20a%20job%20and%20you%20are%20good%20to%20go%20with%20this.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-132478%22%20slang%3D%22en-US%22%3ERe%3A%20Sharepoint%20Online%20-%20Site%20backup%20%2F%20export%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-132478%22%20slang%3D%22en-US%22%3EI%20recently%20did%20a%20powershell%20script%20to%20migrate%20all%20documents%20libraries%20items%20from%20one%20sharepoint%20online%20site%20to%20another.%3CBR%20%2F%3EBut%20the%20powershell%20script%20use%20CSOM%20libraries%20to%20copy%20all%20items...%20%3CBR%20%2F%3EIs%20this%20approach%20ok%3F%20or%20what%20else%20we%20can%20do%20to%20achieve%20this%3F%20Because%20I%20tested%20the%20script%20within%202%20document%20libraries%20from%201500%20and%20it%20duration%20was%20tooooo%20long%2C%20like%204%20hours...%3CBR%20%2F%3EThe%20whole%20site%20size%20is%20about%20125GB%20so%20I%20suppose%20that%20mostly%20are%20the%20documents%20that%20mmust%20migrate.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-124777%22%20slang%3D%22en-US%22%3ERe%3A%20Sharepoint%20Online%20-%20Site%20backup%20%2F%20export%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-124777%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%20-%20Create%20new%20target%20site%20and%20import%20list%20and%20library%20using%20template%20if%20contents%20or%20less.%20Or%20use%20metavis%20tool%20for%20migration.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-124770%22%20slang%3D%22en-US%22%3ERe%3A%20Sharepoint%20Online%20-%20Site%20backup%20%2F%20export%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-124770%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3BJohn%2C%3C%2FP%3E%3CP%3EHow%20much%20contents%26nbsp%3Byou%20want%20to%20migrate%20from%20one%20site%20to%20another%2C%20if%20contents%20are%20less%20then%20you%20can%20create%20new%20target%20site%20and%20Import%20list%2Flibrary%20templets%20on%20target%20site.%3C%2FP%3E%3CP%3EMay%20be%20you%20can%20try%20disable%20the%20publishing%20feature%20and%20try%20again%20save%20as%20template.%3C%2FP%3E%3CP%3ELastly%20using%20metavis%26nbsp%3Bmigration%20tool%20you%20can%20move%20site%20one%20site%20collection%20to%20another.%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3CP%3EManish%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-89936%22%20slang%3D%22en-US%22%3ERe%3A%20Sharepoint%20Online%20-%20Site%20backup%20%2F%20export%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-89936%22%20slang%3D%22en-US%22%3ENo%2C%20it's%20not...those%20PowerShell%20cmdlets%20are%20for%20SharePoint%20OnPremises%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-89932%22%20slang%3D%22en-US%22%3ERe%3A%20Sharepoint%20Online%20-%20Site%20backup%20%2F%20export%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-89932%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F60%22%20target%3D%22_blank%22%3E%40Juan%20Carlos%20Gonz%C3%A1lez%20Mart%C3%ADn%3C%2FA%3E%26nbsp%3Bthanks%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20gather%20its%20still%20not%20possible%20to%20use%20Powershell%20(with%20the%20Sharepoint%20Online%20addin)%20and%20run%20Export-SPWeb%2FBackup-SPSite%20commands%20to%20accomplish%20that%3F%20%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-89927%22%20slang%3D%22en-US%22%3ERe%3A%20Sharepoint%20Online%20-%20Site%20backup%20%2F%20export%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-89927%22%20slang%3D%22en-US%22%3EThird%20party%20tool%20is%20the%20best%20way%20to%20go...taking%20into%20account%20you%20might%20be%20exporting%20a%20small%20site%20in%20size%2C%20you%20could%20try%20to%20see%20if%20using%20a%20trial%20tool%20is%20enough%20for%20you%20even%20I%20recommend%20you%20to%20invest%20some%20money%20here%20(Sharegate%20and%20Metalogix%20are%20cood%20choices)%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-89899%22%20slang%3D%22en-US%22%3ERe%3A%20Sharepoint%20Online%20-%20Site%20backup%20%2F%20export%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-89899%22%20slang%3D%22en-US%22%3E%3CP%3EYou%20could%20use%20a%203rd%20party%20tool%20in%20your%20case%2C%20like%20Sharegate%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1002289%22%20slang%3D%22en-US%22%3ERe%3A%20Sharepoint%20Online%20-%20Site%20backup%20%2F%20export%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1002289%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F2452%22%20target%3D%22_blank%22%3E%40John%20Tsalamandris%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMicrosoft%20right%20now%20does%20not%20have%20any%20backup%20option%20when%20the%20files%20are%20removed%20from%20the%20bins.%20Although%20they%20allow%20third-party%20applications%20to%20partner%20with%20them%20and%20provide%20the%20type%20of%20services%20you%20are%20looking%20for.%20I%20searched%20for%20some%20solutions%20myself%20and%20found%20the%20following%20list.%20In%20no%20particular%20order%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESysCloud%3C%2FP%3E%3CP%3EBackupify%3C%2FP%3E%3CP%3ESpanning%3C%2FP%3E%3CP%3EDruva%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1002821%22%20slang%3D%22en-US%22%3ERe%3A%20Sharepoint%20Online%20-%20Site%20backup%20%2F%20export%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1002821%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F2452%22%20target%3D%22_blank%22%3E%40John%20Tsalamandris%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ECan%20you%20explain%20what%20specifically%20you%20need%20to%20move%20down%2C%20into%20an%20on-premises%20environment%2C%20for%20testing%3F%20A%20few%20thoughts.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E1.%20If%20it's%20customizations%20that%20you're%20testing%2C%20backup%2Frestore%20isn't%20really%20a%20true%20dev%20pattern.%20Start%20thinking%20about%20building%2Fdeploying%20your%20customizations%20via%20DevOps%20models.%20Build%20the%20customization%2C%20and%20then%20deploy%20it%2C%20where%20ever%20it%20needs%20to%20go.%20Yes%2C%20I%20know%20this%20is%20more%20work%2C%20but%20it%20is%20the%20proper%20way%20to%20build%2Ftest%2Fdeploy%20customizations.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E2.%20SPO%20and%20SP%20Server%20are%20different%20products%2C%20although%20very%20similar.%20Moving%20between%20the%20two%20for%20testing%20purposes%20may%20create%20hidden%20issues%2C%20or%20have%20compatibility%20issues.%20(That's%20likely%20why%20there%20are%20no%20back%2Frestore%20PowerShell%20commandlets%20that%20work%20between%20the%20two)%3C%2FP%3E%0A%3CP%3E3.%20Moving%20content%20(documents)%20generally%20isn't%20necessary%20for%20testing%20purposes.%20Consider%20that%2C%20if%2Fwhen%20you%20leverage%20a%203rd%20party%20migration%20tool.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1061398%22%20slang%3D%22en-US%22%3ERe%3A%20Sharepoint%20Online%20-%20Site%20backup%20%2F%20export%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1061398%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F2452%22%20target%3D%22_blank%22%3E%40John%20Tsalamandris%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%2C%20a%20bit%20late%20to%20the%20party%20but%20just%20run%20into%20the%20same%20problem%20recently%20and%20after%20research%20I%20did%20collect%20the%20list%20of%20possible%20solutions%20for%20SharePoint%20data%20back-up%2Farchiving%2Fexporting%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CDIV%3E%3CDIV%3E%3CSPAN%3E*%20Simply%20export%20data%20into%20Excel%20from%20SharePoint%20list%20view%20(no%20attachments%2C%20only%20metadata%2C%20wouldn't%20work%20for%20large%20lists%2C%20manual%20work%20required)%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%3E%3CSPAN%3E*%20Apply%20information%20management%20policies%20to%20a%20list%20(not%20available%20by%20default%20for%20SharePoint%20Online%2C%20limited%20destination%20optionality)%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%3E%3CSPAN%3E*%20Use%20Export-SPWeb%20SharePointServer%20cmdlet%20(works%20only%20for%20Sharepoint%20Server%2C%20wouldn't%20work%20for%20SharePoint%20Online)%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%3E%3CSPAN%3E*%20Create%20workflow%20(MS%20Flow)%20which%20can%20move%20the%20items%20from%20the%20List%20to%20a%20chosen%20destination%20(be%20aware%205000%20search%20limitation%20is%20still%20there)%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%3E%3CSPAN%3E*%20Write%20PowerShell%20script%20and%20run%20is%20by%20Windows%20Task%20Scheduler%20(time%20consuming%20and%2C%20you%20know%2C%20PowerShell)%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%3E%3CSPAN%3E*%20Create%20a%20custom%20.NET%20Application%20using%20CSOM%20(.NET%20Framework%20required)%20and%20run%20it%20as%20a%20Windows%20Service%20(development%20is%20required)%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%3E%3CSPAN%3E*%20Create%20custom%20WEB%20application%20using%20SharePoint%20JavaScript%20Client%20Object%20Model%20or%203-rd%20party%20libraries%20like%20SharepointPlus%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%3E%3CSPAN%3E*%20If%20you%20have%20MS%20SQL%20Server%20you%20could%20create%20SQL%20Server%20Integration%20Services%20(SSIS)%20package%2C%20read%20list%20items%20as%20a%20OData%20source%20and%20run%20it%20as%20a%20job%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%3E%3CSPAN%3E*%20Use%203-rd%20party%20tools%20like%20%3CA%20title%3D%22Listman.io%22%20href%3D%22https%3A%2F%2Fgithub.com%2Flistman-io%2Fdocs%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3EListman.io%3C%2FA%3E%20to%20automate%20lists%20data%20archiving%20and%20export%20by%20schedule%20with%20attachment.%20The%20app%20will%20work%20for%20large%20lists%20with%20no%205000%20limitations.%3C%2FSPAN%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E
John Tsalamandris
Occasional Contributor

Hi

 

What options do we currently have to export a Site in Sharepoint Online?

Scenario is, need to export an existing Production site to reuse/import it to our testing environment under a different site collection on Sharepoint Online.

 

I'm unable to use the "Save as template" option since the site is using the Publishing feature.

 

How is everyone getting around this Sharepoint Online limitation...to duplicate or copy an existing site to another location for Testing ect ??

 

  

13 Replies

You could use a 3rd party tool in your case, like Sharegate

Solution
Third party tool is the best way to go...taking into account you might be exporting a small site in size, you could try to see if using a trial tool is enough for you even I recommend you to invest some money here (Sharegate and Metalogix are cood choices)

@Juan Carlos González Martín thanks

 

I gather its still not possible to use Powershell (with the Sharepoint Online addin) and run Export-SPWeb/Backup-SPSite commands to accomplish that?  

 

No, it's not...those PowerShell cmdlets are for SharePoint OnPremises

Hi John,

How much contents you want to migrate from one site to another, if contents are less then you can create new target site and Import list/library templets on target site.

May be you can try disable the publishing feature and try again save as template.

Lastly using metavis migration tool you can move site one site collection to another.

Thanks

Manish

 

 

 

 

Hi  - Create new target site and import list and library using template if contents or less. Or use metavis tool for migration.

I recently did a powershell script to migrate all documents libraries items from one sharepoint online site to another.
But the powershell script use CSOM libraries to copy all items...
Is this approach ok? or what else we can do to achieve this? Because I tested the script within 2 document libraries from 1500 and it duration was tooooo long, like 4 hours...
The whole site size is about 125GB so I suppose that mostly are the documents that mmust migrate.

You can use any other third party migration tool or manually migration. If PowerShell scripts achieved your requirement then convert into a job and you are good to go with this. 

Hi John,

Options:
1) ShareGate
2) if only template then PnP powershell

Regards,
Vishwa

Hi @John Tsalamandris,

 

A bit late, but I've just posted an article you may find interesting for your search.  

SharePoint Online Backup Strategies for a Cloudy Day

Highlighted

@John Tsalamandris 

Microsoft right now does not have any backup option when the files are removed from the bins. Although they allow third-party applications to partner with them and provide the type of services you are looking for. I searched for some solutions myself and found the following list. In no particular order,

 

 

SysCloud

Backupify

Spanning

Druva

@John Tsalamandris 

 

Can you explain what specifically you need to move down, into an on-premises environment, for testing? A few thoughts.

 

1. If it's customizations that you're testing, backup/restore isn't really a true dev pattern. Start thinking about building/deploying your customizations via DevOps models. Build the customization, and then deploy it, where ever it needs to go. Yes, I know this is more work, but it is the proper way to build/test/deploy customizations. 

2. SPO and SP Server are different products, although very similar. Moving between the two for testing purposes may create hidden issues, or have compatibility issues. (That's likely why there are no back/restore PowerShell commandlets that work between the two)

3. Moving content (documents) generally isn't necessary for testing purposes. Consider that, if/when you leverage a 3rd party migration tool. 

@John Tsalamandris 

 

Hi, a bit late to the party but just run into the same problem recently and after research I did collect the list of possible solutions for SharePoint data back-up/archiving/exporting:

 

* Simply export data into Excel from SharePoint list view (no attachments, only metadata, wouldn't work for large lists, manual work required)
* Apply information management policies to a list (not available by default for SharePoint Online, limited destination optionality)
* Use Export-SPWeb SharePointServer cmdlet (works only for Sharepoint Server, wouldn't work for SharePoint Online)
* Create workflow (MS Flow) which can move the items from the List to a chosen destination (be aware 5000 search limitation is still there)
* Write PowerShell script and run is by Windows Task Scheduler (time consuming and, you know, PowerShell)
* Create a custom .NET Application using CSOM (.NET Framework required) and run it as a Windows Service (development is required)
* Create custom WEB application using SharePoint JavaScript Client Object Model or 3-rd party libraries like SharepointPlus
* If you have MS SQL Server you could create SQL Server Integration Services (SSIS) package, read list items as a OData source and run it as a job
* Use 3-rd party tools like Listman.io to automate lists data archiving and export by schedule with attachment. The app will work for large lists with no 5000 limitations.