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
Cheryl
Sounds 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
>

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
>

real DTS/ETLM book?

after the first iteration (at least working) of my dts/etlm application
for a datawarehouse,
i decided to do the next step to more professional implementation.
is there a book, that covers etlm with a tendency to implementation with
dts?
currently i decided implement my next iteration with
ms bi accelerator, at least grab all stagging, logging, error handling
algorithms
from it.
any directions, links & tips are appreciated
My personal favorite is:
Professional SQL Server 2000 DTS
by Mark Chaffin et. al.
http://search.barnesandnoble.com/boo...sbn=0764543687
Dave Wickert [MSFT]
dwickert@.online.microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
This posting is provided "AS IS" with no warranties, and confers no rights.
"Alexander Nenashev" <nenashev@.hotbox.ru> wrote in message
news:%23s4Wpe9bEHA.3792@.TK2MSFTNGP09.phx.gbl...
> after the first iteration (at least working) of my dts/etlm application
> for a datawarehouse,
> i decided to do the next step to more professional implementation.
> is there a book, that covers etlm with a tendency to implementation with
> dts?
> currently i decided implement my next iteration with
> ms bi accelerator, at least grab all stagging, logging, error handling
> algorithms
> from it.
> any directions, links & tips are appreciated
>

real DTS/ETLM book?

after the first iteration (at least working) of my dts/etlm application
for a datawarehouse,
i decided to do the next step to more professional implementation.
is there a book, that covers etlm with a tendency to implementation with
dts?
currently i decided implement my next iteration with
ms bi accelerator, at least grab all stagging, logging, error handling
algorithms
from it.
any directions, links & tips are appreciatedMy personal favorite is:
Professional SQL Server 2000 DTS
by Mark Chaffin et. al.
http://search.barnesandnoble.com/bo...isbn=0764543687
Dave Wickert [MSFT]
dwickert@.online.microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Alexander Nenashev" <nenashev@.hotbox.ru> wrote in message
news:%23s4Wpe9bEHA.3792@.TK2MSFTNGP09.phx.gbl...
> after the first iteration (at least working) of my dts/etlm application
> for a datawarehouse,
> i decided to do the next step to more professional implementation.
> is there a book, that covers etlm with a tendency to implementation with
> dts?
> currently i decided implement my next iteration with
> ms bi accelerator, at least grab all stagging, logging, error handling
> algorithms
> from it.
> any directions, links & tips are appreciated
>