Migration from server to server

  • rrizzojr

    SSC Rookie

    Points: 32

    I recently migrated from Windows 2003 SBS running SQL 2005 Express along with SSMS 2005 Express. The new server is Windows 2008 R2 SP1 and has SQL 2008 R2 Express and SSMS 2008 Express

    When I restore the Database it appeared to populate in the LEFT Pane of SSMS but when clicking on an object in the left pane it doesn't show in RIGHT Side Pane.

    Why wouldn't info show up on right side of new server whereas it shows up on old server

    Attachments:
    You must be logged in to view attached files.
  • frederico_fonseca

    SSChampion

    Points: 14085

    In SQL Server 2005 Management Studio:

    View Menu -> Summary (or F7)

    In SQL Server 2008 Management Studio:

    View Menu -> Object Explorer Details (or F7)

    pretty useless though - as soon as you got any query window open the only way to show it is to hit F7 (in both versions)

    and the info it shows is also on object explorer

  • Phil Parkin

    SSC Guru

    Points: 243596

    rrizzojr wrote:

    I recently migrated from Windows 2003 SBS running SQL 2005 Express along with SSMS 2005 Express. The new server is Windows 2008 R2 SP1 and has SQL 2008 R2 Express and SSMS 2008 Express When I restore the Database it appeared to populate in the LEFT Pane of SSMS but when clicking on an object in the left pane it doesn't show in RIGHT Side Pane. Why wouldn't info show up on right side of new server whereas it shows up on old server

    'New' isn't the first word that comes to mind when you mention W2008 and SQL Server 2008! No doubt you have your reasons, but you're missing out on a lot of good stuff ('product support', for example) by being so far behind.

    If the answer to your question can be found with a brief Google search, please perform the search yourself, rather than expecting one of the SSC members to do it for you.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply