Move logins with passwords

Hello!
I will reinstall my server who has SQL server 2000, containing a few
databases with logins.
Which is the easiest way to store these on disk and when I have reinstalled
my server, add these to SQL again, hopefully containing passwords as well.
Regards Magnushttp://www.support.microsoft.com/?id=314546 Moving DB's between Servers
http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases
to a New Location with Detach/Attach
http://support.microsoft.com/?id=221465 Using WITH MOVE in a
Restore
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a
Restore
http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 How to Resolve Permission
Issues When a Database Is Moved Between SQL Servers
http://www.sqlservercentral.com/scr...sp?scriptid=599
Restoring a .mdf
http://www.support.microsoft.com/?id=307775 Disaster Recovery Articles
for SQL Server
Andrew J. Kelly
SQL Server MVP
"MB" <magnus.blomberg@.skanska.se> wrote in message
news:%23Qq4wnw9DHA.2404@.TK2MSFTNGP12.phx.gbl...
> Hello!
> I will reinstall my server who has SQL server 2000, containing a few
> databases with logins.
> Which is the easiest way to store these on disk and when I have
reinstalled
> my server, add these to SQL again, hopefully containing passwords as well.
> Regards Magnus
>|||Thank you. It helped
Regards Magnus
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:OtBdL4w9DHA.1636@.TK2MSFTNGP12.phx.gbl...
> http://www.support.microsoft.com/?id=314546 Moving DB's between
Servers
> http://www.support.microsoft.com/?id=224071 Moving SQL Server
Databases
> to a New Location with Detach/Attach
> http://support.microsoft.com/?id=221465 Using WITH MOVE in a
> Restore
> http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
> Passwords Between SQL Servers
> http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after
a
> Restore
> http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
> users
> http://www.support.microsoft.com/?id=168001 User Logon and/or
Permission
> Errors After Restoring Dump
> http://www.support.microsoft.com/?id=240872 How to Resolve Permission
> Issues When a Database Is Moved Between SQL Servers
> http://www.sqlservercentral.com/scr...sp?scriptid=599
> Restoring a .mdf
> http://www.support.microsoft.com/?id=307775 Disaster Recovery Articles
> for SQL Server
>
> --
> Andrew J. Kelly
> SQL Server MVP
>
> "MB" <magnus.blomberg@.skanska.se> wrote in message
> news:%23Qq4wnw9DHA.2404@.TK2MSFTNGP12.phx.gbl...
> reinstalled
well.
>

Move Database Store

We are replacing our drive arrays on our production SQL 2000 server. Can
anyone please tell me what I have to do to relocate the entire store? Let's
assume that I want to move everything from F:\SQLDATA to G:\SQLDATA. Can I
stop SQL server
xcopy f:\sqldata g:\sqldata /e /i
point SQL to G:\SQLDATA
start SQL server
Life is good
If so, how and where do I reset where SQL looks for the files? in step 3?
How to move SQL Server databases to a new location by using Detach and
Attach functions in SQL Server
http://support.microsoft.com/kb/224071/en-us
Note that the system databases each have special considerations.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"de Graff" <rjdegraff@.hydro.mb.ca> wrote in message
news:uLsVDeHSGHA.196@.TK2MSFTNGP10.phx.gbl...
> We are replacing our drive arrays on our production SQL 2000 server. Can
> anyone please tell me what I have to do to relocate the entire store?
> Let's assume that I want to move everything from F:\SQLDATA to G:\SQLDATA.
> Can I
> stop SQL server
> xcopy f:\sqldata g:\sqldata /e /i
> point SQL to G:\SQLDATA
> start SQL server
> Life is good
> If so, how and where do I reset where SQL looks for the files? in step 3?
>
|||Exactly what I was looking for. Thanks.
"Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
news:uikhynHSGHA.1844@.TK2MSFTNGP12.phx.gbl...
> How to move SQL Server databases to a new location by using Detach and
> Attach functions in SQL Server
> http://support.microsoft.com/kb/224071/en-us
> Note that the system databases each have special considerations.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
> "de Graff" <rjdegraff@.hydro.mb.ca> wrote in message
> news:uLsVDeHSGHA.196@.TK2MSFTNGP10.phx.gbl...
>
|||We use a vendor program called Misys. Recently we migrated to a larger
server with multiple RAID arrays. The application install puts the program
and database files on the same drive. We needed to move the log files and
databases to their own drives.
I see others proposing methods using SQL, but we found that the following
worked well without requiring any SQL programming.
1) Stopped the Misys Server service.
2) Using SQL Server Agent, backed up the database
3) Detached the database
4) Moved the MDF And LDF files to the new locations
5) Re-attached the database. Adjusted the MDF and LDF file locations to the
new ones
6) Re-started the service
7) Adjusted (as needed) any SQL Server Agent jobs that backed up and
compressed the database
Regards,
Hank Arnold
"de Graff" <rjdegraff@.hydro.mb.ca> wrote in message
news:uLsVDeHSGHA.196@.TK2MSFTNGP10.phx.gbl...
> We are replacing our drive arrays on our production SQL 2000 server. Can
> anyone please tell me what I have to do to relocate the entire store?
> Let's assume that I want to move everything from F:\SQLDATA to G:\SQLDATA.
> Can I
> stop SQL server
> xcopy f:\sqldata g:\sqldata /e /i
> point SQL to G:\SQLDATA
> start SQL server
> Life is good
> If so, how and where do I reset where SQL looks for the files? in step 3?
>