SQL Server Performance Forum – Threads Archive

Restoring master

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

---

The error is by default and why you are restoring master database, is it for logins.
If so KBAhttp://support.microsoft.com/default.aspx?scid=kb;en-us;246133 will help you. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.

---

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.

---

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

---

]]>