Post reply

Log shipping SQL 2008 from SQL 2008?

  • December 11, 2011 at 9:36 pm

    #248008

    Hi,

    Can we possible for configure log shipping between SQL 2000 and SQL 2008?

    Primary server

    windows server 2003 enterprise edition.'

    SQL server 2000 enterprise edition. SP4

    Database size - 450 GB

    Secondary server

    windows server 2008 enterprise edition R2 - 64 bit

    SQL server 2008 enterprise edition. SP3 - 64 bit

    Thanks

    ananda

  • December 12, 2011 at 12:30 am

    #1419874

    No, Not possible..

    DR Server should be same version and same edition.

  • December 12, 2011 at 6:57 am

    #1420056

    this question has been raised before, yes it is possible but there are caveats around it

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • December 12, 2011 at 7:16 am

    #1420065

    It’s right time for planning a database upgrade 😉

  • December 16, 2011 at 3:32 am

    #1422359

    Dev (12/12/2011)

    It’s right time for planning a database upgrade 😉

    Hi Dev,

    It is right for upgrade sql server 2000 to SQL server 2008.

    I am not getting more downtime for upgrade sql 2000 to 2008 and 750 GB database size. so in this case planning for upgrade sql server 2008 through log shipping.

    could anyone advise and give me step by step document for implement log shipping sql 2000 to sql 2008.

    regards

    ananda

  • December 16, 2011 at 6:42 am

    #1422465

    ananda.murugesan (12/16/2011)

    Dev (12/12/2011)

    It’s right time for planning a database upgrade 😉

    Hi Dev,

    It is right for upgrade sql server 2000 to SQL server 2008.

    I am not getting more downtime for upgrade sql 2000 to 2008 and 750 GB database size. so in this case planning for upgrade sql server 2008 through log shipping.

    could anyone advise and give me step by step document for implement log shipping sql 2000 to sql 2008.

    regards

    ananda

    Just wanted to know why do you want to use Log Shipping for the upgrade? You can just backup the primary Server and restore it to the secondary with no recovery, then just restore any differential and transaction log backups you may have taken on the primary. I don't think you need to setup log shipping.



    My blog

  • December 18, 2011 at 10:51 pm

    #1422957

    Hi Ignacio A. Salom Rangel,

    Very curious to knew about this, is it possible to take database backup from sqlserver 2000 and restore on sql 2008.

    -- Babu

  • December 19, 2011 at 1:53 am

    #1422983

    Sure! You can always make a full backup of a SQL2000 Server and restore it on a SQL 2008 Server. I'm not sure how would that work with the diferential backups! But I will test it and let you know.



    My blog

  • December 19, 2011 at 2:44 am

    #1422996

    I just tested and it works! You restore the full backup with norecovery and the you restore the differential. The conversion to 2008 only occurs after the last restore. I hope this helps. Good luck. 🙂



    My blog

  • December 20, 2011 at 11:08 am

    #1423827

    once you complete the restore and upgrade from 2000 to 2008 you must run the following against the database

    DBCC UPDATEUSAGE

    Followed by

    DBCC CHECKDB WITH DATA_PURITY

    Then go rebuild all your indexes 😉

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • December 21, 2011 at 2:32 am

    #1424088

    Thank you very much Ignacio A. Salom Rangel.

  • December 21, 2011 at 1:59 pm

    #1424458

    baabhu (12/21/2011)

    Thank you very much Ignacio A. Salom Rangel.

    You are very welcome 😉



    My blog

  • January 14, 2012 at 6:56 am

    #1433690

    Maybe u have to set db compatible level

  • January 18, 2012 at 4:05 am

    #1435109

    It would be nice if you provide some more information about this.

    online perfume | cheap perfume

  • January 18, 2012 at 4:10 am

    #1435112

    gellytacy (1/18/2012)

    It would be nice if you provide some more information about this.

    Could you be more specific about the information you would like to get?



    My blog

Viewing 15 posts - 1 through 15 (of 16 total)

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