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 |
|
fmardani
Constraint Violating Yak Guru
433 Posts |
 Posted - 2005-02-28 : 08:46:43
|
| Hi guys,I am going to place a extra hard disk inside the Dev sql server machine. The idea is to place the .mdf and .ldf on separate drives so that we get a better performance.Once the drive is correctly installed, then is it just a matter of deleting the existing .ldf and adding a new one which points to the new hard disk?Thanks |
|
|
franco
Constraint Violating Yak Guru
255 Posts |
Posted - 2005-02-28 : 10:55:22
|
| It's a matter of detaching the database with sp_detach_db stored procedure or thru EM and then re-attach db pointing to the new location for the ldf file.D'ont delete the old ldf file (rename it instead)and perform a full backup before proceding.BTW, for a replicated database to be detached, it must be unpublished.Franco |
 |
|
|
|
|
|
.ldf