February 12, 2011 at 10:43 pm
Hi
I have a scenario here.
I need to restore sql 2000 master db on sql server 2005.
can this happen? can i restore all user databases from sql 2000 to sql 2005?
Please help me out.
Thanks in advance.
February 12, 2011 at 10:52 pm
Yes you can. There are several links. One such link is below.
http://www.sqlservercentral.com/scripts/Backup+%2F+Restore/32003/
M&M
February 12, 2011 at 11:52 pm
error in posting...must of hit quote again instead of edit.
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
February 12, 2011 at 11:53 pm
I need to restore sql 2000 master db on sql server 2005.
can this happen?
No. You cannot restore system databases from one edition of SQL Server to another.
EDIT: Well you might actually do it as if it was a user database. You would not be able to restore it as the master database on the SQL Server 2005 instance.
can i restore all user databases from sql 2000 to sql 2005?
Yes. You can restore user databases from a lower version to a higher version of SQL Server. You cannot go backwards though.
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
February 13, 2011 at 1:58 am
Thanks all for replies
why can't we restore Sql 2000 Master db to sql 2005 db?
is it because sql 2000 architecture different from sql 2005.
can i know the reason why we cant restore.
thanks in advance
February 13, 2011 at 2:40 am
The simply answer is SQL Server will not allow you to. The master database holds all the system level information about the instance of SQL Server. Between major versions, hotfixes, and service packs that system information can change. So it is logical that if Microsoft did allow it to be restored your instance of SQL Server would break and become unusable.
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
February 13, 2011 at 3:05 am
as far as i understand now,
The build of server 2005 is different from sql 2000.
that is the reason for we can't copy master db.
Another Reason: sql 2005 has a new system db MSSQLSystemresource db which has system info,where as in sql 2000 master has all system info.
is this also a reason.
February 13, 2011 at 11:48 am
Another Reason: sql 2005 has a new system db MSSQLSystemresource db which has system info,where as in sql 2000 master has all system info.
is this also a reason.
😉 answered your own question
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply