Restoring SQL 6.5 Db to SQL 2000

I am not too familiar with SQL Server 6.5 or the earlier
versions. We are upgrading our phone system where back-end
is a SQL Server 6.5 into SQL Server 2000.
Is there a documentation on restoring a SQL Server 6.5
database on to SQL Server 2000 ' What is the easiest way
to do this '
T.I.AHi
You have to use the Upgrade Wizard. See BOL for information. The structure
is incompatible so a direct restore is not possible.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Jack" <anonymous@.discussions.microsoft.com> wrote in message
news:20f701c4afd1$c05ef210$a501280a@.phx.gbl...
> I am not too familiar with SQL Server 6.5 or the earlier
> versions. We are upgrading our phone system where back-end
> is a SQL Server 6.5 into SQL Server 2000.
> Is there a documentation on restoring a SQL Server 6.5
> database on to SQL Server 2000 ' What is the easiest way
> to do this '
> T.I.A|||Thanks Mike.........I am not upgrading the 6.5 server I
am going to restore the databases from 6.5 server to SQL
2000 server (Database Restore).....
>--Original Message--
>Hi
>You have to use the Upgrade Wizard. See BOL for
information. The structure
>is incompatible so a direct restore is not possible.
>Regards
>--
>Mike Epprecht, Microsoft SQL Server MVP
>Zurich, Switzerland
>IM: mike@.epprecht.net
>MVP Program: http://www.microsoft.com/mvp
>Blog: http://www.msmvps.com/epprecht/
>"Jack" <anonymous@.discussions.microsoft.com> wrote in
message
>news:20f701c4afd1$c05ef210$a501280a@.phx.gbl...
>> I am not too familiar with SQL Server 6.5 or the earlier
>> versions. We are upgrading our phone system where back-
end
>> is a SQL Server 6.5 into SQL Server 2000.
>> Is there a documentation on restoring a SQL Server 6.5
>> database on to SQL Server 2000 ' What is the easiest
way
>> to do this '
>> T.I.A
>
>.
>|||Hi,
Due to the architectural changes you can not restore a SQL 6.5 database sump
into SQL 2000. Only way to upgrade all the objects is to use the Upgrade
wizard.
Thanks
Hari
SQL Server MVP
"Jack" <anonymous@.discussions.microsoft.com> wrote in message
news:013a01c4afd6$bb83dda0$a601280a@.phx.gbl...
> Thanks Mike.........I am not upgrading the 6.5 server I
> am going to restore the databases from 6.5 server to SQL
> 2000 server (Database Restore).....
>
>>--Original Message--
>>Hi
>>You have to use the Upgrade Wizard. See BOL for
> information. The structure
>>is incompatible so a direct restore is not possible.
>>Regards
>>--
>>Mike Epprecht, Microsoft SQL Server MVP
>>Zurich, Switzerland
>>IM: mike@.epprecht.net
>>MVP Program: http://www.microsoft.com/mvp
>>Blog: http://www.msmvps.com/epprecht/
>>"Jack" <anonymous@.discussions.microsoft.com> wrote in
> message
>>news:20f701c4afd1$c05ef210$a501280a@.phx.gbl...
>> I am not too familiar with SQL Server 6.5 or the earlier
>> versions. We are upgrading our phone system where back-
> end
>> is a SQL Server 6.5 into SQL Server 2000.
>> Is there a documentation on restoring a SQL Server 6.5
>> database on to SQL Server 2000 ' What is the easiest
> way
>> to do this '
>> T.I.A
>>
>>.|||Yeah..........I realized that after I posted the second
message........
Thanks.
>--Original Message--
>Hi,
>Due to the architectural changes you can not restore a
SQL 6.5 database sump
>into SQL 2000. Only way to upgrade all the objects is to
use the Upgrade
>wizard.
>
>--
>Thanks
>Hari
>SQL Server MVP
>"Jack" <anonymous@.discussions.microsoft.com> wrote in
message
>news:013a01c4afd6$bb83dda0$a601280a@.phx.gbl...
>> Thanks Mike.........I am not upgrading the 6.5
server I
>> am going to restore the databases from 6.5 server to SQL
>> 2000 server (Database Restore).....
>>
>>--Original Message--
>>Hi
>>You have to use the Upgrade Wizard. See BOL for
>> information. The structure
>>is incompatible so a direct restore is not possible.
>>Regards
>>--
>>Mike Epprecht, Microsoft SQL Server MVP
>>Zurich, Switzerland
>>IM: mike@.epprecht.net
>>MVP Program: http://www.microsoft.com/mvp
>>Blog: http://www.msmvps.com/epprecht/
>>"Jack" <anonymous@.discussions.microsoft.com> wrote in
>> message
>>news:20f701c4afd1$c05ef210$a501280a@.phx.gbl...
>> I am not too familiar with SQL Server 6.5 or the
earlier
>> versions. We are upgrading our phone system where
back-
>> end
>> is a SQL Server 6.5 into SQL Server 2000.
>> Is there a documentation on restoring a SQL Server 6.5
>> database on to SQL Server 2000 ' What is the easiest
>> way
>> to do this '
>> T.I.A
>>
>>.
>
>.
>|||As the others have said, you cannot upgrade directly from SQL 6.5 to sql 2k
using restore... If you MUST use restore the best you can do is restore the
6.5 backup to sql 7.0. Then backup the sql 7 and restore it to sql 2k...
Otherwise, use the wizard..
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Jack" <anonymous@.discussions.microsoft.com> wrote in message
news:20f701c4afd1$c05ef210$a501280a@.phx.gbl...
> I am not too familiar with SQL Server 6.5 or the earlier
> versions. We are upgrading our phone system where back-end
> is a SQL Server 6.5 into SQL Server 2000.
> Is there a documentation on restoring a SQL Server 6.5
> database on to SQL Server 2000 ' What is the easiest way
> to do this '
> T.I.A