Restore master backup of 2000 to 2005

Just wondering has anyone ever tried to restoring master db to SQL 2005
from backup of SQL 2000? This might sound stupid but just wondering.
Thank you,
hjNo can do, and I didn't even try it. Traditionally, SQL Server haven't allowed restore of system
databases across versions because all the changes in the system databases. There are *a lot* of
changes here between 2000 and 2005, so I can bet a lot of beers that SQL Server will give you an
error upfront.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Hitesh" <hitesh287@.gmail.com> wrote in message
news:1158387227.467591.298140@.h48g2000cwc.googlegroups.com...
> Just wondering has anyone ever tried to restoring master db to SQL 2005
> from backup of SQL 2000? This might sound stupid but just wondering.
> Thank you,
> hj
>|||Is this only for master (system databases) or one should not try to
restore any user databases either?
Ok so other option to upgrade is to do the dettach and attach system
databases?
Thank you,
hj
Tibor Karaszi wrote:
> No can do, and I didn't even try it. Traditionally, SQL Server haven't allowed restore of system
> databases across versions because all the changes in the system databases. There are *a lot* of
> changes here between 2000 and 2005, so I can bet a lot of beers that SQL Server will give you an
> error upfront.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Hitesh" <hitesh287@.gmail.com> wrote in message
> news:1158387227.467591.298140@.h48g2000cwc.googlegroups.com...
> >
> > Just wondering has anyone ever tried to restoring master db to SQL 2005
> > from backup of SQL 2000? This might sound stupid but just wondering.
> >
> > Thank you,
> > hj
> >|||User databases can generally go across service packs on same version (up and down). User database
can also go up between versions (7.0 and 2000 can load on 2005, for instance).
> Ok so other option to upgrade is to do the dettach and attach system
> databases?
No, same thing at backup/restore.
Either let the setup program upgrade the whole instance, or move the stuff inside your system
database manually.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Hitesh" <hitesh287@.gmail.com> wrote in message
news:1158605458.877330.93330@.i3g2000cwc.googlegroups.com...
> Is this only for master (system databases) or one should not try to
> restore any user databases either?
> Ok so other option to upgrade is to do the dettach and attach system
> databases?
> Thank you,
> hj
>
> Tibor Karaszi wrote:
>> No can do, and I didn't even try it. Traditionally, SQL Server haven't allowed restore of system
>> databases across versions because all the changes in the system databases. There are *a lot* of
>> changes here between 2000 and 2005, so I can bet a lot of beers that SQL Server will give you an
>> error upfront.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> "Hitesh" <hitesh287@.gmail.com> wrote in message
>> news:1158387227.467591.298140@.h48g2000cwc.googlegroups.com...
>> >
>> > Just wondering has anyone ever tried to restoring master db to SQL 2005
>> > from backup of SQL 2000? This might sound stupid but just wondering.
>> >
>> > Thank you,
>> > hj
>> >
>|||Cool. Thank you Tibor. I was planning to upgrade SQL2k. So I installed
SQL2k first on new hardware, moved all the databases from old hardware
and let the SQL2k5 set up do the upgrade and it worked like a charm.
hj
Tibor Karaszi wrote:
> User databases can generally go across service packs on same version (up and down). User database
> can also go up between versions (7.0 and 2000 can load on 2005, for instance).
>
> > Ok so other option to upgrade is to do the dettach and attach system
> > databases?
> No, same thing at backup/restore.
> Either let the setup program upgrade the whole instance, or move the stuff inside your system
> database manually.
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Hitesh" <hitesh287@.gmail.com> wrote in message
> news:1158605458.877330.93330@.i3g2000cwc.googlegroups.com...
> >
> > Is this only for master (system databases) or one should not try to
> > restore any user databases either?
> >
> > Ok so other option to upgrade is to do the dettach and attach system
> > databases?
> >
> > Thank you,
> > hj
> >
> >
> >
> > Tibor Karaszi wrote:
> >> No can do, and I didn't even try it. Traditionally, SQL Server haven't allowed restore of system
> >> databases across versions because all the changes in the system databases. There are *a lot* of
> >> changes here between 2000 and 2005, so I can bet a lot of beers that SQL Server will give you an
> >> error upfront.
> >>
> >> --
> >> Tibor Karaszi, SQL Server MVP
> >> http://www.karaszi.com/sqlserver/default.asp
> >> http://www.solidqualitylearning.com/
> >>
> >>
> >> "Hitesh" <hitesh287@.gmail.com> wrote in message
> >> news:1158387227.467591.298140@.h48g2000cwc.googlegroups.com...
> >> >
> >> > Just wondering has anyone ever tried to restoring master db to SQL 2005
> >> > from backup of SQL 2000? This might sound stupid but just wondering.
> >> >
> >> > Thank you,
> >> > hj
> >> >
> >