Thread Info
  • State Verified Answer
  • Locked Locked
  • Replies 5 replies
  • Subscribers 1 subscriber
  • Views 2741 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

SQL upgrade

tedz

Hi,

Any advice of our sophos sql express 2008 upgrade to sql express 2008 R2?

Thanks,

tedz

:27255


This thread was automatically locked due to age.
  • 0

    HI,

    Should go fine, I would suggest backing up the Sophos databases first thought just to be safe.  

    You don't mention which version you're running but you can see the database to versions here
    http://www.sophos.com/en-us/support/knowledgebase/17323.aspx

    Details on backing them up with backupdb.bat is here:

    http://www.sophos.com/en-us/support/knowledgebase/110380.aspx

    You may also wish to drop any databases no longer required:

    http://www.sophos.com/en-us/support/knowledgebase/17508.aspx

    Regards,

    Jak 

    :27257
  • 0

    Hi,

    How can i check space of sophos Database when they upgrade sql server 2008 to sql server 2008 r2?

    Im using Windows Server 2003 SP2 for my SEC Server.

    Thanks,

    Tedz

    :27303
  • 0

    Hi,

    There are many ways to do this, I've listed a few below.

    If you have the SQL Server Managent Studio you can connect to the SQL instance and view the properties of the databases, i.e. SOPHOS51, SOPHOSPATCH51 and SOPHOSENC51.

    You could just look at the files on disk, e.g.

    C:\Program Files\Microsoft SQL Server\[instance]\MSSQL\DATA\SOPHOS51.mdf

    C:\Program Files\Microsoft SQL Server\[instance]\MSSQL\DATA\SOPHOS51_log.ldf

    C:\Program Files\Microsoft SQL Server\[instance]\MSSQL\DATA\SOPHOSENC51.mdf

    C:\Program Files\Microsoft SQL Server\[instance]\MSSQL\DATA\SOPHOSENC51_log.ldf

    C:\Program Files\Microsoft SQL Server\[instance]\MSSQL\DATA\SOPHOSPATCH51.mdf

    C:\Program Files\Microsoft SQL Server\[instance]\MSSQL\DATA\SOPHOSPATCH51_log.ldf

    or from a command prompt, get the database_size by running::

    sqlcmd -E -S .\sophos -d sophos51 -Q "sp_spaceused"

    sqlcmd -E -S .\sophos -d sophospatch51 -Q "sp_spaceused"

    sqlcmd -E -S .\sophos -d sophosenc51 -Q "sp_spaceused"

    where .\sophos represents a local SOPHOS named SQL instance, which is the default.

    Regards,

    Jak

    :27345
  • 0

    Hi Jak,

    Thanks for the reply. That is the result for the sql server 2008 r2 database_size by running sophos50.

    I douth for the database_size for the upgrade of sql server 2008 to sql server 2008 r2 cause I dont want to see the 10gb size of database.


    C:\>sqlcmd -E -S .\sophos -d sophos50 -Q "sp_spaceused"
    database_name
                                                     database_size      unallocated
    space
    --------------------------------------------------------------------------------
    ------------------------------------------------ ------------------ ------------
    ------
    SOPHOS50
                                                     24.25 MB           0.80 MB

    reserved           data               index_size         unused
    ------------------ ------------------ ------------------ ------------------
    14800 KB           11464 KB           2760 KB            576 KB

    Thanks,

    tedz

    :27361
  • 0

    HI,

    SQL Express 2008 R2 has a database limit of 10GB (2005/2008 was only 4GB), but it looks like you're no where near that.

    Regards,

    Jak

    :27363