I searching for a way to move the sql database of an secondary site to my partition D:.
Currently, my database is stored on Partition C: like default but I running out of space on this partition and can not clean up space anymore.
I googled arrount but did not found a proper solution for it
The way i found was like follow:
1.Stop site server using (Configuration Manager site installation folder)\bin\X64\00000409\preinst.exe /STOPSITE
2.On SQL Server for SCCM DB
a. Detach CM_(Site Code)
b. Move both files (mdf and ldf)
c. Attach CM_(Site Code) to new SQL Server run the following stored procedure as a query: sp_configure ‘clr enabled’,1; reconfigure.
d. Enable common language runtime (CLR) integration
e. Verify SCCM Site servers are Local Administrators on the SQL server
f. Add the site server system account as login account with admin rights to SQL
3.On SCCM Server
a. Run Configuration Manager Setup Wizard using Setup.exe from (Configuration Manager site installation folder)\BIN\X64\setup.exe. Not from install media- you won't have the same options.
b. Choose site maintenance or reset site
c. Select Modify SQL Server configuration
d. After wizard finishes restart SCCM site server
e. In SCCM console update the properties of the Reporting Services Point role to use the SCCM Databse on the new server. Administration>Servers and Site System Roles>Pick the server with the Reporting Services Point Role>Pick Reporting services point>Right click and choose properties>Change Site Database Server name.
When I try to run setup.exe on secondary site all options are greyed out. I also tried to use setup.exe of installation folder on Main site where I can select Site Maintenance.
But when I want to connect to my SQL database on the secondary site I get an error message:
"configuration manager site require a supported sql server version...*"
I don't have a clue why this happens. I used the feature of automatically install sql server on secondary site.
Could be the problem that this only works with SQL Standard instead of express which will be used by pushing installation of secondary site over Console?
I would appreciate any kind of help!