Monday, February 20, 2012

restore master db

HI can I restore master and msdb dbs from sql 2000 to sql 2005 sp2?
ThankasYou can't do that. Either let SETUP upgrade the whole instance, or you are yourself responsible of
transferring whatever you need from the system databases.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"mecn" <mecn2002@.yahoo.com> wrote in message news:eL2ee$XFIHA.2004@.TK2MSFTNGP06.phx.gbl...
> HI can I restore master and msdb dbs from sql 2000 to sql 2005 sp2?
> Thankas
>|||got it thanks
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:DF06CD17-F322-4C5F-A920-17B25FFBD759@.microsoft.com...
> You can't do that. Either let SETUP upgrade the whole instance, or you are
> yourself responsible of transferring whatever you need from the system
> databases.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "mecn" <mecn2002@.yahoo.com> wrote in message
> news:eL2ee$XFIHA.2004@.TK2MSFTNGP06.phx.gbl...
>> HI can I restore master and msdb dbs from sql 2000 to sql 2005 sp2?
>> Thankas
>

No comments:

Post a Comment