SQL Server Performance

How can we copy the Database from Existed Data base in the SQL server 7.0?

Discussion in 'T-SQL Performance Tuning for Developers' started by mallik143_swa, Aug 30, 2007.

  1. mallik143_swa New Member

    How can we copy the Database from Existed Data base in the SQL server 7.0 or T-SQL?
    Please give me solution ...
    Thank you
    Malli
  2. Luis Martin Moderator

    Backup and restore?
  3. Adriaan New Member

    It isn't really clear what you're asking ...
    You have an existing database that you want to copy, and you talk about SQL 7.0.
    Do you have an instance of SQL Server 7.0 with a database, and you want to copy the database to an instance of SQL Server 2000 or 2005?
    Or do you have a backup (or just the MDF and LDF files) of a SQL 7.0 database, and you want to load this on an instance of SQL Server 2000 or 2005?
    Please elaborate!
  4. satya Moderator

    True, in this case you have to very clear about what you want.
    Also Luis gave the hint there to get you more information.
  5. Jack Vamvas Member

    Depending on what servers these dbs are running, you could generate the T-sql for all the objects from your sql 7 , and rerun the scripts in your sql 2000/2005 setup.

Share This Page