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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-04-02 : 06:26:48
|
| Sal writes "Short and Sweet; Is there any way to move a DB file while SQL Server is in operation? Preferably with controlled performance impact?More Detail;We are short of space on our Production database Server. It has a 200 GB Partition that is nearly full. In order to expand the available space, we have acquired an External RAID array with 400 GB space currently provisioned and configured it as a Windows 2000 Dynamic Volume to facilitate future expansion.The current production partition can not be expanded. Therefore we need to move a 170 GB Database file to the new 400 GB partition.Problem is that Detach-Copy-Attach takes toooooo long. An attempt to execute this procedure ran for 6 hours before we ran out of time and had to abort.So the question; Can we move the DB while the SQL remains available? Is it possible to temporarily stop write access to the SQL (all transactions should go to Database logs) while we move the mdf file then replay the log against the Database?" |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-04-02 : 07:28:15
|
| How about a backup and restore (while the system works on the old database) followed by a tr log or differential restore to bring it up to date after taking the system down.Then rename the database to bring it on-line.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
Moving large mdf - hot