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,

    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
Reply
  • 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
Children
No Data