32-bit SQL2000 on 64bit OS

Can I install 32-bit SQL on a 64-bit Windows 2003 Enterprise Server? and if yes, how will it perform?That is not supported.
--
Andrew J. Kelly
SQL Server MVP
"Patrick" <anonymous@.discussions.microsoft.com> wrote in message
news:B71D50F1-A9BE-4A5F-8231-287572D1F8E1@.microsoft.com...
> Can I install 32-bit SQL on a 64-bit Windows 2003 Enterprise Server? and
if yes, how will it perform?|||Why would you want to?
--
Andrew C. Madsen
Information Architect
Harley-Davidson Motor Company
"Patrick" <anonymous@.discussions.microsoft.com> wrote in message
news:B71D50F1-A9BE-4A5F-8231-287572D1F8E1@.microsoft.com...
> Can I install 32-bit SQL on a 64-bit Windows 2003 Enterprise Server? and
if yes, how will it perform?

32-bit SQL2000 on 64bit OS

Can I install 32-bit SQL on a 64-bit Windows 2003 Enterprise Server? and if yes, how will it perform?
That is not supported.
Andrew J. Kelly
SQL Server MVP
"Patrick" <anonymous@.discussions.microsoft.com> wrote in message
news:B71D50F1-A9BE-4A5F-8231-287572D1F8E1@.microsoft.com...
> Can I install 32-bit SQL on a 64-bit Windows 2003 Enterprise Server? and
if yes, how will it perform?
|||Why would you want to?
Andrew C. Madsen
Information Architect
Harley-Davidson Motor Company
"Patrick" <anonymous@.discussions.microsoft.com> wrote in message
news:B71D50F1-A9BE-4A5F-8231-287572D1F8E1@.microsoft.com...
> Can I install 32-bit SQL on a 64-bit Windows 2003 Enterprise Server? and
if yes, how will it perform?

32-bit SQL2000 on 64bit OS

Can I install 32-bit SQL on a 64-bit Windows 2003 Enterprise Server? and if
yes, how will it perform?That is not supported.
Andrew J. Kelly
SQL Server MVP
"Patrick" <anonymous@.discussions.microsoft.com> wrote in message
news:B71D50F1-A9BE-4A5F-8231-287572D1F8E1@.microsoft.com...
> Can I install 32-bit SQL on a 64-bit Windows 2003 Enterprise Server? and
if yes, how will it perform?|||Why would you want to?
Andrew C. Madsen
Information Architect
Harley-Davidson Motor Company
"Patrick" <anonymous@.discussions.microsoft.com> wrote in message
news:B71D50F1-A9BE-4A5F-8231-287572D1F8E1@.microsoft.com...
> Can I install 32-bit SQL on a 64-bit Windows 2003 Enterprise Server? and
if yes, how will it perform?

3 node sql2000 on win2003 cookbook?

Can some point to a doc (cookbook) for building a 3 node sql2000 cluster on
win 2003.
thanks,
JR
You can take a look at the following link
http://support.microsoft.com/?id=260758. It deals with FAQ and also has
links on how to install SQL2000 on Win2003 Cluster. Your experience should
not vary on the number of nodes on the cluster.
Sandeep Sutari
Microsoft Corp.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of any included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"jr" <jr@.jr.com> wrote in message
news:%23iyGdVQOEHA.904@.TK2MSFTNGP12.phx.gbl...
> Can some point to a doc (cookbook) for building a 3 node sql2000 cluster
on
> win 2003.
> thanks,
> JR
>
|||Sandeep, can you point to similar information on the Active / active clustering, not failover? i seems to find a lot about fail over but having hard time locating faq or a how to on configuring it as multiple active nodes to share the processing load.
Thank you
-- Sandeep Sutari [MSFT] wrote: --
You can take a look at the following link
http://support.microsoft.com/?id=260758. It deals with FAQ and also has
links on how to install SQL2000 on Win2003 Cluster. Your experience should
not vary on the number of nodes on the cluster.
Sandeep Sutari
Microsoft Corp.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of any included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"jr" <jr@.jr.com> wrote in message
news:%23iyGdVQOEHA.904@.TK2MSFTNGP12.phx.gbl...
> Can some point to a doc (cookbook) for building a 3 node sql2000 cluster
on[vbcol=seagreen]
> win 2003.
> JR
|||I don't think active/active means what you think it does here. :-) That's a
term that was used in SQL Server 7.0 to indicate that both nodes in your
Failover Cluster were running a installation of SQL Server that was being
accessed by users. Those instances do not share databases between them, they
were completely stand-alone. SQL Server 2000 does not allow multiple nodes
to access the same database at the same time either.
Sincerely,
Stephen Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
"Michael" <anonymous@.discussions.microsoft.com> wrote in message
news:538CE54C-0C3B-48B9-AD24-3E23CF18B54D@.microsoft.com...
> Sandeep, can you point to similar information on the Active / active
clustering, not failover? i seems to find a lot about fail over but having
hard time locating faq or a how to on configuring it as multiple active
nodes to share the processing load.
> Thank you
> -- Sandeep Sutari [MSFT] wrote: --
> You can take a look at the following link
> http://support.microsoft.com/?id=260758. It deals with FAQ and also
has
> links on how to install SQL2000 on Win2003 Cluster. Your experience
should
> not vary on the number of nodes on the cluster.
>
> --
> Sandeep Sutari
> Microsoft Corp.
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> Use of any included script samples are subject to the terms specified
at[vbcol=seagreen]
> http://www.microsoft.com/info/cpyright.htm
> "jr" <jr@.jr.com> wrote in message
> news:%23iyGdVQOEHA.904@.TK2MSFTNGP12.phx.gbl...
cluster[vbcol=seagreen]
> on
sql

