Can you restore a SQL6.5 backup to a Sql2000sp3 ?

Hi

They are two different architectures and therefore you can't. You will have
to load the backup onto a 6.5 installation. Upgrading from 6.5 to 2000 is
not always a simple issue and you should look at the section on
compatibility in Books online.

John
"AHartman" <Hoosbruin@Kconline.com> wrote in message
news:85ydnXPpWsRRGgPcRVn-vw@kconline.com...
>
>
> Can you restore a SQL6.5 backup to a Sql2000sp3 ?
>
>
>

Ocupa BCP .. transfiere todas las tablas a archivos nativos de SQL .. crea
la base y las tablas en
el SQL 2000 y despues usa el BCP e inserta los datos a la nuevo SQL





"AHartman" <Hoosbruin@Kconline.com> escribió en el mensaje
news:85ydnXPpWsRRGgPcRVn-vw@kconline.com...
>
>
> Can you restore a SQL6.5 backup to a Sql2000sp3 ?
>
>
>

With SQL 6.5, don't you have to upgrade to 7.0 first, and then to 2000?


"John Bell" <jbellnewsposts@hotmail.com> wrote in message
news:419f2c26$0$17351$afc38c87@news.easynet.co.uk. ..
> Hi
>
> They are two different architectures and therefore you can't. You will
have
> to load the backup onto a 6.5 installation. Upgrading from 6.5 to 2000 is
> not always a simple issue and you should look at the section on
> compatibility in Books online.
>
> John
> "AHartman" <Hoosbruin@Kconline.com> wrote in message
> news:85ydnXPpWsRRGgPcRVn-vw@kconline.com...
> >
> >
> > Can you restore a SQL6.5 backup to a Sql2000sp3 ?
> >
> >
> >
>
>

Hi

You can upgrade directly to SQL 2000 through the wizard (BOL topic:
Upgrading Databases from SQL Server 6.5 (Upgrade Wizard)) , but depending on
how complex you application is you may have to do extra work on the
compatibility issues (See BOL: Backward compatibility). If you have multiple
installations or require a repeatable upgrade then you may want to look at
doing a staged conversion process using BCP or possibly DTS.

John

"JD" <joeydba@yahoo.com> wrote in message news:41c0aa43$1@news.qgraph.com...
> With SQL 6.5, don't you have to upgrade to 7.0 first, and then to 2000?
>
>
> "John Bell" <jbellnewsposts@hotmail.com> wrote in message
> news:419f2c26$0$17351$afc38c87@news.easynet.co.uk. ..
>> Hi
>>
>> They are two different architectures and therefore you can't. You will
> have
>> to load the backup onto a 6.5 installation. Upgrading from 6.5 to 2000 is
>> not always a simple issue and you should look at the section on
>> compatibility in Books online.
>>
>> John
>> "AHartman" <Hoosbruin@Kconline.com> wrote in message
>> news:85ydnXPpWsRRGgPcRVn-vw@kconline.com...
>> >
>> >
>> > Can you restore a SQL6.5 backup to a Sql2000sp3 ?
>> >
>> >
>> >
>>
>>
>
>

Thanks John. I thought I had read where it needed to be done through SQL 7.
I was being a bit lazy posting here but, I'm a bit busy and figured this
would provide me with a quick answer.

Say, John I have a off topic question for you. By any chance did you grow up
in central NY?
I had a childhood friend by the same name and figured I ask.

JD

"John Bell" <jbellnewsposts@hotmail.com> wrote in message
news:41c0b336$0$24897$afc38c87@news.easynet.co.uk. ..
> Hi
>
> You can upgrade directly to SQL 2000 through the wizard (BOL topic:
> Upgrading Databases from SQL Server 6.5 (Upgrade Wizard)) , but depending
on
> how complex you application is you may have to do extra work on the
> compatibility issues (See BOL: Backward compatibility). If you have
multiple
> installations or require a repeatable upgrade then you may want to look at
> doing a staged conversion process using BCP or possibly DTS.
>
> John
>
> "JD" <joeydba@yahoo.com> wrote in message
news:41c0aa43$1@news.qgraph.com...
> > With SQL 6.5, don't you have to upgrade to 7.0 first, and then to 2000?
> >
> >
> > "John Bell" <jbellnewsposts@hotmail.com> wrote in message
> > news:419f2c26$0$17351$afc38c87@news.easynet.co.uk. ..
> >> Hi
> >>
> >> They are two different architectures and therefore you can't. You will
> > have
> >> to load the backup onto a 6.5 installation. Upgrading from 6.5 to 2000
is
> >> not always a simple issue and you should look at the section on
> >> compatibility in Books online.
> >>
> >> John
> >> "AHartman" <Hoosbruin@Kconline.com> wrote in message
> >> news:85ydnXPpWsRRGgPcRVn-vw@kconline.com...
> >> >
> >> >
> >> > Can you restore a SQL6.5 backup to a Sql2000sp3 ?
> >> >
> >> >
> >> >
> >>
> >>
> >
> >
>
>

Hi JD

> Say, John I have a off topic question for you. By any chance did you grow
> up
> in central NY?
> I had a childhood friend by the same name and figured I ask.
>
Nope, never been to NY!

He's must be the good looking one!

John

Thanks - it was worth a shot in the dark.


"John Bell" <jbellnewsposts@hotmail.com> wrote in message
news:41c0cc7b$0$2816$afc38c87@news.easynet.co.uk.. .
> Hi JD
>
> > Say, John I have a off topic question for you. By any chance did you
grow
> > up
> > in central NY?
> > I had a childhood friend by the same name and figured I ask.
> >
> Nope, never been to NY!
>
> He's must be the good looking one!
>
> John
>
>