Post reply

Can we restore SQL2000 database BackUp to SQL 7

  • October 16, 2010 at 3:28 am

    #147374

    Hi Guru,

    I know that there is campt. Level of SQL 7 is 70 and SQL2000 hase 80, And also I know SQL 2k5 backup cannot be restore on SQL2K, My Question is, May I Restore or attach SQL 2K database to SQL 7,

    Pls help me my client hav SQL server7. and in My delevelopment Inv. We have Minimum Ver. of SQL Server is 2000.

    Thanks in Advance

    Ali
    MCTS SQL Server2k8

  • October 16, 2010 at 3:38 am

    #1237967

    no you cannot. backups are forward compatible, but not backwards compatible...meaning SQL 7 could restore a backup from version 6.5, but not any backups from 2000/05/08.

    instead you'll want to use SQL 2000's DTS Import/export wizard to connect to the SQL 7database. and use it to migrate the tables and data/procedures/views.

    if you do not have access to their server, you will need to install SQL 7 locally, do that exact same migration with the wizard, and then do a backup from that local SQL 7, which you can then send to the client.

    another option is to try and force the client to upgrade to a higher version, so they could restore your SQL2000 backup in 2000/05/08.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • October 16, 2010 at 3:53 am

    #1237969

    Hi

    Thank You Lowell;

    for quick response. I got the Clear Answer which is'NOT' thanks!

    Ali
    MCTS SQL Server2k8

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

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