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 allow
ed restore of system
databases across versions because all the changes in the system databases. T
here are *a lot* of
changes here between 2000 and 2005, so I can bet a lot of beers that SQL Ser
ver 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:[vbcol=seagreen]
> No can do, and I didn't even try it. Traditionally, SQL Server haven't all
owed 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 S
erver 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...|||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 i
nside 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:
>|||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:[vbcol=seagreen]
> User databases can generally go across service packs on same version (up a
nd down). User database
> can also go up between versions (7.0 and 2000 can load on 2005, for instan
ce).
>
> 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...