Thread Info
  • State Verified Answer
  • Locked Locked
  • Replies 5 replies
  • Subscribers 1 subscriber
  • Views 2743 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.
Parents
  • 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
Reply
  • 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
Children
No Data