|
sql
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
SQL Server running data off of USB / Firewire hard driveDoes anyone have any experience setting up SQL server with the data
stored on an external (USB / Firewire) hard drive. This setup would be used by 1 or 2 users for data analysis, it would not be intended as a production server. If anyone has tried this, I am interested in any idea of what size database (in GBs) could be analyzed effectively off of an external hard drive on a fast (dual-core) laptop. Thank you, Matt Hi
I have used a USB disc as a stop-gap solution, accessing a USB disc is not the fastest or devices and it is noticably slower than the internal hard drive. If you are looking at data intensive activities I would not recommend this. If you do have a database on an external hard drive make sure that the external disc is switched on before the PC otherwise if SQL Server can not access the data files the database will be marked as suspect. John Show quoteHide quote "mrob***@gmail.com" wrote: > Does anyone have any experience setting up SQL server with the data > stored on an external (USB / Firewire) hard drive. > > This setup would be used by 1 or 2 users for data analysis, it would > not be intended as a production server. > > If anyone has tried this, I am interested in any idea of what size > database (in GBs) could be analyzed effectively off of an external hard > drive on a fast (dual-core) laptop. > > Thank you, > > Matt > >  
Thread options
Other interesting topics
Transaction Log Backup Job Failing
Sql Database Recovery Where does "Application" come from in Activity Monitor? SQL Server running data off of USB / Firewire hard drive Table locks / logging Incorrect syntax near keyword "function". Explain temdb please ratio of disk traffic to network traffic Number of Days Of Week About implicit transactions in temp table |
|||||||||||||||||||||||
