http://blogs.msdn.com/b/repltalk/archive/2010/11/29/how-to-move-mdf-ndf-for-a-replicated-database.aspxHow to move MDF/NDF for a Replicated Database Chris Skorlinski Microsoft SQL Server Escalation Services Here is another customer question about Replication I thought worth sharing. I am using SQL Server 2008 64 bits. I have to change the location of theen-USTelligent Evolution Platform Developer Build (Build: 5.6.50428.7875)http://blogs.msdn.com/b/repltalk/archive/2010/11/29/how-to-move-mdf-ndf-for-a-replicated-database.aspx#10098017Mon, 29 Nov 2010 22:15:30 GMT91d46819-8472-40ad-a661-2c78acb4018c:10098017Ben Thul<p>It should be noted that that doesn&#39;t actually move the physical file, but it modifies the system catalogs to look in the new location the next time the database is started. &nbsp;In order to move the physical file, you can do &#39;alter database &lt;db_name&gt; set offline&#39;, move the file, and then &#39;alter database &lt;db_name&gt; set online&#39;.</p> <div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10098017" width="1" height="1">