Thread Info
  • State Not Answered
  • Locked Locked
  • Replies 2 replies
  • Subscribers 1 subscriber
  • Views 1965 views
  • Users 0 members are here
Options
Suggested
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Migrate DBs From SQL 2005 To SQL 2008

ChrisPike

Hi all,

We currently have Sophos Enterprise Console (4.5.0.9) installed on Windows Server 2003 using SQL Server 2005 Standard. We have recently installed SQL Server 2008 Standard on the same server as one of our new products required this. How do we now go about migrating our Sophos DBs to this 2008 instance?

We also have PureMessage (3.0.2.0) installed on the same server, would this be a similar process to above? Any help would be much appreciated.

Cheers,

Chris

:10589


This thread was automatically locked due to age.
  • 0

    Hi,

    I think I can speak for SEC, I assume that PMX is similar in as far as it being largely moving the database and changing a connection string.  Maybe the DB config hta in the tools download:
    http://www.sophos.com/tools/PMWXTools/Support_Tools_PMEx_30.zip
    could help for PMX

    For SEC, I would:

    1. Stop the Sophos Management Service.

    2. backup the SOPHOS45 database from the SQL 2005 instance, e.g.

    sqlcmd -E -S .\sophos -b -Q "BACKUP DATABASE SOPHOS45 TO DISK ='C:\windows\temp\sophos45.bak'"

    Where .\sophos represents the local instance of SQL 2005, adjust as required.  Use the SQL Server Management Studio if you prefer.

    4. Restore the sophos45.bak file into the SQL 2008 instance.  In: \program files\sophosa\enterprise console\db\
    There is a restoredb.bat file.  If you run:


    Restoredb C:\windows\temp\sophos45.bak .\sql2008instance SOPHOS45

    This should restore the SOPHOS45 backup into the SQL 2008 instance.  I've used "sql2008instance" to represent the instance name of the 2008 instance, change as appropriate.  Again use SQL Server Management Studio if you prefer.

    5.  Once you are happy that the SOPHOS45 database is housed in the 2008 instance.  Carry on...


    6. Open Regedit and change:
    hklm\software\[wow6432node]\sophos\ee\management tools\databaseconnectionms
    To reference the new instance. 'Data Source' part..

     

    7. Change:
    hklm\software\[wow6432node]\sophos\ee\management tools\database installer\instance
    to be the new instance name.

    8. Start the Sophos Managment Service again and check that SEC is working,  if not you can always change the above 2 keys and your no worse off.

    Hope that helps.

    Regards,

    Jak

    :10623
  • 0

    Thanks for that, just followed your instructions and they worked perfectly.

    Cheers,

    Chris

    :10783