Jump to content
Sign in to follow this  
t-zwck

Moving your site database

Recommended Posts

This guide will explain how to move your site database to another server.

 

Im using SCCM 2007 (mixed mode), MSSQL 2005 SP3 and Windows 2003 r2 throughout this guide.

My SCCM 2007 Server is called DSGCM1 and my new SQL server is called DSGSQL1

 

Before you begin make sure you have a MSSQL 2005 server setup with atleast SP2. (MSSQL Express is not supported)

 

Before starting the migration you need to check the following:

-----------------------------------------------

1. Make sure you are using the same collation settings on booth your MS SQL servers

This is how to check this:

1. Open Microsoft SQL Server Management Studio

2. Connect

3. Right click on your servername choose properties

4. It will look like this:

Hidden Content

    Give reaction to this post to see the hidden content.

 

If you don´t do this you might end up with allot of status messages saying something like this:

Microsoft SQL Server reported SQL message 468, severity 16: [42000][468][Microsoft][ODBC SQL Server Driver]

Hidden Content

    Give reaction to this post to see the hidden content.

Hidden Content

    Give reaction to this post to see the hidden content.

-----------------------------------------------

 

When you have done all of these check you can go ahead and move your DB.

 

 

 

 

 

 

[size=5][b]This is how to move your site Database to another server:[/b][/size]

 

Begin with putting the SQL Primary site computer account in the Administrators group on your SQL server (the one you are moving your db to)

Hidden Content

    Give reaction to this post to see the hidden content.

 

Then backup your site datbase by going into Microsoft SQL Management Studio. Expand the databases node and rightclick on your site database. Choose "tasks" --> "Back Up.."

Hidden Content

    Give reaction to this post to see the hidden content.

 

Choose to backup to disk and backuptype=Full and then press Add button to choose where to save your backup. This will take some time depending on how big your database is.

Hidden Content

    Give reaction to this post to see the hidden content.

 

Now copy the database from your old server to your new server.

Hidden Content

    Give reaction to this post to see the hidden content.

 

On your new SQL server open Microsoft SQL Server Management Studio. Rightclick on the databases node and choose "Restore Database..."

Hidden Content

    Give reaction to this post to see the hidden content.

 

Write the db name in the "to database:" field. Choose "From Device" and then find your backupfile, mine was located at d:sms_dsg. When file is found make sure your check the restore radio button. Press OK to begin importing the database.

Hidden Content

    Give reaction to this post to see the hidden content.

 

Wait for this message to appear:

Hidden Content

    Give reaction to this post to see the hidden content.

 

Now go to your SCCM 2007 server and find the file "preinst.exe". Should be located where you have installed your SCCM.

Hidden Content

    Give reaction to this post to see the hidden content.

 

Now that you know where your preinst.exe file is located you can run it from the commandprompt with the following switch: /stopsite

In my case the command looked like this: "f:MICROSOFT CONFIGURATION MANAGERbini38600000409preinst.exe" /stopsite

Hidden Content

    Give reaction to this post to see the hidden content.

 

You will get a few messages like these (wait for them all to finish):

Hidden Content

    Give reaction to this post to see the hidden content.

 

On your SCCM site server open "All programs --> Microsoft System Center --> Configuration manager 2007 --> ConfigMgr Setup"

Hidden Content

    Give reaction to this post to see the hidden content.

 

Click next on the first Wizardpage:

Hidden Content

    Give reaction to this post to see the hidden content.

 

Choose to "perform site maintenance or reset this Site". Click next.

Hidden Content

    Give reaction to this post to see the hidden content.

 

Choose "Modify SQL Server Configuration". Click next.

Hidden Content

    Give reaction to this post to see the hidden content.

 

Change "SQL Server and instance, if applicable:". Wite the name of your new SQL server here. Databasename should still be the same! Click Next

Hidden Content

    Give reaction to this post to see the hidden content.

 

Will look something liek this:

Hidden Content

    Give reaction to this post to see the hidden content.

 

When all is completed press next.

Hidden Content

    Give reaction to this post to see the hidden content.

 

Press Finish or view the log if you want

Hidden Content

    Give reaction to this post to see the hidden content.

Hidden Content

    Give reaction to this post to see the hidden content.

 

Now restart your server!

Hidden Content

    Give reaction to this post to see the hidden content.

 

Open ConfigMgr Console and expand "Site Database --> Site management --> Site (in my case DSG - DSG primary Site) --> Site settings --> Site Systems". right click on ConfigMgr site system and choose properties. enter a FQDN for the new server, in my case dsgsql1.dsgdomain.local. Press OK.

Hidden Content

    Give reaction to this post to see the hidden content.

 

Now reset all your status messages

Hidden Content

    Give reaction to this post to see the hidden content.

Hidden Content

    Give reaction to this post to see the hidden content.

Hidden Content

    Give reaction to this post to see the hidden content.

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.

Sign in to follow this  

×
×
  • Create New...