Backup from SQL Server 2005

Backup from SQL Server 2005 - restore to 2000

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Pasquale - 11 Mar 2008 09:10 GMT

I need to restore a backup of a db in SQL 2005 with 80-compatibility level
into SQL Server 2000. I have tried to do it but I have an error. Is it
possible to do it?
Does exist another fast method to bring a SQL Server 2005 db into 2000?

Many thanks for your suggests.

Reply to this Message

Zarko Jovanovic - 11 Mar 2008 09:16 GMT

> I need to restore a backup of a db in SQL 2005 with 80-compatibility level
> into SQL Server 2000. I have tried to do it but I have an error. Is it
> possible to do it?
> Does exist another fast method to bring a SQL Server 2005 db into 2000?
>
> Many thanks for your suggests.

you cannot restore 2005 database to 2000 server

try using import/export wizard

gl

Reply to this Message

Pasquale - 11 Mar 2008 09:31 GMT

I known this answer, but I hope if possible with a SQL Server 2005 db in
80-compatibility level.
Using import/export wizard is less quick.

Thanks

> > I need to restore a backup of a db in SQL 2005 with 80-compatibility level
> > into SQL Server 2000. I have tried to do it but I have an error. Is it
[quoted text clipped - 7 lines]
>
> gl

Reply to this Message

Steen Schlüter Persson (DK) - 11 Mar 2008 09:58 GMT

There aren't really any other ways of doing it. No matter what
compatibility level you have set in your database, you can't restore
"backwards". You'll have to "manually" transfer the data to a SQL2000
database.

Regards
Steen Schlüter Persson

> I known this answer, but I hope if possible with a SQL Server 2005 db in
> 80-compatibility level.
[quoted text clipped - 13 lines]
>>
>> gl

Reply to this Message

Zarko Jovanovic - 11 Mar 2008 10:17 GMT

> There aren't really any other ways of doing it. No matter what
> compatibility level you have set in your database, you can't restore
[quoted text clipped - 21 lines]
>>>
>>> gl

just to acknowledge that: no, you cannot restore or attach or anything
with 2005 database on 2000 server no matter compatibility level

Reply to this Message

Pasquale - 11 Mar 2008 11:45 GMT

Ok!
I hope to do it because the db in SQL Server 2005 is the result of a db
backupped into SQL Server 2000 and restored into 2005 with 80 compatibility
level.
Many thanks.

> > There aren't really any other ways of doing it. No matter what
> > compatibility level you have set in your database, you can't restore
[quoted text clipped - 24 lines]
> just to acknowledge that: no, you cannot restore or attach or anything
> with 2005 database on 2000 server no matter compatibility level

Reply to this Message

Greg D. Moore (Strider) - 11 Mar 2008 12:53 GMT

> Ok!
> I hope to do it because the db in SQL Server 2005 is the result of a db
> backupped into SQL Server 2000 and restored into 2005 with 80
> compatibility
> level.

Correct, you can restore a DB from SQL 2000 to 2005, but you can not under
any circumstances do the reverse.

The 80 compatibility only refers to features available, etc. The structure
itself is still a 2005 DB.

> Many thanks.

Signature

Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html

Reply to this Message