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-03 : 01:03:42
|
| Hello All.I have 3 boxes of sql 7 with each box having atleast 10 databases. Now, I have to conslidate these three boxes into 1 sql server 7.0. What is the best method possible to do the above...??If I use backup and restore, then how do I overcome the problem of orphan logins?? Each box has atleast 20-30 logins. Pls. advice.Tx in advance.....Regards |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2004-01-03 : 01:57:07
|
| didn't you first post this question here? http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=31498also, are you using Windows authentication or SQL authentication for your users? if you are using Windows authentication then orphaned logins are not a problem if you are in the same domain.-ec |
 |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2004-01-03 : 23:20:02
|
| If you can afford the downtime, it might be faster to do detach/attach instead of backup/restore. You'll still have to deal with orphaned logins, but the link Damian provides is great. You also might want to review my articles on going from SQL 7 to SQL 2000. Even though you're not updating, the steps still basically apply.Article Part 1Article Part 2--------------------------------------------------------Visit the SQLTeam Weblogs at [url]http://weblogs.sqlteam.com[/url] |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-01-05 : 14:26:15
|
| Chad's script fixes the orphaned users. It does not create them. In order for sp_change_users_login to work, the account must exist (for service pack 3a and higher at least, prior to service pack 3a it creates an account for you but with a blank password) first. To create the accounts, you can use DTS or isp_Transfer_Logins stored procedure which I created. Search the forums for it if you would like to use it. It uses linked servers.Tara |
|
|
|
|
|
|
SQL Server Consolidation !!!