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 |
|
stephe40
Posting Yak Master
218 Posts |
 Posted - 2005-08-24 : 12:30:35
|
| I am migrating our database server to a new machine. I am using the detach/attach method. Is it nessary to detach the master/msdb/model/tempdb databases and reattach them on the new server? Or can I just leave them? I imagine I would have to manually recreate all the maintenence plans/backup jobs/DTS packages if I dont move them.- Eric |
|
|
Westley
Posting Yak Master
229 Posts |
Posted - 2005-08-24 : 19:39:58
|
| Hi, don't really think u need to do that, as you are detach and attach db in, master db doesn't really needed (unless u got some special setting in ur master db), as for msdb, you might want to, since it have all ur jobs info, as for model, unless u change it, it just a standard model db which will be the same in your new server, tempdb u can pretty much ignore since it just recreate it everytime. I forgot about DTS packages, since I keep all my DTS in files, or you can save all you dts to files and open them back in ur new server..:) |
 |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2005-08-25 : 12:15:11
|
| Moving master is a dangerous thing. I'm not even sure how you would be able to attach it in the new server, because once you detach that server's master, I imagine things stop working. Perhaps it's technically possible to stop the service and overwrite the files at the OS level, but I've never done that. And if you have installed a different version, including service packs, on the new server, you're asking for trouble.Scripting is your friend...---------------------------EmeraldCityDomains.com |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
stephe40
Posting Yak Master
218 Posts |
Posted - 2005-08-26 : 12:33:19
|
| Tara, yeah I have read though that extensivly. I was just curious if it was really nessassry.- Eric |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-08-26 : 12:42:16
|
| It's necessary if you don't want to recreate everything that is stored in master and msdb. If your paths to the MDF and LDF files on the new server are identical to the old server, then moving the system databases is trivial. I've done this several times in the past.Tara |
|
|
|
|
|
|
|
|
Migrating the master database