Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-04-11 : 08:49:49
|
| Dean Higginbotham writes "I read your "Programmatically Creating a SQL Database" submitted 8/4/00. My follow-up question is: how would you go about creating a database across a UNC path?I did some research and found that you could do it using the "DBCC TRACEON (1807)" command. The problem is that then you need to keep that setting on forever (as far as I could tell). And, if you turn it off (after using it to create databases), things get real messy.My customers use an ASP web application to create databases. I'd like to give them the flexibility to create their databases on servers other than the webserver.Thanks!" |
|
|
izaltsman
A custom title
1139 Posts |
Posted - 2002-04-11 : 09:45:08
|
| You should really consider installing SQL Server on the machines where you wish to place the data. If you place your data files on network shares (as opposed to the local disks of your SQL Box), your performance will suck, you might max out the bandwidth of your network, and on top of that, you will run the risk of data corruption due to network issues. Of course if you have a SAN -- it's a different story, but something tells me you don't have one, so my advice is -- set up one or more dedicated SQL Servers with plenty of disk space and have your web application make use of those servers.BTW, notice that I recommended dedicated boxes to run SQL Server. SQL Server is a resource-intensive application, so setting it up on the same machine as a web server is not a very good idea.---------------Strong SQL Developer wanted in the Boston area. Please e-mail if interested.Edited by - izaltsman on 04/11/2002 09:47:32 |
 |
|
|
garraeth
Starting Member
1 Post |
Posted - 2002-04-11 : 11:13:57
|
| I totally agree with what you say: put your SQL server on a dedicated maching.The reason I want to be able to make databases across UNC paths is that I made an ASP installation script for my program (see my sig). This installation script gives the user the option to create the necessary databases via the script. Like you said, I imagine that they might have five webservers and one big ol' SQL server machine. If they have such a setup, they'll want to have the installation script (it's ASP, so it must be run from one of the webserver machines) create the databases across a UNC path onto their SQL server machine.Thanks again!www.SiteBeater.com -- download the beta.Edited by - garraeth on 04/11/2002 11:16:14 |
|
|
|
|
|
|
|
|
Programmatically Creating a SQL Database across UNC path.