SQL Server Performance

Restore of DB

Discussion in 'General DBA Questions' started by sns_subash2002@yahoo.com, Jan 11, 2010.

  1. sns_subash2002@yahoo.com New Member

    Hi,
    Can we restore Database backup from Developer Edition of SQL Server 2005 to Enterprise Edition of SQL Server 2005.

    Can you responed me ASAP.
    Thanks,
    Srinivas Sista
    sns_subash2002@yahoo.com, Jan 11, 2010
    #2

  2. Luis Martin Moderator

    Yes.
    Luis Martin, Jan 11, 2010
    #3

  3. sns_subash2002@yahoo.com New Member

    Hi,
    I mean Database migration i.e side by side or upgrade.
    Thanks for your reply.

    Thanks,
    Srinivas Sista
    sns_subash2002@yahoo.com, Jan 11, 2010
    #4

  4. Luis Martin Moderator

    If you backup any user database with sql 2005 workgroup, standard, enterprise or developer you can restore in any sql 2005 version.
    The differences between versions apply about capabilities like: replication, amount of memory, some tools etc.
    Now, you wrote a question in sql 7, 2000 forums but about sql 2005. So, can you developer what is your real situation?.
    Thanks,
    Luis Martin, Jan 11, 2010
    #5

  5. ghemant Moderator

    If you are asking about the Migration, I would suggest to go for side-by-side that would be safer way.
    ghemant, Jan 12, 2010
    #6

  6. satya Moderator

    Your best bet is to BACKUP & RESTORE than go by UPGRADE option, in addition to this make sure to script logins & SSIS packages too.
    satya, Jan 13, 2010
    #7

  7. moh_hassan20 New Member

    Be sure that data of the development is the the last version of the user data , otherwise you will overwrite the old data.
    moh_hassan20, Jan 14, 2010
    #8

  8. Luis Martin Moderator

    About you ASAP question, did you resolve the problem?
    Luis Martin, Jan 14, 2010
    #9

  9. sns_subash2002@yahoo.com New Member

    Hi,
    No Still struglling, actaully I am installing SQL Server 2005 EE with backwards compatability so that I can restore this SQL Server2000 backup on this new instance.

    But while installing I got an message which is prompted as " An installtion package for the product MS backwards compatability will not be found. Try installation again using valid copy of Installtion package sqlserver2005_bc.msi.
    Can you tell me what should I do?
    Quick help is appricated.

    Thanks,
    Srinivas Sista
    sns_subash2002@yahoo.com, Jan 21, 2010
    #10

  10. sns_subash2002@yahoo.com New Member

    Adding to my presvious help i have sql server 2005 developer edtion with out any service pach.
    THanks
    Srinivas Sista
    sns_subash2002@yahoo.com, Jan 21, 2010
    #11

  11. Luis Martin Moderator

    Download Windows installer cleanup utility and uninstall completely. Refer these links for more information, http://support.microsoft.com/kb/909967
    After that install sql from a fresh copy.
    Luis Martin, Jan 21, 2010
    #12

  12. sns_subash2002@yahoo.com New Member

    Hi,
    Below is the exc that needs to be run to have the backward complatabilty.
    SQLServer2005_BC.msi
    THank you,
    Srinivas Sista
    sns_subash2002@yahoo.com, Jan 24, 2010
    #13

Share This Page