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 |
|
werk
Starting Member
2 Posts |
 Posted - 2003-01-09 : 20:56:05
|
| have a very large database (300 GB) on SQL Server 7 that consists of five DB files (3 data and 2 log). Two of the files (1 log and 1 data) are currently living on the internal drives, and I would like to remove them off the non-RAIDed drives and place them onto a new RAID array. I was thinking that the best way to do this would be to use sp_detach_db, move the file and then reattach all the files.My question is, does anyone see a problem with detaching a big DB from the server? Both files I'm moving are around 2GB only.Thanks,Jeremy |
|
|
byrmol
Shed Building SQL Farmer
1591 Posts |
Posted - 2003-01-09 : 21:03:40
|
| No worries.DavidM"SQL-3 is an abomination.." |
 |
|
|
JamesH
Posting Yak Master
149 Posts |
Posted - 2003-01-14 : 12:42:05
|
| I've done it on several databases larger than 500GB with no problems. It's really click if the array is local which it sounds like yours is.JamesH. |
|
|
|
|
|
|
Detaching a VLDB