|
Home > Archive > MS SQL Server > October 2006 > SQL Server running data off of USB / Firewire hard drive
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
SQL Server running data off of USB / Firewire hard drive
|
|
| mrobins@gmail.com 2006-10-28, 7:14 pm |
| 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
| |
| John Bell 2006-10-31, 12:15 am |
| 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
"mrobins@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
>
>
|
|
|
|
|