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

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

"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 ?
> >
> >
> >
>
>

"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 ?
> >> >
> >> >
> >> >
> >>
> >>
> >
> >
>
>

"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 ?
>> >
>> >
>> >
>>
>>
>
>

> 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.
>

"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
>
>