New Database file for SCCM

Sarfraz Aslam 166 Reputation points

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.


Microsoft Configuration Manager
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Garth 5,801 Reputation points

    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.

  2. AllenLiu-MSFT 40,076 Reputation points Microsoft Vendor

    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.