Hello all,
Does anybody have any experience in trying to backup a DB from MSSQL
2005 and then restoring it on a machine with MSSQL 2000? Can it be
done? Is it completely impossible?
While at it - Is it possible to do the reverse without problems? Is
MSSQL 2005 100% back-compatible with MSSQL 2000, so I can just backup a
whole DB on MSSQL 2000, restore it on MSSQL 2005 and have it run as
smoothly?
Thanks in advance.You can go from 2000 to 2005 and the db will be upgraded to the 2005 format.
But once it is in the 2005 format you can not go backwards. The upgrade is
seamless in and of itself but there may be incompatibilities with your
existing code / app that you might have to deal with. You can use the
upgrade advisor to see first.
http://www.microsoft.com/downloads/details.aspx?familyid=63FCE120-5E87-4AF1-B080-CA461AEAFAA2&displaylang=en
--
Andrew J. Kelly SQL MVP
<Baudolino@.gmail.com> wrote in message
news:1128954487.426069.160440@.f14g2000cwb.googlegroups.com...
> Hello all,
> Does anybody have any experience in trying to backup a DB from MSSQL
> 2005 and then restoring it on a machine with MSSQL 2000? Can it be
> done? Is it completely impossible?
> While at it - Is it possible to do the reverse without problems? Is
> MSSQL 2005 100% back-compatible with MSSQL 2000, so I can just backup a
> whole DB on MSSQL 2000, restore it on MSSQL 2005 and have it run as
> smoothly?
> Thanks in advance.
>
Showing posts with label restoring. Show all posts
Showing posts with label restoring. Show all posts
Thursday, March 22, 2012
Downgrading MSSQL 2005 DB to MSSQL 2000 DB
Hello all,
Does anybody have any experience in trying to backup a DB from MSSQL
2005 and then restoring it on a machine with MSSQL 2000? Can it be
done? Is it completely impossible?
While at it - Is it possible to do the reverse without problems? Is
MSSQL 2005 100% back-compatible with MSSQL 2000, so I can just backup a
whole DB on MSSQL 2000, restore it on MSSQL 2005 and have it run as
smoothly?
Thanks in advance.
You can go from 2000 to 2005 and the db will be upgraded to the 2005 format.
But once it is in the 2005 format you can not go backwards. The upgrade is
seamless in and of itself but there may be incompatibilities with your
existing code / app that you might have to deal with. You can use the
upgrade advisor to see first.
http://www.microsoft.com/downloads/d...displaylang=en
Andrew J. Kelly SQL MVP
<Baudolino@.gmail.com> wrote in message
news:1128954487.426069.160440@.f14g2000cwb.googlegr oups.com...
> Hello all,
> Does anybody have any experience in trying to backup a DB from MSSQL
> 2005 and then restoring it on a machine with MSSQL 2000? Can it be
> done? Is it completely impossible?
> While at it - Is it possible to do the reverse without problems? Is
> MSSQL 2005 100% back-compatible with MSSQL 2000, so I can just backup a
> whole DB on MSSQL 2000, restore it on MSSQL 2005 and have it run as
> smoothly?
> Thanks in advance.
>
Does anybody have any experience in trying to backup a DB from MSSQL
2005 and then restoring it on a machine with MSSQL 2000? Can it be
done? Is it completely impossible?
While at it - Is it possible to do the reverse without problems? Is
MSSQL 2005 100% back-compatible with MSSQL 2000, so I can just backup a
whole DB on MSSQL 2000, restore it on MSSQL 2005 and have it run as
smoothly?
Thanks in advance.
You can go from 2000 to 2005 and the db will be upgraded to the 2005 format.
But once it is in the 2005 format you can not go backwards. The upgrade is
seamless in and of itself but there may be incompatibilities with your
existing code / app that you might have to deal with. You can use the
upgrade advisor to see first.
http://www.microsoft.com/downloads/d...displaylang=en
Andrew J. Kelly SQL MVP
<Baudolino@.gmail.com> wrote in message
news:1128954487.426069.160440@.f14g2000cwb.googlegr oups.com...
> Hello all,
> Does anybody have any experience in trying to backup a DB from MSSQL
> 2005 and then restoring it on a machine with MSSQL 2000? Can it be
> done? Is it completely impossible?
> While at it - Is it possible to do the reverse without problems? Is
> MSSQL 2005 100% back-compatible with MSSQL 2000, so I can just backup a
> whole DB on MSSQL 2000, restore it on MSSQL 2005 and have it run as
> smoothly?
> Thanks in advance.
>
Downgrading MSSQL 2005 DB to MSSQL 2000 DB
Hello all,
Does anybody have any experience in trying to backup a DB from MSSQL
2005 and then restoring it on a machine with MSSQL 2000? Can it be
done? Is it completely impossible?
While at it - Is it possible to do the reverse without problems? Is
MSSQL 2005 100% back-compatible with MSSQL 2000, so I can just backup a
whole DB on MSSQL 2000, restore it on MSSQL 2005 and have it run as
smoothly?
Thanks in advance.You can go from 2000 to 2005 and the db will be upgraded to the 2005 format.
But once it is in the 2005 format you can not go backwards. The upgrade is
seamless in and of itself but there may be incompatibilities with your
existing code / app that you might have to deal with. You can use the
upgrade advisor to see first.
http://www.microsoft.com/downloads/...&displaylang=en
--
Andrew J. Kelly SQL MVP
<Baudolino@.gmail.com> wrote in message
news:1128954487.426069.160440@.f14g2000cwb.googlegroups.com...
> Hello all,
> Does anybody have any experience in trying to backup a DB from MSSQL
> 2005 and then restoring it on a machine with MSSQL 2000? Can it be
> done? Is it completely impossible?
> While at it - Is it possible to do the reverse without problems? Is
> MSSQL 2005 100% back-compatible with MSSQL 2000, so I can just backup a
> whole DB on MSSQL 2000, restore it on MSSQL 2005 and have it run as
> smoothly?
> Thanks in advance.
>
Does anybody have any experience in trying to backup a DB from MSSQL
2005 and then restoring it on a machine with MSSQL 2000? Can it be
done? Is it completely impossible?
While at it - Is it possible to do the reverse without problems? Is
MSSQL 2005 100% back-compatible with MSSQL 2000, so I can just backup a
whole DB on MSSQL 2000, restore it on MSSQL 2005 and have it run as
smoothly?
Thanks in advance.You can go from 2000 to 2005 and the db will be upgraded to the 2005 format.
But once it is in the 2005 format you can not go backwards. The upgrade is
seamless in and of itself but there may be incompatibilities with your
existing code / app that you might have to deal with. You can use the
upgrade advisor to see first.
http://www.microsoft.com/downloads/...&displaylang=en
--
Andrew J. Kelly SQL MVP
<Baudolino@.gmail.com> wrote in message
news:1128954487.426069.160440@.f14g2000cwb.googlegroups.com...
> Hello all,
> Does anybody have any experience in trying to backup a DB from MSSQL
> 2005 and then restoring it on a machine with MSSQL 2000? Can it be
> done? Is it completely impossible?
> While at it - Is it possible to do the reverse without problems? Is
> MSSQL 2005 100% back-compatible with MSSQL 2000, so I can just backup a
> whole DB on MSSQL 2000, restore it on MSSQL 2005 and have it run as
> smoothly?
> Thanks in advance.
>
Downgrading from Enterprise to Standard
Hi
Does anyone know how to go from SQL Server 2000 Enterprise to Standard and restore all of the databases? I've tried restoring the Mater Database, but I am getting the following
The backup of the system database on device XXXX cannot be restored because it was created by a different version of the server (134217546) than this server (134217488)
KB article 264474 shows how to get a server back to the version level, if the flavor of SQL Server is the same [i.e. Enterprise] but not if the server is being downgraded from Enterprise to Standard for licensing reasons
Thanks
ChrisChris,
This appears to be backup / restore that is the problem.
You should be able to detach the databases from the SS2KEE server and then
attach them to the SS2KSt server. Check this article (from the BOL) on
Attaching and Detaching Databases. The file formats are the same.
http://msdn.microsoft.com/library/default.asp?
url=/library/en-us/createdb/cm_8_des_03_89pv.asp
Russell Fields
"Chris Smith" <chriss@.resultmatrix.com> wrote in message
news:D8C2FF80-CA31-495C-9B6D-2F4D9172FA84@.microsoft.com...
> Hi,
> Does anyone know how to go from SQL Server 2000 Enterprise to Standard and
restore all of the databases? I've tried restoring the Mater Database, but
I am getting the following:
> The backup of the system database on device XXXX cannot be restored
because it was created by a different version of the server (134217546) than
this server (134217488).
> KB article 264474 shows how to get a server back to the version level, if
the flavor of SQL Server is the same [i.e. Enterprise] but not if the
server is being downgraded from Enterprise to Standard for licensing
reasons.
> Thanks,
> Chris|||I would double check that you really have the same service pack/hotfix level. This is what the error
implies.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Chris Smith" <chriss@.resultmatrix.com> wrote in message
news:D8C2FF80-CA31-495C-9B6D-2F4D9172FA84@.microsoft.com...
> Hi,
> Does anyone know how to go from SQL Server 2000 Enterprise to Standard and restore all of the
databases? I've tried restoring the Mater Database, but I am getting the following:
> The backup of the system database on device XXXX cannot be restored because it was created by a
different version of the server (134217546) than this server (134217488).
> KB article 264474 shows how to get a server back to the version level, if the flavor of SQL Server
is the same [i.e. Enterprise] but not if the server is being downgraded from Enterprise to Standard
for licensing reasons.
> Thanks,
> Chris
Does anyone know how to go from SQL Server 2000 Enterprise to Standard and restore all of the databases? I've tried restoring the Mater Database, but I am getting the following
The backup of the system database on device XXXX cannot be restored because it was created by a different version of the server (134217546) than this server (134217488)
KB article 264474 shows how to get a server back to the version level, if the flavor of SQL Server is the same [i.e. Enterprise] but not if the server is being downgraded from Enterprise to Standard for licensing reasons
Thanks
ChrisChris,
This appears to be backup / restore that is the problem.
You should be able to detach the databases from the SS2KEE server and then
attach them to the SS2KSt server. Check this article (from the BOL) on
Attaching and Detaching Databases. The file formats are the same.
http://msdn.microsoft.com/library/default.asp?
url=/library/en-us/createdb/cm_8_des_03_89pv.asp
Russell Fields
"Chris Smith" <chriss@.resultmatrix.com> wrote in message
news:D8C2FF80-CA31-495C-9B6D-2F4D9172FA84@.microsoft.com...
> Hi,
> Does anyone know how to go from SQL Server 2000 Enterprise to Standard and
restore all of the databases? I've tried restoring the Mater Database, but
I am getting the following:
> The backup of the system database on device XXXX cannot be restored
because it was created by a different version of the server (134217546) than
this server (134217488).
> KB article 264474 shows how to get a server back to the version level, if
the flavor of SQL Server is the same [i.e. Enterprise] but not if the
server is being downgraded from Enterprise to Standard for licensing
reasons.
> Thanks,
> Chris|||I would double check that you really have the same service pack/hotfix level. This is what the error
implies.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Chris Smith" <chriss@.resultmatrix.com> wrote in message
news:D8C2FF80-CA31-495C-9B6D-2F4D9172FA84@.microsoft.com...
> Hi,
> Does anyone know how to go from SQL Server 2000 Enterprise to Standard and restore all of the
databases? I've tried restoring the Mater Database, but I am getting the following:
> The backup of the system database on device XXXX cannot be restored because it was created by a
different version of the server (134217546) than this server (134217488).
> KB article 264474 shows how to get a server back to the version level, if the flavor of SQL Server
is the same [i.e. Enterprise] but not if the server is being downgraded from Enterprise to Standard
for licensing reasons.
> Thanks,
> Chris
Subscribe to:
Posts (Atom)