question

DeRadaSancibrianJavier-5583 avatar image
0 Votes"
DeRadaSancibrianJavier-5583 asked ·

Sharepoint 2013 - archive subsite

We have a SharePoint subsite with a large number of email attachments that it's making the WSS_Content database huge in size. Our SQL Server is running out of space and we need to move that subsite (the data in WSS_Content_DB) off that SQL Server to another location.

The subsite is not used anymore and has to be archived, NOT deleted. The issue is not the subsite itself, but the huge size of the WSS content database (docStreams table).

Is there a way to archive the subsite and the WSS_Content linked to it to another location such as a shared folder? The idea is to be able to access the archived content if it's needed in the future.

office-sharepoint-server-administration
10 |1000 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

EmilyDu-MSFT avatar image
0 Votes"
EmilyDu-MSFT answered ·

@DeRadaSancibrianJavier-5583

Here’re two methods for you.

1.You could use the cmdlet Export-spweb & Import-SPWeb to export the subsite to local disk as a copy of your subsite. Then delete the subsite after exporting. And import the copy when you need it.

2.You could use save a site as template include contents.

If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.




· 6 · Share
10 |1000 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

DeRadaSancibrianJavier-5583 avatar image DeRadaSancibrianJavier-5583 ·

Hi @EmilyDu-MSFT thank you for your reply.

Regarding option 1, is all the data from the WSS_Content database exported along with the subsite data? Our idea is to move that content DB to a network drive.
My main concern is knowing how the data from content database will be saved after the export. How we'll be able to access it if it's needed.

As for option 2, does it have any limit when saving as a template? Our content database is 460GB in size.

0 Votes 0 ·
EmilyDu-MSFT avatar image EmilyDu-MSFT DeRadaSancibrianJavier-5583 ·

@DeRadaSancibrianJavier-5583
1.Method 1 only exports all contents in the subsite, not entire WSS_Content database data. The data will be saved in a .cmp file. When you need the data, first create a new subsite, then import the .cmp file into new subsite.
2.Method 2 only saves the subsite as a template. The default size limit for a site template is 50 MB. If you want to increase the limit, please follow this reference.

1 Vote 1 ·
DeRadaSancibrianJavier-5583 avatar image DeRadaSancibrianJavier-5583 EmilyDu-MSFT ·

Thank you @EmilyDu-MSFT and sorry for my delay. Just to wrap up:

So there is no way to archive wss_content database data along with subsite data?

0 Votes 0 ·
Show more comments
DeRadaSancibrianJavier-5583 avatar image DeRadaSancibrianJavier-5583 ·

Hi @EmilyDu-MSFT , don't know if you haven't seen my last comment or simply you haven't had enough time to answer it.
Please let me know and thank you again!

0 Votes 0 ·