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 |
|
carloarango
Starting Member
15 Posts |
 Posted - 2011-09-15 : 12:22:07
|
| We are going to move our production SQLs from SQL 2005 Standard edition to SQL 2008 Standard Edition; we are moving to a completly new box, so the plan is to do a restore from backups; what is the best way to approach the move of the following:- MSDB- Login Information from Master- Replcation - we are currently replicating a database in the same box for reporting purposesAny suggestion would be greatly appreciated.Thanks |
|
|
Kristen
Test
22859 Posts |
Posted - 2011-09-15 : 12:45:56
|
| No help with those three, but this may be useful in general:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=138230 |
 |
|
|
Sachin.Nand
2937 Posts |
Posted - 2011-09-15 : 13:15:13
|
| There is no documented best approach as such.A simple back restore would do.Do you need all the backup info ?If yes then you probably have to backup and restore the MSDB .For replication you would have to script them from old box and execute them on a new one.PBUH |
|
|
|
Peter99
Constraint Violating Yak Guru
498 Posts |
Posted - 2011-09-15 : 13:33:40
|
| 1. Use backup/restore or detach/attach to transfer users databases.2. backup and restore msdb on new server.3. script replication on current server and execute script on destination.4. to move logins follow http://support.microsoft.com/kb/918992 |
|
|
|
|
|
|
Moving from SQL 2005 to SQL 2008