Jump to content


Search the Community

Showing results for tags 'Move database'.



More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Forums

  • Cloud
    • Azure
    • Microsoft Intune
    • Office 365
  • General Stuff
    • General Chat
    • Events
    • Site News
    • Windows News
    • Suggestion box
    • Jobs
  • MDT, SMS, SCCM, Current Branch &Technical Preview
    • How do I ?
    • Microsoft Deployment Toolkit (MDT)
    • Official Forum Supporters
    • SMS 2003
    • Configuration Manager 2007
    • Configuration Manager 2012
    • System Center Configuration Manager (Current Branch)
    • Packaging
    • scripting
    • Endpoint Protection
  • Windows Client
    • how do I ?
    • Windows 10
    • Windows 8
    • Windows 7
    • Windows Vista
    • Windows XP
    • windows screenshots
  • Windows Server
    • Active Directory
    • Microsoft SQL Server
    • System Center Operations Manager
    • KMS
    • Windows Deployment Services
    • NAP
    • Failover Clustering
    • PKI
    • Windows Server 2008
    • Windows Server 2012
    • Windows Server 2016
    • Windows Server 2019
    • Hyper V
    • Exchange
    • IIS/apache/web server
    • System Center Data Protection Manager
    • System Center Service Manager
    • System Center App Controller
    • System Center Virtual Machine Manager
    • System Center Orchestrator
    • Lync
    • Application Virtualization
    • Sharepoint
    • WSUS

Find results in...

Find results that contain...


Date Created

  • Start

    End


Last Updated

  • Start

    End


Filter by number of...

Joined

  • Start

    End


Group


AIM


MSN


Website URL


ICQ


Yahoo


Jabber


Skype


Location


Interests

Found 1 result

  1. 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. Link http://smsimpossible.blogspot.de/2012/09/how-to-move-databases-for-sccm-2012.html 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
×
×
  • Create New...