SQL Server Performance

Going Back from 2005 to 2000

Discussion in 'SQL Server 2005 General DBA Questions' started by luisinfo, Jul 19, 2007.

  1. luisinfo New Member

    Hello,
    We are going to change our SQL 2000 for a new (physical) server with SQL 2005. We need a plan so, if something goes wrong, we can go back to SQL 2000. The process will be to stop SQL 2000, backup DB and then restore it on SQL 2005 and beging operating with the new server. The problem is that, if we find any problem we will go back to SQL 2000, but we need to pass the new information that is in SQL 2005 but not in SQL 2000. We can not do a backup in SQL 2005 and restore it on SQL 2000. Can anybody offer us any solution?. We are thinking on having any utility like Log Explorer or something like that to get all the transactions form the Log in SQL 2005 and then re-execute then on the SQL 2000.
    Thanks a lot for your help.
    Luis.
  2. spirit1 New Member

    http://weblogs.sqlteam.com/mladenp/archive/2007/02/15/60101.aspx

    _______________________________________________
    Causing trouble since 1980
    blog:http://weblogs.sqlteam.com/mladenp
  3. luisinfo New Member

    Hello spirit1,
    Thanks a lot for your help, I am going to try to do what is says to see if that solution is ok for my system.
    Luis.
  4. dineshasanka Moderator

    how about transfering data from SSIS. you can do a lookup and transfer data which is not in 2000 but in 2005


    ----------------------------------------
    Contributing Editor, Writer & Forums Moderator
    http://www.SQL-Server-Performance.Com

    Visit my Blog at
    http://dineshasanka.spaces.live.com/
  5. satya Moderator

  6. ndinakar Member

    You can also set up replication from 2005 to 2000 servers as a backup option.

    ***********************
    Dinakar Nethi
    ***********************
    http://weblogs.sqlteam.com/dinakar/
  7. satya Moderator

    Hot from oven,<a target="_blank" href=http://sqlserver-qa.net/blogs/tools/archive/2007/07/20/downgrade-or-revert-or-restore-sql-server-2005-database-to-sql-server-2000-version.aspx>http://sqlserver-qa.net/blogs/tools/archive/2007/07/20/downgrade-or-revert-or-restore-sql-server-2005-database-to-sql-server-2000-version.aspx</a> blogged the process to revert back. [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><br /><b>Satya SKJ</b><br />Microsoft SQL Server MVP<br />Writer, Contributing Editor & Moderator<br /<a target="_blank" href=http://www.SQL-Server-Performance.Com>http://www.SQL-Server-Performance.Com</a><br />@<a target="_blank" href=http://www.askasqlguru.com/>http://www.askasqlguru.com/</a><br /><br /><center><font color="teal"><font size="1">This posting is provided AS IS with no rights for the sake of <i>knowledge sharing. <hr noshade size="1">Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.</i></font id="size1"></font id="teal"></center>
  8. MichaelB Member

    you and your oven...hehe<img src='/community/emoticons/emotion-1.gif' alt=':)' /><br /><br />Michael <br />MCDBA<br /><br />"The statistics on sanity are that one out of every four persons is suffering from some sort of mental illness. Think of your three best friends -- if they're okay, then it's you!"
  9. satya Moderator

    [<img src='/community/emoticons/emotion-5.gif' alt=';)' />]why not... what do you think?<br /><blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by MikeEBS</i><br /><br />you and your oven...hehe<img src='/community/emoticons/emotion-1.gif' alt=':)' /><br /><br />Michael <br />MCDBA<br /><br />"The statistics on sanity are that one out of every four persons is suffering from some sort of mental illness. Think of your three best friends -- if they're okay, then it's you!"<br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote">
  10. MichaelB Member

    It is well done. Just the choice of words for the brain<img src='/community/emoticons/emotion-1.gif' alt=':)' /> LOL<br /><br />Michael <br />MCDBA<br /><br />"The statistics on sanity are that one out of every four persons is suffering from some sort of mental illness. Think of your three best friends -- if they're okay, then it's you!"
  11. luisinfo New Member

    Hi Everybody,
    Somebody has told me a new possibly solution.

    1.- Set Log Shipping between 2000 (publisher) and 2005 (subscriber)
    2.- On 'D' day cut off Log Shipping
    3.- Set tansactional replication between 2005 (publisher) and 2000 (subscriber)

    I will let you know if the test works fina.

    Thanks to everybody for your help...

    Luis.
  12. MohammedU New Member

    Yes, it is possible solution...
    But step 3 which setting transactional replication from 2005 to 2000 should be fine but all objects should have the primary key and for smaller dbs it should be fine...


    MohammedU.
    Microsoft SQL Server MVP
    Moderator
    SQL-Server-Performance.com

    All postings are provided “AS IS” with no warranties for accuracy.
  13. satya Moderator

    That is what Dinaker referred above [<img src='/community/emoticons/emotion-5.gif' alt=';)' />]<br /><blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by luisinfo</i><br /><br />Hi Everybody,<br />Somebody has told me a new possibly solution.<br /><br />1.- Set Log Shipping between 2000 (publisher) and 2005 (subscriber)<br />2.- On 'D' day cut off Log Shipping<br />3.- Set tansactional replication between 2005 (publisher) and 2000 (subscriber)<br /><br />I will let you know if the test works fina.<br /><br />Thanks to everybody for your help...<br /><br />Luis.<br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br /><br /><b>Satya SKJ</b><br />Microsoft SQL Server MVP<br />Writer, Contributing Editor & Moderator<br /<a target="_blank" href=http://www.SQL-Server-Performance.Com>http://www.SQL-Server-Performance.Com</a><br />@<a target="_blank" href=http://www.askasqlguru.com/>http://www.askasqlguru.com/</a><br /><br /><center><font color="teal"><font size="1">This posting is provided AS IS with no rights for the sake of <i>knowledge sharing. <hr noshade size="1">Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.</i></font id="size1"></font id="teal"></center>

Share This Page