Post reply

Log shipping SQL 2008 from SQL 2008?

  • January 19, 2012 at 8:44 am

    #1435927

    I had set up log shipping from 2005 instance to 2008 instance. The only problem I had was connecting to the 2008 instance via the management studio on the server which had sql server 2005 installed.

    So I used the management studio on the server with sql server 2008 to connect to both the instances. And I configured everything via 2008 management studio.

    I would assume that Enterprise manager will not be able to connect to a SQL Server 2008 instance. So you can try using management studio 2008 instead.

    http://saveadba.blogspot.com/

    Blog
    http://saveadba.blogspot.com/

  • January 23, 2012 at 12:24 am

    #1436952

    savethytrees (1/19/2012)

    I had set up log shipping from 2005 instance to 2008 instance. The only problem I had was connecting to the 2008 instance via the management studio on the server which had sql server 2005 installed.

    So I used the management studio on the server with sql server 2008 to connect to both the instances. And I configured everything via 2008 management studio.

    As far as i know, you can patch SQL server 2005 to SQL Server 2005 SP2, and after that we can connect to 2008 instance via SSMS 2005.

Viewing 2 posts - 16 through 16 (of 16 total)

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