Rebuild of server--a few questions

Our IT support has decided it is necessary to do a complete rebuild of
a server that is running SQL Server 2005. I've looked at numerous
postings on how to bring the Server back up after the rebuild, but
because of certain factors in this rebuild I'm still unclear on the
best approach. The major changes that will take place include:
1. Renaming the Server and the SQL Server instance
2. Reconfiguring the storage to create a separate partition for the
transaction logs.
In this case would I still want/need to restore the backups of the
system databases?
My current plan is to:
Prior to the rebuild:
1. Run a full back-up of all databases including the system databases.
2. Run the sp_help_revlogin procedure to generate a script to recreate
the users
3. Detach the user databases and copy the database files to another
server and/or tape.
After the rebuild:
1. Install SQL Server and apply service packs
2. Start SQL Service and execute script to recreate the users.
3. Place the database files in the desired locations (e.g. place
transaction logs on mirrored drive)
4. Attach user databases.
I imagine the primary disadvantage to not restoring the system
databases is I will have to recreate the maintenance plans, but I had
planned on making changes to these plans and there are currently only
two.
Am I missing anything?
Thanks in advance
CherylSounds good , other factors would include whether applications are using the
dbs , also, if you have time you could try a test run
--
Jack Vamvas
___________________________________
Search IT jobs from multiple sources- http://www.ITjobfeed.com
<cbender@.mriresearch.org> wrote in message
news:35ff425a-ccc0-475d-812a-1f7762367885@.d5g2000hsc.googlegroups.com...
> Our IT support has decided it is necessary to do a complete rebuild of
> a server that is running SQL Server 2005. I've looked at numerous
> postings on how to bring the Server back up after the rebuild, but
> because of certain factors in this rebuild I'm still unclear on the
> best approach. The major changes that will take place include:
> 1. Renaming the Server and the SQL Server instance
> 2. Reconfiguring the storage to create a separate partition for the
> transaction logs.
> In this case would I still want/need to restore the backups of the
> system databases?
> My current plan is to:
> Prior to the rebuild:
> 1. Run a full back-up of all databases including the system databases.
> 2. Run the sp_help_revlogin procedure to generate a script to recreate
> the users
> 3. Detach the user databases and copy the database files to another
> server and/or tape.
> After the rebuild:
> 1. Install SQL Server and apply service packs
> 2. Start SQL Service and execute script to recreate the users.
> 3. Place the database files in the desired locations (e.g. place
> transaction logs on mirrored drive)
> 4. Attach user databases.
> I imagine the primary disadvantage to not restoring the system
> databases is I will have to recreate the maintenance plans, but I had
> planned on making changes to these plans and there are currently only
> two.
> Am I missing anything?
> Thanks in advance
> Cheryl
>