Yes it is possible to create a second db file. There are no tricks to this, create the file and attached it to the existing db. A quick bing search will provide you the steps.
New Database file for SCCM

Dear all,
I want to know the best way to handle SCCM database. As my SCCM Database size is approx 50GB now and i am thinking to create a new database file and attach it along with an existing one so that the previous one size stop growing more. Please let me know if it is possible and how in steps? Appreciate you responses and guidelines.
Regards,
2 answers
Sort by: Most helpful
-
Garth 4,756 Reputation points MVP
2021-06-30T11:06:13.667+00:00 AllenLiu-MSFT 24,131 Reputation points Microsoft Vendor2021-07-01T06:34:16.71+00:00 Hi, @Sarfraz Aslam
Thank you for posting in Microsoft Q&A forum.
May I know which database file do you specifically refer to?
Is the size of the database almost beyond the SQL drive size?
If the response 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.