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.
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
"Zarko Jovanovic" wrote:
> Pasquale wrote:
> you cannot restore 2005 database to 2000 server
> try using import/export wizard
> gl
>
|||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.
"Zarko Jovanovic" wrote:
> Steen Schlüter Persson (DK) wrote:
> just to acknowledge that: no, you cannot restore or attach or anything
> with 2005 database on 2000 server no matter compatibility level
>
|||"Pasquale" <Pasquale@.discussions.microsoft.com> wrote in message
news:46033DC3-842B-488F-8844-5BAB0411064C@.microsoft.com...
> 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.
>
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html
Showing posts with label 80-compatibility. Show all posts
Showing posts with label 80-compatibility. Show all posts
Friday, February 10, 2012
Backup from SQL Server 2005 - restore to 2000
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.Pasquale wrote:
> 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|||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
"Zarko Jovanovic" wrote:
> Pasquale wrote:
> > 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
>|||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
Pasquale wrote:
> 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
>
> "Zarko Jovanovic" wrote:
>> Pasquale wrote:
>> 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|||Steen Schlüter Persson (DK) wrote:
> 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
>
> Pasquale wrote:
>> 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
>>
>> "Zarko Jovanovic" wrote:
>> Pasquale wrote:
>> 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
just to acknowledge that: no, you cannot restore or attach or anything
with 2005 database on 2000 server no matter compatibility level|||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.
"Zarko Jovanovic" wrote:
> Steen Schlüter Persson (DK) wrote:
> >
> > 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
> >
> >
> > Pasquale wrote:
> >> 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
> >>
> >>
> >> "Zarko Jovanovic" wrote:
> >>
> >> Pasquale wrote:
> >> 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
> >>
> just to acknowledge that: no, you cannot restore or attach or anything
> with 2005 database on 2000 server no matter compatibility level
>|||"Pasquale" <Pasquale@.discussions.microsoft.com> wrote in message
news:46033DC3-842B-488F-8844-5BAB0411064C@.microsoft.com...
> 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.
>
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html
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.Pasquale wrote:
> 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|||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
"Zarko Jovanovic" wrote:
> Pasquale wrote:
> > 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
>|||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
Pasquale wrote:
> 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
>
> "Zarko Jovanovic" wrote:
>> Pasquale wrote:
>> 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|||Steen Schlüter Persson (DK) wrote:
> 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
>
> Pasquale wrote:
>> 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
>>
>> "Zarko Jovanovic" wrote:
>> Pasquale wrote:
>> 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
just to acknowledge that: no, you cannot restore or attach or anything
with 2005 database on 2000 server no matter compatibility level|||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.
"Zarko Jovanovic" wrote:
> Steen Schlüter Persson (DK) wrote:
> >
> > 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
> >
> >
> > Pasquale wrote:
> >> 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
> >>
> >>
> >> "Zarko Jovanovic" wrote:
> >>
> >> Pasquale wrote:
> >> 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
> >>
> just to acknowledge that: no, you cannot restore or attach or anything
> with 2005 database on 2000 server no matter compatibility level
>|||"Pasquale" <Pasquale@.discussions.microsoft.com> wrote in message
news:46033DC3-842B-488F-8844-5BAB0411064C@.microsoft.com...
> 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.
>
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html
Subscribe to:
Posts (Atom)