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 |
|
jordanam
Yak Posting Veteran
62 Posts |
 Posted - 2007-12-07 : 10:17:12
|
| If I can get around taking a few databases offline, I'd like to. I need to get logfiles on a lower-capacity drive. Ideally, I wouldn't like to have multiple logfiles swimming around. But, I was thinking that if I created a second logfile, and then backed up the transaction log, I might be able to remove the first logfile?The other thought I had, was creating a second logfile, and then turning off autogrow on the first log. Maybe there is a better solution? Maybe neither of these will work?Thoughts? |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-12-07 : 23:17:31
|
| You can create second log file, shrink first log file with emptyfile option then remove it. |
 |
|
|
jordanam
Yak Posting Veteran
62 Posts |
Posted - 2007-12-12 : 09:20:30
|
| Ah, thank you! |
|
|
|
|
|
|
Change logfile location without taking offline