SQL Server Performance Forum – Threads Archive
Restoring masterHi.. 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
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…
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