BizTalk Server - Change Location of BizTalk 2004 SQL Data and log files during inst

This is Interesting: Free IT Magazines  
Home > Archive > BizTalk Server > April 2007 > Change Location of BizTalk 2004 SQL Data and log files during inst





You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author Change Location of BizTalk 2004 SQL Data and log files during inst
MS

2007-04-17, 7:16 am

Hi,

Is there any way to specify Location of SQL Database Log file( ldf) and Data
files(mdf) location during intall or configuration of BizTalk 2004?

Thanks
Saravana Kumar

2007-04-20, 1:20 pm

Hello there,

As far as I know there is no option for it while during installation or
configuration. But you can modify them after the configuration.

I'm assuming, you are going to do this step directly after your BizTalk
configuration. If in case you BizTalk services are running, stop them (BTS
and SSO).

Use SQL Enterprise manage
1. Make a note of the current location of mdf and ldf files
2. Right click on the corresponding database node you need to change, select
"DETACH";
3. Using Windows Explorer, move your mdf and ldf files to a new location .
4. Open SQL Enterprise manage, right click on database node, select
"ATTACH", select the mdf file from new location and click "OK".

--
Regards,
Saravana Kumar
http://www.biztalk247.com/v1/
http://www.digitaldeposit.net/blog


"MS" wrote:

> Hi,
>
> Is there any way to specify Location of SQL Database Log file( ldf) and Data
> files(mdf) location during intall or configuration of BizTalk 2004?
>
> Thanks

Sponsored Links






Free braindumps | Software forum | Database administration forum

Copyright 2003 - 2008 webservertalk.com