attaching all databases

I have a Windows 2003 Server that has my Sql Server 2000 on it. We started
having problems with it today and we think we may have had a virus, but were
not sure.
We are going to reinstall the OS as well as Sql Server.
I had moved the Data Directory to another machine (or 2) and would like to
install the server then move all the databases back to the new data
Directory, including the Master.
I know how to attach the other databases, but how do I go about attaching
the Master? You can't detach it, apparently.
But I need the Logins from the Security folder (from Enterprise Manager) and
I think they are in the Master database. The user permissions for each
databases are with the database, but I also need the Master (don't I?).
Thanks,
TomHi
To move logins between servers search for sp_help_revlogin on internet
"tshad" <tfs@.dslextreme.com> wrote in message
news:eKKOCs8$FHA.980@.tk2msftngp13.phx.gbl...
>I have a Windows 2003 Server that has my Sql Server 2000 on it. We started
> having problems with it today and we think we may have had a virus, but
> were
> not sure.
> We are going to reinstall the OS as well as Sql Server.
> I had moved the Data Directory to another machine (or 2) and would like to
> install the server then move all the databases back to the new data
> Directory, including the Master.
> I know how to attach the other databases, but how do I go about attaching
> the Master? You can't detach it, apparently.
> But I need the Logins from the Security folder (from Enterprise Manager)
> and
> I think they are in the Master database. The user permissions for each
> databases are with the database, but I also need the Master (don't I?).
> Thanks,
> Tom
>|||You can transfer login using DTS Transfer login task also.
to move system databses look at
http://www.databasejournal.com/feat...le.php/3379901.
Regards
Amish|||"amish" <shahamishm@.gmail.com> wrote in message
news:1134479748.071112.286050@.g43g2000cwa.googlegroups.com...
> You can transfer login using DTS Transfer login task also.
> to move system databses look at
> http://www.databasejournal.com/feat...le.php/3379901.
That looks like what I want to do.
I was concerned when the article mentioned that the Master had to be in the
correct path that you set up or it wouldn't start.
What I was thinking about doing is just stopping Sql Server. Move the old
Master files out and then just move the new Master files into the same Data
folder. Then I wouldn't have to worry about mistyping the path. The only
reason I am doing this is to make sure that we have the current data on my
temporary machine.
What about the other databases?
Do I need to detach and reattach the databases before or after I move the
Master - or do I need to do it at all?
Thanks,
Tom

>
> Regards
> Amish
>|||Hi
Running DTS Package to move logins is not a good idea because it does not
transfer an origina SID of the logins and you still may have users not
mapped to logins
"tshad" <tscheiderich@.ftsolutions.com> wrote in message
news:uiawZPAAGHA.2656@.tk2msftngp13.phx.gbl...
> "amish" <shahamishm@.gmail.com> wrote in message
> news:1134479748.071112.286050@.g43g2000cwa.googlegroups.com...
> That looks like what I want to do.
> I was concerned when the article mentioned that the Master had to be in
> the correct path that you set up or it wouldn't start.
> What I was thinking about doing is just stopping Sql Server. Move the old
> Master files out and then just move the new Master files into the same
> Data folder. Then I wouldn't have to worry about mistyping the path. The
> only reason I am doing this is to make sure that we have the current data
> on my temporary machine.
> What about the other databases?
> Do I need to detach and reattach the databases before or after I move the
> Master - or do I need to do it at all?
> Thanks,
> Tom
>
>|||"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:%230HZzBIAGHA.3268@.TK2MSFTNGP10.phx.gbl...
> Hi
> Running DTS Package to move logins is not a good idea because it does not
> transfer an origina SID of the logins and you still may have users not
> mapped to logins
But my problem is that I had to completely rebuild my 2003 machine and I
named it the same name. I also reinstalled my Sql Server 2000.
I saved multiple copies of my Data Folder and would like to just put that
back as we before we went down.
Isn't there a way to do this?
When you reinstall the database, you get a new Master database and I just
want to replace that one with my old one. What if you have 300 logins in
your database? I wouldn't want to reinput all those by hand.
I did try to move the Master to my other machine and it would start. This
makes sense, since the machine had a different name. But what about the
same machine same name?
Thanks,
Tom
>
> "tshad" <tscheiderich@.ftsolutions.com> wrote in message
> news:uiawZPAAGHA.2656@.tk2msftngp13.phx.gbl...
>|||If login is only the problem them user sp_help_revlogin as suggested by
Uri ,
http://support.microsoft.com/default.aspx?kbid=246133
Just use it ,create script and run it to create login.
But ,If you have other data in master and msdb like sp, function ,
jobs and backup history then
make sure you have same version and Service Pack as old one.
Replace new installed msdb and master with old one using
http://www.databasejournal.com/feat...le.php/3379901.
OR
you can also restore them from its backup also.
Before moving Master and Msdb first put all the databases at same
previous location.