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 |
|
SteveH
Starting Member
27 Posts |
 Posted - 2009-04-13 : 11:30:38
|
| I have a SQL 2005 database on a machine running Windows Server 2000. The network admin wants to wipe the machine and install Windows Server 2003 or 2008. I know this will mean copying data to a temp location and them copying it back to the machine, and I assume reinstalling SQL 2005 again. What details do I need to know about this process to make is successful (folders to copy, wizards that will help, etc)?Thanks.Steve |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2009-04-14 : 03:27:43
|
| Backup all the user databases and copy the backups elsewhere. Backup all the system databases and copy the backups elsewhere. That should be all you need.--Gail ShawSQL Server MVP |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-04-14 : 10:25:15
|
| Also store settings for DTS,SSIS,Jobs and Linked servers somewhere else. |
|
|
|
SteveH
Starting Member
27 Posts |
Posted - 2009-04-16 : 10:25:37
|
| Will security information be saved with system databases or are there other files to cover this? Also, what do I copy to save DTS, SSIS, etc.?Steve |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2009-04-16 : 10:34:03
|
| Login info is stored in master. Back that up and the logins go along. DTS packages are stored in MSDB. So are any SSIS packages that you've elected to save into the database rather than into the file system. Backing up MSDB should take care of those.--Gail ShawSQL Server MVP |
|
|
|
|
|
|
Changing OS on machine with SQL Server 2005