Jump to content


Sign in to follow this  
Staudi

Move Database of Secondary Site do another Partition

Recommended Posts

Hello,

 

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! :)

 

Thanks

 

Staudi

 

 

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
Sign in to follow this  

×
×
  • Create New...