Backup of Content Database without data and mount to web applicatoin

Question

Hi in SharePoint 2013 Can it possible to take backup of Content Database without data i mean no documents should come from all document libraries and list items from lists?

Here I can not take full backup from Production to test and I will restore this content database in Testing Environment for Test upgrade to SP 2016

I used the method from below article Backup and Restore a SQL Server Database without Data using DAC package.
https://www.mssqltips.com/sqlservertip/4664/copy-a-sql-server-database-with-just-the-objects-and-no-data/

I restored the Content database in another SP 2013 Farm when i try to mount content database it did not mount to web application and i found below error

Mount-SPContentDatabase : Invalid object name 'WebParts'.

Answer 1

Hi, @adil ,

Per my knowledge, we do not have an option to only backup the content database without stored documents. And it is not supported if you access and modify the database directly. If you are planning to test the upgrade process, you are always recommended to backup the content database and restore in the lab environment.

---

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.

Answer 2

Hi

From my understand, there is no OOTB solution, think you could consider to use 3rd party tool.