SQL Server Performance

About SQL Server 7.0

Discussion in 'General DBA Questions' started by manu_dba, May 11, 2006.

  1. manu_dba New Member

    I have never used sql 7. but today..i will be given access to one of the servers
    having sql 7.
    can anyone plese give me an idea does enterprise manager in sql 7 also workes like sql 2000

    actually there is a database on that server and i have to firts check the consistency of that database and also to take full backup..
    that i can do but is the user interface and everything is same.

    and i have to move the database one of the production cluster.

    can you please guide me that if i use copy wizard of sql 2000 prod cluster to move that sql server 7 database will i face any problme in that.

    thanks
  2. thomas New Member

    Yes the tools are pretty much the same, and yes the v. 2000 Copy Database wizard will work with a v.7 database.
  3. manu_dba New Member

    when we copy database from one server to another through copy wizard.
    at one step it asks to copy..logins, stored proceduer shared by master, jobs and all

    so should i cehck these boxes or not..because i was trying to copy a sample database to another server it is giving me errors.

    do i need to change the properties of database the one i have to copy. like single user mode and all..please guide me...

    thanks
  4. thomas New Member

    I guess you don't want the logins (it's up to you though), and definitely not SPs shared by master, jobs etc, if you're just copying a sample database. you shouldn't have to use single user mode either.
  5. manu_dba New Member

    thanks thoma..
    actually in real environmnet i have to copy or move a database that is in production environment from sql 7.0 to sql2000 production cluster.

    in that case what should i do in that step...

    please advice methat how i can move or copy that database from sql 7 to sql 2000production cluster in such a manner there should not be any problem..
    i need your suggestions please
  6. satya Moderator

    Links on upgrading SQL server, fyi:
    http://vyaskn.tripod.com/moving_sql_server.htm
    http://support.microsoft.com/?id=260758 - faq about upgrading on cluster.
    http://www.sqlteam.com/item.asp?ItemID=9066 - upgrade gotchas.
    http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/sqlugrd.mspx
    http://securitypronews.com/it/datab...QLServer70ClustertoaSQLServer2000Cluster.html

    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

Share This Page