SQL Server Performance

Restoring master

Discussion in 'Getting Started' started by khchaitanyaprabhu, Jun 15, 2007.

  1. khchaitanyaprabhu New Member

    Hi..

    I am trying to restore master of sql 7 on sql 2k.
    It throws error as master of earlier version cannot be restored.

    Can anyone guide me.

    Thanks

  2. satya Moderator

  3. MohammedU New Member

    To restore system database you have to have same build...
    Only option left is scrpting logins and linked server information... follow the link Satya mentioned...


    MohammedU.
    Moderator
    SQL-Server-Performance.com

    All postings are provided “AS IS” with no warranties for accuracy.
  4. khchaitanyaprabhu New Member


    The resorece link provided is found to be useful,

    now ,i am able to copy login details from sql 7 to sql 2k by creating DTS package.

    Thank you

Share This Page