BizTalk Server General - RE: Change transaction data and log files location of biztalk data

Author

RE: Change transaction data and log files location of biztalk data

2005-11-28, 6:02 pm

Thanks a lot Mike,

I try it out.

Thanks
MS

"Mike Watson" wrote:
[vbcol=seagreen]
> Hi,
>
> Within the Microsoft Sql Server Enterprise Manager, right-click the DB that
> you want to move the physical log and data files.
> Select New -> Detach Database.
> The DB will be removed from your Sql Database list.
> Open MS Explorer and navigate to C:\Program Files\Microsoft SQL
> Server\MSSQL\Data (if all installed in the default directory!)...
> Move the %detached db name%.mdf and %detached db name%.LDF file to your new
> directory.
>
> In Microsoft Sql Server Enterprise Manager, right click on the Databases
> folder icon and select 'all tasks' -> Attach Database. Now locate the
> %detached db name%.mdf and click OK...
>
> This should work for you...
> Cheers,
> - Mike Watson
>
> "MS" wrote:
>