cancel
Showing results for 
Search instead for 
Did you mean: 

Extend SQL Server 2005 table space to an external hard-disk

Former Member
0 Kudos

Hi,

How to extend the database table space to an external hard-disk. Actually the disk space in the server is less so I want to connect an external hard disk and extend the table space to that hard disk.

SAP - ECC 6.0

DB - SQL Server 2005.

Kindly help.

Regards,

Sriram

Accepted Solutions (1)

Accepted Solutions (1)

markus_doehr2
Active Contributor
0 Kudos

> How to extend the database table space to an external hard-disk. Actually the disk space in the server is less so I want to connect an external hard disk and extend the table space to that hard disk.

I assume you plan to use an USB drive, right?

Connect it and add a volume using SQL Server Management Console

BUT: Be aware that performance may degrade since USB is not a fast bus. Also be aware that if the drive fails (for whatever reason) the database will be down.

Markus

Answers (0)