Can a SQL table be moved to another drive?

[hambstack]

Hi. I have MS SQL Server 7 installed on the C: drive of an NT Server. I am short on space on the C: drive and was wondering if it is possible to move a few of the SQL tables to the E: drive where more space exists.

Thanks,
Kim Hamb

 

[tlbroadbent]

You can move databases to a different drive. If you have put tables on different file groups, you can move the files to another drive. You can't move tables directly.

The easiest way to move a data base is to detach the database, move the database file(s) to the other drive and then attach the database. See the stored procedures sp_detach_db and sp_attach_db in SQL BOL.

If you want to move tables to different file groups on a different drive, see the topic "Placing Tables on Filegroups" in SQL BOL. Terry L. Broadbent - Salt Lake City, UT
Home of the 2002 Winter Olympics (Feb 8-24)

http://www.saltlake2002.com