New Database file for SCCM

Sarfraz Aslam 166 Reputation points
2021-06-30T10:05:13.997+00:00

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,

Microsoft Configuration Manager
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Garth 5,801 Reputation points
    2021-06-30T11:06:13.667+00:00

    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,316 Reputation points Microsoft Vendor
    2021-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.