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 |
|
rdugre
Starting Member
32 Posts |
 Posted - 2004-11-22 : 18:25:42
|
| Hopefully this is an easy question for someone on the forums.Currently, I have a bunch of databases with their transaction logs on the same physical disks as the databases (RAID 10). I now have a separate set of physical disks that I would like to move the transaction logs to. How do I go about moving the logs to the separate disks with minimal downtime?Thanks in advance. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-11-22 : 18:36:23
|
| sp_detach_db/sp_attach_db will be the fastest. You'll just need to detach them, copy the tlogs to the new drive, then attach them using the new path.Tara |
 |
|
|
|
|
|
Moving Trans Logs to Separate Disk