Reinstalling DB Server - Backup/Restore Help

Hi,
Seems my old thread doesnt have any response anymore.
reposting it again with only relavent info..
For some reasons I need to reinstall my Production SQL
Server 2000 Database Server from OS level and infact
recreating arrays etc.
My point of Intrest is How to plan the backup of databases
from existing server to restore them after reinstallation.
1. Can I just create the .BAK files of user/system
databases copy it to other server and restore it on
freshly installed server.
or
2. I detach the user/system databases.. copy the .mdf
& .ldf files to other server and restore it on freshly
installed server using attach db sp.
In both cases what is the difference and what are the
advantages and disadvantages? and which one is followed in
practice?
Also, the server on which I am going to backup database
has SP3a for SQL Server.
Do I first need to up to date the SP's(2,3a) for SQL
server on fresh Installation then restore the Databases or
Vice-versa? (keeping in mind I want to restore the
master,msdb backups). Also does restoring masterdb backup
on fresh Installation makes any sense?
Thanks In advance for all the patience and replies.
Sincere Regards
ChipCheck these out:
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/scripts/scriptdetails.asp?scriptid=599
Restoring a .mdf
http://www.support.microsoft.com/?id=307775 Disaster Recovery Articles
for SQL Server
http://www.support.microsoft.com/?id=274463 Copy DB
Wizard issues
Andrew J. Kelly
SQL Server MVP
"Chip" <anonymous@.discussions.microsoft.com> wrote in message
news:d32b01c3ef36$ab9d21a0$a001280a@.phx.gbl...
> Hi,
> Seems my old thread doesnt have any response anymore.
> reposting it again with only relavent info..
> For some reasons I need to reinstall my Production SQL
> Server 2000 Database Server from OS level and infact
> recreating arrays etc.
> My point of Intrest is How to plan the backup of databases
> from existing server to restore them after reinstallation.
> 1. Can I just create the .BAK files of user/system
> databases copy it to other server and restore it on
> freshly installed server.
> or
> 2. I detach the user/system databases.. copy the .mdf
> & .ldf files to other server and restore it on freshly
> installed server using attach db sp.
> In both cases what is the difference and what are the
> advantages and disadvantages? and which one is followed in
> practice?
> Also, the server on which I am going to backup database
> has SP3a for SQL Server.
> Do I first need to up to date the SP's(2,3a) for SQL
> server on fresh Installation then restore the Databases or
> Vice-versa? (keeping in mind I want to restore the
> master,msdb backups). Also does restoring masterdb backup
> on fresh Installation makes any sense?
> Thanks In advance for all the patience and replies.
> Sincere Regards
> Chip
>