SQL Server 2005: A database on a different drive?

    Date: 11/22/06 (SQL Server)    Keywords: programming, database, sql

    I think I know the answer to this, but I want to see if anyone has a different one...

    I have a database (well, I have a spec, I'm not creating it until I know the answer to this question) I'd like to create on a flash drive. Is this possible? It seems to me that one has to create all databases from a given SQL Server instance in the same directory...

    (Basically, I'd like to be able to access the database from four SQL Server instances on two different networks and one non-networked computer-- because those are the locations I'll be programming the front-end app.)

    Source: http://community.livejournal.com/sqlserver/53898.html

« Data Warehouse / Data Mart... || hi all »


antivirus | apache | asp | blogging | browser | bugtracking | cms | crm | css | database | ebay | ecommerce | google | hosting | html | java | jsp | linux | microsoft | mysql | offshore | offshoring | oscommerce | php | postgresql | programming | rss | security | seo | shopping | software | spam | spyware | sql | technology | templates | tracker | virus | web | xml | yahoo | home