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 |
|
prashanth.1625
Starting Member
1 Post |
 Posted - 2010-07-13 : 07:37:14
|
| Hi All, My problem is that i have database of 270 GB in D drive only 30 GB left what is procedure in moving the data base to another drive location ..? I want to move database(270 G B)from the D drive to E drive or some other drive Can any help me in moving the database from one drive to another drive location . Thnks N Regards :Prashanth.kPh no 9916912516prashanth.k |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-07-13 : 07:55:06
|
One way would be to backup and restore with the needed drive and path.edit: this is to only move the data of a table and not the whole database - sorry.Another way could be if there isn't one then create a clustered index to move the data to the new location.
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2010-07-13 : 08:20:41
|
1) Backup the database2) Run DBCC CHECKDB to verify there are no errors3) Detach the database4) Move the files to the new location5) Attach the database6) Run DBCC CHECKDB again
N 56°04'39.26"E 12°55'05.63" |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2010-07-13 : 08:40:25
|
| Might be worth leaving either the MDF or LDF where it is - so that those two files are on separate drives - which will increase your redundancy in the event of a drive failure / database corruption (assuming you are using FULL Recovery Model) |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2010-07-13 : 09:39:12
|
| Another thing you could do is to create a new data file on the new drive that is in the same filegroup as the file on the D drive. You can do this without taking the database offline.SQL Server will distribute data over both drives as you insert data, rebuild indexes, etc.CODO ERGO SUM |
|
|
|
|
|
|
How to move the database from D drive to E drive