June 8, 2009 at 8:58 am
Moving everything from Win2000/SQL2000 machine to Win2003/SQL2005. Got most of the databases moved, but I am asked to bring the master DB over, too. I don't think this is possible, nor a good idea, but wanted to run it by you guys. I have not yet had a chance to ask our network person why she wants to do this.
June 8, 2009 at 9:10 am
It appears they didn't realize what the master DB does. I think I have them convinced that it doesn't need to move.
June 8, 2009 at 9:12 am
It's possible to move master database.
Refer BOL
http://msdn.microsoft.com/en-us/library/ms345408.aspx
June 8, 2009 at 10:39 am
One quick question are you trying to move the master database or upgrade the sql server. From your statement
"Moving everything from Win2000/SQL2000 machine to Win2003/SQL2005" it seems like that you are trying to upgrade from sql2000 to 2005. Just attaching the master database from 2000 to 2005 does not work. Upgradation is the best option. Check out on how to upgrade from 2000 to 2005 on Ms site. They have word document for upgradation. I recommend you to read it before trying anything.
[font="Verdana"]Thanks
Chandra Mohan[/font]
June 8, 2009 at 10:41 am
Pradeep,
Please dont misguide the user. And the link you had posted is for sql server 2008. Please check the link before posting it. This is the correct link for moving system database in sql 2005.
http://msdn.microsoft.com/en-us/library/ms345408(SQL.90).aspx
[font="Verdana"]Thanks
Chandra Mohan[/font]
June 8, 2009 at 10:48 pm
ChandraMohan Nandula (6/8/2009)
Pradeep,Please dont misguide the user. And the link you had posted is for sql server 2008. Please check the link before posting it. This is the correct link for moving system database in sql 2005.
http://msdn.microsoft.com/en-us/library/ms345408(SQL.90).aspx
Thanks for pointing that out. I googled and posted the link without (perhaps) typing the version.
However, if you notice, the procedure for moving master is exactly the same in either cases (2005/2008). You use -d parameter for relocating datafile, -e for error log and -l for transaction log file.
June 9, 2009 at 4:39 am
Pradeep,
It seems the user is not sure about his question. I think he is trying to upgrade form the statement "moving everything from Win2000/SQL2000 machine to Win2003/SQL2005". And do you think that you can move the master db simply from 2000 and attach to 2005. Is it the correct way?
Thanks
Chandra Mohan N
[font="Verdana"]Thanks
Chandra Mohan[/font]
June 9, 2009 at 5:28 am
And do you think that you can move the master db simply from 2000 and attach to 2005.
We cannot restore master directly from one build of sql server to another. There is a workaround here though:
http://support.microsoft.com/kb/264474
June 9, 2009 at 6:44 am
you upgrade you dont perform upgradation there is no such term.
if you did not upgrade the original sql2000 instance the only option you have now is to script the objects from the master on the source server (logins,etc) and apply to the new instance
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 9, 2009 at 8:50 am
When I see the word "upgrade" I think of it as upgrading an existing computer. In this case, we are moving everything from an old server, running on Windows 2000 and which uses SQL Server 2000, to a new server, which has Windows 2003 and SQL Server 2005.
It appears that the person who wnated to move stuff was not aware that the Master DB really doesn't need to be moved. To be honest, I fail to see any benefit from such a move.
At any rate, we're not going to copy it now, so thanks everyone.
June 10, 2009 at 6:09 am
as i mentioned the only thing you may need is login info and database paths\details. If you haven't upgraded the database (which you haven't) you would need to script the objects out of the source system
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 10, 2009 at 6:38 am
To migrate logins see the link below for a nice little stored proc. I just did what you're attempting to do and this worked perfectly.
http://support.microsoft.com/kb/246133/
-- You can't be late until you show up.
June 10, 2009 at 6:42 am
Perry Whittle (6/9/2009)
you upgrade you dont perform upgradation
Isn't that what we recently went through Perry? Oh no that was a migration 😀
June 12, 2009 at 5:37 am
Hello buddy, fancy seeing you here 🙂
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 14 posts - 1 through 13 (of 13 total)
You must be logged in to reply to this topic. Login to reply