RESTORE sqlserver2005DB to sqlserver2000

Hi all,
Does the compatibility level of sqlserver2005 affects the transfering
of the 2005DB to sqlserver2000?
Our 2005 database has a compatibility level 80.And our sqlserver2000
has the same compatibility level.While transfering database(from2005 to
2000), do we need to handle this compatibility?
Thanks,
Mukut> Does the compatibility level of sqlserver2005 affects the transfering
> of the 2005DB to sqlserver2000?
No, the database is physically upgraded when you restore 2000 into 2005, and there is no physical
downgrade feature. I assume you here mean backup/restore or detach/attach.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Mukut" <hidevraj@.gmail.com> wrote in message
news:1162378083.366854.21150@.k70g2000cwa.googlegroups.com...
> Hi all,
> Does the compatibility level of sqlserver2005 affects the transfering
> of the 2005DB to sqlserver2000?
> Our 2005 database has a compatibility level 80.And our sqlserver2000
> has the same compatibility level.While transfering database(from2005 to
> 2000), do we need to handle this compatibility?
> Thanks,
> Mukut
>|||Tibor Karaszi wrote:
> > Does the compatibility level of sqlserver2005 affects the transfering
> > of the 2005DB to sqlserver2000?
> No, the database is physically upgraded when you restore 2000 into 2005, and there is no physical
> downgrade feature. I assume you here mean backup/restore or detach/attach.
Hi Tibor,
Truely, our requirement is to take a back up of sqlserver2005 DB and
restore it to sqlserver2000. We are getting error as
follows:Error3169:The backed-up database has on-disk structure
version<..>.The server support version 539 and can not restore or
upgrade this database.RESTORE FILELIST is terminating abnormally.
We could not resolve it.We are not sure whether compatibility or
something else is the problem or it is technically impossible to
restore back up of sqlserver2005 DB into sqlserver2000.
Tibor,could u pls suggest us what should we do in order to restore,if
possible, sqlserver2005DB into sqlserver2000 ? Does Microsoft suggest
anything in this regard?
Thanks,
Mukut|||You won't be able to restore a 2005 backup onto a 2000 server. The
best you'll be able to do is to either set up a DTS transfer or export
the data to a flat file. You might check out whether BCP inSQL 2005
outputs data in a format readable by SQL 2000.
On 1 Nov 2006 13:38:20 -0800, "Mukut" <hidevraj@.gmail.com> wrote:
>Tibor Karaszi wrote:
>> > Does the compatibility level of sqlserver2005 affects the transfering
>> > of the 2005DB to sqlserver2000?
>> No, the database is physically upgraded when you restore 2000 into 2005, and there is no physical
>> downgrade feature. I assume you here mean backup/restore or detach/attach.
>Hi Tibor,
>Truely, our requirement is to take a back up of sqlserver2005 DB and
>restore it to sqlserver2000. We are getting error as
>follows:Error3169:The backed-up database has on-disk structure
>version<..>.The server support version 539 and can not restore or
>upgrade this database.RESTORE FILELIST is terminating abnormally.
>We could not resolve it.We are not sure whether compatibility or
>something else is the problem or it is technically impossible to
>restore back up of sqlserver2005 DB into sqlserver2000.
>Tibor,could u pls suggest us what should we do in order to restore,if
>possible, sqlserver2005DB into sqlserver2000 ? Does Microsoft suggest
>anything in this regard?
>Thanks,
>Mukut