64bit vs 32bit  
Author Message
River_Rat





PostPosted: Wed Jul 05 15:04:44 CDT 2006 Top

SQL Server >> 64bit vs 32bit

If I create a database on 64bit version of SQL 2005 and then copy it to a
32bit version SQL 2005 will that database still work? and/or will
adminstrators have to make setting changes?

SQL Server69  
 
 
Geoff





PostPosted: Wed Jul 05 15:04:44 CDT 2006 Top

SQL Server >> 64bit vs 32bit All Editions of SQL within a major version maintain user database on-disk
compatibility across all architectures. That is a very complex way of
saying that any database created on any version/edition/processor
combination of SQL 2005 can be restored or copied to a SQL instance on any
other version/edition/processor combination. The sole exception is that SQL
Express will not accept a database over its 4GB size limit.

--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP






> If I create a database on 64bit version of SQL 2005 and then copy it to a
> 32bit version SQL 2005 will that database still work? and/or will
> adminstrators have to make setting changes?


 
 
Mike





PostPosted: Wed Jul 05 19:05:33 CDT 2006 Top

SQL Server >> 64bit vs 32bit This is a multi-part message in MIME format.
--------------080803020901070905080703
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

In other words "yes it will work, all other things being equal".

;)

--
*mike hodgson*
http://sqlnerd.blogspot.com





>All Editions of SQL within a major version maintain user database on-disk
>compatibility across all architectures. That is a very complex way of
>saying that any database created on any version/edition/processor
>combination of SQL 2005 can be restored or copied to a SQL instance on any
>other version/edition/processor combination. The sole exception is that SQL
>Express will not accept a database over its 4GB size limit.
>
>
>

--------------080803020901070905080703
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<tt>In other words "yes it will work, all other things being equal".<br>
<br>
;)<br>
</tt>
<div class="moz-signature">
<title></title>
<meta http-equiv="Content-Type" content="text/html; ">
<p><span lang="en-au"><font face="Tahoma" size="2">--<br>
</font></span> <b><span lang="en-au"><font face="Tahoma" size="2">mike
hodgson</font></span></b><span lang="en-au"><br>
<font face="Tahoma" size="2"><a href="http://sqlnerd.blogspot.com">http://sqlnerd.blogspot.com</a></font></span>
</p>
</div>
<br>
<br>


<pre wrap="">All Editions of SQL within a major version maintain user database on-disk
compatibility across all architectures. That is a very complex way of
saying that any database created on any version/edition/processor
combination of SQL 2005 can be restored or copied to a SQL instance on any
other version/edition/processor combination. The sole exception is that SQL
Express will not accept a database over its 4GB size limit.

</pre>
</blockquote>
</body>
</html>

--------------080803020901070905080703--