Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
oceanboy
Starting Member
44 Posts |
 Posted - 2007-05-29 : 23:39:28
|
| Hello!I have 2 harddisk in my computer and I have SQL 2005 Express on 1 of them (let's say C:), however, my C: is going to be full soon! Once it is full, is it possible to create a table on my other harddisk which the server can recognise? Thanks!OB |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-05-30 : 16:36:43
|
| You can move db to another drive with detach and attach. |
 |
|
|
oceanboy
Starting Member
44 Posts |
Posted - 2007-05-31 : 07:02:05
|
| Hi Rmiao, can you elaborate more about this? Are detach and attach functionality of SQL Server? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-05-31 : 10:03:18
|
| Yes. You can right click on the db in ssms, go to tsks -> detach. Then move db files to new location, right click on databases and choose attch in ssms. |
|
|
|
oceanboy
Starting Member
44 Posts |
Posted - 2007-06-01 : 02:21:03
|
| thank! we made it! |
|
|
|
|
|
|
Multiple Hard Disk