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
