<div>
you can back them up and restore them
</div>


<div>
We have detached the DBs and copied them over and are working - we need to UPGRADE the dbs themselves now
</div>


We have detached the DBs and copied them over and are working - we need to UPGRADE the dbs themselves now

<div>
if you restore a sql server 2000 database on a sql server 2005 instance, then it is upgraded during the restore operation
</div>


if you restore a sql server 2000 database on a sql server 2005 instance, then it is upgraded during the restore operation

<div>
We could not restore the .bak files and had to resort to attaching the data files to the new instance - they are nicely attached and we really just want to upgrade them where they are
</div>


We could not restore the .bak files and had to resort to attaching the data files to the new instance - they are nicely attached and we really just want to upgrade them where they are

<div>
Pretty obvious, but then again the right answers usually are!!!! &nbsp;Thanks!
</div>


Pretty obvious, but then again the right answers usually are!!!!  Thanks!

<div>
<div class="content wysiwyg-content">
Hi Experts,<br />
<br />
We've successfully detached, copied and re-attached our CRM dtabases from a SQL 2000 instance to a SQL 2005 instance. &nbsp;The are working fine but are version 8.0. &nbsp;We're reinstalling CRM 3.0 now and the media we are using seems to want us to upgrade the database version to 9.0. &nbsp;What is the safest and easiest way to get theese data bases that are already attached to the new SQL 2005 instance upgraded to 9.0<br />
<br />
Thanks in advance
</div>
</div>


Hi Experts,

We've successfully detached, copied and re-attached our CRM dtabases from a SQL 2000 instance to a SQL 2005 instance.  The are working fine but are version 8.0.  We're reinstalling CRM 3.0 now and the media we are using seems to want us to upgrade the database version to 9.0.  What is the safest and easiest way to get theese data bases that are already attached to the new SQL 2005 instance upgraded to 9.0

Thanks in advance

Upgrading databases from version 8.0 (2000) to 9.0 (2005)

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Small Business Server (SBS) is a line of server operating systems targeted at small businesses by bundling the operating system with a number of other Microsoft products that would normally need to be purchased or licensed separately. The most notable inclusions are Exchange, SQL Server, SharePoint and ISA/TMG (Microsoft's firewall and proxy server).