Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
nishithrn
Yak Posting Veteran
58 Posts |
 Posted - 2004-01-28 : 05:58:49
|
| Hello Again,Two Questions...1. Is it possible to restore master of sql7 over sql2000.??2. Is it possible to restore master of a default instance (sql2000) on a named instance (sql2000)..??For Q2 above, I did the following things...a. Backed up master from source server and moved the backup files to the target server.b. Started sql server instance in a single user mode with the following command on target server: sqlservr -s<instance name> -mc. Restored master on target server.Note:After "Point C" above, when I try to start sql services, the same gets started but stops after 5-10 seconds. I tried to rebuilt the master, however, the same gave me an error "cannot restor master error:1".Pls. tell me whether the steps I follow are correct. if not, what are the correct steps to restore master database on a named instance.Thanks in advance.....Nishith |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-01-28 : 12:17:16
|
| No, you can not restore SQL 7.0 master over SQL 2000.I would not recommend doing number 2, but yes it is possible.Why do you want the master database restored to a different location? Whatever it is that you need out of there, we can help you export it.Tara |
 |
|
|
nishithrn
Yak Posting Veteran
58 Posts |
Posted - 2004-01-29 : 02:44:06
|
| Hi Tara, Tx for your reply.The scene is, I have sql 2000 installed on a box on a default instance, which as atleast 150 logins. Now, I have to migrate this instance to another box which will be a named instance. Due to the large number of logins, I have thought of the option of doing a master restore.If you have any other method for doing the above, pls. soggest. Also, I would really appreciate if you can tell me if the steps which I followed for "Master Restore" are correct or not.RegardsNishith |
|
|
|
MuadDBA
628 Posts |
Posted - 2004-01-29 : 08:36:27
|
| Can't you just script the logins and all permissions using DTS?Or, if you back up the database, it will get all the database users. Once you restore the database on the new server, you can use sp_change_users_login with the auto_fix option to get those logins set up again.Both are more advisable than copying the master database, especially from one version to the next. |
|
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2004-01-29 : 15:02:59
|
| In my articles on Upgrading from SQL 7 to 2000, I point to a script for moving your logins. It is in Part 2, Task 2: http://www.sqlteam.com/item.asp?ItemID=9465--------------------------------------------------------------Find more words of wisdom at [url]http://weblogs.sqlteam.com/markc[/url] |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-01-29 : 16:02:58
|
| You can also use a stored procedure that I wrote to transfer the logins. Search the forums for isp_Transfer_Logins. It uses linked servers.Tara |
|
|
|
|
|
|
|
|
Master Restore !!!