2005 DB backwards-compatible to 2000?

I've attached an SQL2000 db to an SQL2005 Std installation and am curious if
that process can go the other way. Can you detach from 2005 and attach to
2000 without any issues?
Earl wrote:
> Can you detach from 2005 and attach to
> 2000 without any issues?
No. One cannot attach a higher version database to a lower version SQL
Server. The 2005 file format is incompatible with SQL Server 2000.
If you have to migrate backwards, use SSIS to copy the objects and data from
SQL Server 2005 to SQL Server 2000.
Message posted via droptable.com
http://www.droptable.com/Uwe/Forums.aspx/sql-server/200612/1
|||No, You can not do that because of architectural changes.
Thanks
Hari
"Earl" <brikshoe@.newsgroups.nospam> wrote in message
news:%23ye9a5kHHHA.3540@.TK2MSFTNGP02.phx.gbl...
> I've attached an SQL2000 db to an SQL2005 Std installation and am curious
> if that process can go the other way. Can you detach from 2005 and attach
> to 200use of 0 without any issues?
>
|||Ahhh, thanks Chris and Hari. Tis' the answer I need.
"Chris O'C via droptable.com" <u29189@.uwe> wrote in message
news:6aacc6ece6f0b@.uwe...
> Earl wrote:
> No. One cannot attach a higher version database to a lower version SQL
> Server. The 2005 file format is incompatible with SQL Server 2000.
> If you have to migrate backwards, use SSIS to copy the objects and data
> from
> SQL Server 2005 to SQL Server 2000.
> --
> Message posted via droptable.com
> http://www.droptable.com/Uwe/Forums.aspx/sql-server/200612/1
>

2005 DB backwards-compatible to 2000?

I've attached an SQL2000 db to an SQL2005 Std installation and am curious if
that process can go the other way. Can you detach from 2005 and attach to
2000 without any issues?Earl wrote:
> Can you detach from 2005 and attach to
> 2000 without any issues?
No. One cannot attach a higher version database to a lower version SQL
Server. The 2005 file format is incompatible with SQL Server 2000.
If you have to migrate backwards, use SSIS to copy the objects and data from
SQL Server 2005 to SQL Server 2000.
Message posted via droptable.com
http://www.droptable.com/Uwe/Forum...server/200612/1|||No, You can not do that because of architectural changes.
Thanks
Hari
"Earl" <brikshoe@.newsgroups.nospam> wrote in message
news:%23ye9a5kHHHA.3540@.TK2MSFTNGP02.phx.gbl...
> I've attached an SQL2000 db to an SQL2005 Std installation and am curious
> if that process can go the other way. Can you detach from 2005 and attach
> to 200use of 0 without any issues?
>|||Ahhh, thanks Chris and Hari. Tis' the answer I need.
"Chris O'C via droptable.com" <u29189@.uwe> wrote in message
news:6aacc6ece6f0b@.uwe...
> Earl wrote:
> No. One cannot attach a higher version database to a lower version SQL
> Server. The 2005 file format is incompatible with SQL Server 2000.
> If you have to migrate backwards, use SSIS to copy the objects and data
> from
> SQL Server 2005 to SQL Server 2000.
> --
> Message posted via droptable.com
> http://www.droptable.com/Uwe/Forum...server/200612/1
>

2005 DB backwards-compatible to 2000?

I've attached an SQL2000 db to an SQL2005 Std installation and am curious if
that process can go the other way. Can you detach from 2005 and attach to
2000 without any issues?Earl wrote:
> Can you detach from 2005 and attach to
> 2000 without any issues?
No. One cannot attach a higher version database to a lower version SQL
Server. The 2005 file format is incompatible with SQL Server 2000.
If you have to migrate backwards, use SSIS to copy the objects and data from
SQL Server 2005 to SQL Server 2000.
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200612/1|||No, You can not do that because of architectural changes.
Thanks
Hari
"Earl" <brikshoe@.newsgroups.nospam> wrote in message
news:%23ye9a5kHHHA.3540@.TK2MSFTNGP02.phx.gbl...
> I've attached an SQL2000 db to an SQL2005 Std installation and am curious
> if that process can go the other way. Can you detach from 2005 and attach
> to 200use of 0 without any issues?
>|||Ahhh, thanks Chris and Hari. Tis' the answer I need.
"Chris O'C via SQLMonster.com" <u29189@.uwe> wrote in message
news:6aacc6ece6f0b@.uwe...
> Earl wrote:
>> Can you detach from 2005 and attach to
>> 2000 without any issues?
> No. One cannot attach a higher version database to a lower version SQL
> Server. The 2005 file format is incompatible with SQL Server 2000.
> If you have to migrate backwards, use SSIS to copy the objects and data
> from
> SQL Server 2005 to SQL Server 2000.
> --
> Message posted via SQLMonster.com
> http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200612/1
>