Howto install sql database files on remote path

greenspun.com : LUSENET : SQL Server Database Administration : One Thread

I'm working in an application that use MSDE. When installing my application i want to just put the database files in a remote PC while the MSDE must be installed in the local machine. How can i do it?(i am using C# as programming language of my App);

-- Anonymous, October 05, 2004

Answers

Ali,

By default, you cannot create a SQL Server database on a network file share. However, the following knowledge base article explains how to get around the default behavior and explains the tradeoffs.

http://support.microsoft.com/default.aspx? scid=http://support.microsoft.com:80/support/kb/articles/q304/2/61.AS P&NoWebContent=1&NoWebContent=1

(The URL is all on one line, of course.)

Good Luck,

Eric

-- Anonymous, October 05, 2004


Moderation questions? read the FAQ