Groups | Blog | Home
all groups > sql server msde > december 2005 >

sql server msde : Business Contact Manager Database locations on partitioned drive



Morse1
12/10/2005 10:01:02 AM
MVP on the Outlook 2003/BCM group suggested I bring this question to SQL
server msde:

I have a partitioned drive with the "C" partition holding only system files
and enough room for a manually sized swap file. Therefore, I need to have
the BCM database files reside on the "D" partition. How can I accomplish
Morse1
12/10/2005 12:03:02 PM
OK, I understand editing the target and data directories' paths, but do not
know where to find the file to edit or what object to use to edit. Could you
hold my hand?

The system I am working with is W2K Server, with XPPro workstations and
Outlook 2003/BCM.

[quoted text, click to view]
Andrea Montanari
12/10/2005 7:41:00 PM
hi,
[quoted text, click to view]

you can perhaps specify (MSDE 2000) to install binaries and data on another
drive (see DATADIR and TARGETDIR parameters in
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/distsql/distsql_84xl.asp)
just remember that a minor part of binaries will be installed anyway in
\Program Files\Microsoft SQL Server\80 ... those files are shared among all
installable instances (up to 16 per machine) and can not be relocated...
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org
DbaMgr2k ver 0.16.0 - DbaMgr ver 0.61.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
--------- remove DMO to reply

Andrea Montanari
12/12/2005 12:16:15 PM
hi,
[quoted text, click to view]

you can both "edit" an .Ini file to specify such arbitrary options like
<--your_inifile.ini-->
[Options]
TARGETDIR="D:\MyInstance\Binn\"
DATADIR="D:\MyInstance\Data\"
</--your_inifile.ini-->

and provide the Ini file spec to the setup.exe bootstrap installer
c:\...\>setup.exe /settings your_inifile.ini .... additional parameters...

or provide all parameters (and this is the way I prefer) as command line
parameters to the setup.exe bootstrap installer, like
c:\...\>setup.exe TARGETDIR="D:\MyInstance\Binn\"
DATADIR="D:\MyInstance\Data\" SECURITYMODE=SQL SAPWD=your_pwd etc...

please provide a final
/L*v "c:\MsdeLog.txt"
parameter to enable verbose logging of the installation process, that will
result in an about 2mb text file you can inspect in case of troubles...
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org
DbaMgr2k ver 0.16.0 - DbaMgr ver 0.61.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
--------- remove DMO to reply

Got something to say? Click here to post a reply to this thread.
Don't see what you're looking for? Try a search.
View other messages about sql server msde
AddThis Social Bookmark Button
View Other Months
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
home · blog · groups Questions? Comments? Contact the dn