<div>
Take a backup of your database (full backup) along with running DBCC CHECKDB on the database. &nbsp;AFterwards, detach your database and copy the files over to the other server. &nbsp;Once you've copied them there attach them. &nbsp;
</div>


Take a backup of your database (full backup) along with running DBCC CHECKDB on the database.  AFterwards, detach your database and copy the files over to the other server.  Once you've copied them there attach them.  

<div>
WIll any currently setup sql jobs or replication be affected? In other words will I have to tweak all the scheduled jobs and such?
</div>


WIll any currently setup sql jobs or replication be affected? In other words will I have to tweak all the scheduled jobs and such?

<div>
IF it is on the same server then you won't need to change any of that stuff, no.
</div>


IF it is on the same server then you won't need to change any of that stuff, no.

<div>
sweet thanks...i will give a try..
</div>


<div>
when trying to detach the database in order to copy the system shows:<br />
<br />
attention: the database cannot be detached while it is being replicated
</div>


when trying to detach the database in order to copy the system shows:

attention: the database cannot be detached while it is being replicated

<div>
ok i got the disabling publushing wizard now and when trying to do this it says it could not diable publishing and distribtuion on &lt;server name&gt;<br />
<br />
Error 2812: Could not find stored procedure 'master...xp_commandshell'<wbr />
</div>


ok i got the disabling publushing wizard now and when trying to do this it says it could not diable publishing and distribtuion on <server name>

Error 2812: Could not find stored procedure 'master...xp_commandshell'

<div>
i was able to take the database offline and am now coppying it over
</div>


i was able to take the database offline and am now coppying it over

<div>
<div class="content wysiwyg-content">
I need to move a sql database to a new hard drive with more space for the db to grow. In SQL 2000 how can I do this?
</div>
</div>


I need to move a sql database to a new hard drive with more space for the db to grow. In SQL 2000 how can I do this?

How to properly move a sql database?

Microsoft SQL Server 2005 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. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.