Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sqlpal2007
Posting Yak Master
200 Posts |
 Posted - 2008-01-16 : 10:36:44
|
| Hello All,We have to re-install the sql server 2000 on the server. Can anyone tell me what should be the checklist before and after the sql server is installed?How do I save the existing configuration of the server so that I apply the same while re-installing teh same.I know I have to take the backups of system and user databases and then restore them after the installation.This server has linked servers, jobs, DTS packages, logins, server roles, database users and roles. How do I take care of those?Thanks in advance,-P |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2008-01-16 : 10:57:00
|
| Why do you need to re-install? |
 |
|
|
sqlpal2007
Posting Yak Master
200 Posts |
Posted - 2008-01-16 : 11:06:19
|
| Because we had some issues with the hard disks |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2008-01-16 : 11:54:49
|
| So what do you have left of SQL? Did it just get rid of the Client Apps and the Database Engine?If you still have all the mdf and ldf files, you can just re-install and then start SQL with the copy of master/model/msdb you have currently. Make sure you do not overwritye these when re-installing. Everything should still be there if it is sone correctly. |
|
|
|
sqlpal2007
Posting Yak Master
200 Posts |
Posted - 2008-01-16 : 14:31:53
|
| Currently this server is accesible. But the network team is going to format the disks and then re-insatll all the OS + softwares + SQL server 2000. Before they do anything I would have to script the existing configuration of SQL and backup all the databases. So that once the sql server is re-installed I can restored all the databases.But I am not sure if I need Logins, linked server scripts, roles, sql jobs, dts packages. Can anyone give me suggestion on how to proceed.Thanks,-P |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-16 : 23:49:50
|
| You can restore master and msdb also. |
|
|
|
sqlpal2007
Posting Yak Master
200 Posts |
Posted - 2008-01-17 : 10:23:24
|
| Would restoring of master and msdb take care of dts packsgaes, sql jobs and maintenance plans and linked server? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-20 : 00:14:00
|
| Yes, that's where those objects stored. |
|
|
|
|
|
|
|
|
Re-installing sql server