Post reply

log shipping from sql 2008 64bit to sql 2005 32 bit

  • April 13, 2010 at 7:20 pm

    #217864

    i am creating strategy to upgrade my production sql 2005 32 bit to sql 2008 64 bit that includes BCP/Disaster recovery site also

    scnerio

    server A is mirrored with server B and both log ship to BCP/DR server c

    now plan is

    1)upgrade server B with flat and rebuild (by this time log shipping is still working to server C)

    2)once testing is done on server B which is now sql 2008 ,now mirror failover to Server B and take out server A for upgrade

    but the question here is since server B already upgraded to 2008 will log shipping be supported for my BCP server C? if not what is the alternative

    Thanks!!

  • April 13, 2010 at 9:16 pm

    #1151116

    SQL Server 2005 will not be able to read the log backups from SQL Server 2008. I think your alternative is to upgrade the log shipping destination first, then the mirrored server, then the principal server.

  • April 13, 2010 at 9:35 pm

    #1151118

    thanks , so it looks even mirroring will not work from sql 2008 to sql 2005?

  • April 13, 2010 at 10:54 pm

    #1151128

    sqlquery-101401 (4/13/2010)

    thanks , so it looks even mirroring will not work from sql 2008 to sql 2005?

    Not sure. Don't have SQL Server 2005 where I can test it. If it works, it would be from 2005 to 2008.

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

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