<div>
You can either:<br />
1. Backup and restore or<br />
2. Detach, copy data files and attach.
</div>


You can either:
1. Backup and restore or
2. Detach, copy data files and attach.

<div>
You want to copy the database from SQL 2000 to SQL 2008?<br />
<br />
There are several methods.<br />
Detach the database<br />
Copy the database files to the SQL 2008 server.<br />
Re-Attach the database.<br />
Setup the logins on the SQL 2008 Server.<br />
&nbsp; &nbsp;<a href="http://support.microsoft.com/kb/246133" rel="ugc">http://support.microsoft.com/kb/246133</a><br />
Change Compatibility mode to SQL 2008 for the database and Page Verify option to &quot;CheckSum&quot;<br />
<br />
<br />
Another method is to backup the SQL 2000 database.<br />
Restore the backup file to the SQL 2008 server<br />
Complete the last three steps described above.<br />

</div>


You want to copy the database from SQL 2000 to SQL 2008?

There are several methods.
Detach the database
Copy the database files to the SQL 2008 server.
Re-Attach the database.
Setup the logins on the SQL 2008 Server.
   http://support.microsoft.com/kb/246133 [http://support.microsoft.com/kb/246133]
Change Compatibility mode to SQL 2008 for the database and Page Verify option to "CheckSum"


Another method is to backup the SQL 2000 database.
Restore the backup file to the SQL 2008 server
Complete the last three steps described above.


<div>
Here is a MS article describing the attach/detach method.<br />
<a href="http://support.microsoft.com/kb/224071" rel="ugc">http://support.microsoft.com/kb/224071</a>
</div>


Here is a MS article describing the attach/detach method.
http://support.microsoft.com/kb/224071 [http://support.microsoft.com/kb/224071]

<div>
No I want to make a copy of the 2000 database within the same server, with a different name of course.
</div>


No I want to make a copy of the 2000 database within the same server, with a different name of course.

<div>
<div class="content wysiwyg-content">
How do I copy a SQL server database? &nbsp;This is SQL server 2000.
</div>
</div>


How do I copy a SQL server database?  This is SQL server 2000.

copy a database

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.